sqlite-studio

SQL Studio: Your Ultimate SQL Database Explorer

Welcome to SQL Studio, a powerful and intuitive SQL database explorer designed for seamless interaction with your databases. This versatile tool allows you to manage multiple SQL database types, including SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB, and ClickHouse with just a single command!

Key Features

• Overview Page: Get quick access to essential metadata about your database.
• Tables Page: Dive deeper into each table's metadata with ease.
• Queries Page: Powered up interface for executing custom queries with rich SQL IntelliSense.
• Infinite Scroll Rows View: Effortlessly navigate through extensive datasets without page refreshes.

Easy Access Commands

Using SQL Studio is straightforward with the following commands:

Local SQLite Database

sql-studio sqlite [sqlite_db]

Remote libSQL Server

sql-studio libsql [url] [auth_token]

Local SQLite Database with libSQL Driver

sql-studio local-libsql [database]

Connect to PostgreSQL Server

sql-studio postgres [url]

Connect to MySQL/MariaDB Server

sql-studio mysql [url]

Local DuckDB File

sql-studio duckdb [duckdb_file]

ClickHouse Server (Partial Support)

sql-studio clickhouse [URL] [USER] [PASSWORD] [DATABASE]

Explore More

For additional features and updates, visit our releases page.

Visual Insights

Experience SQL Studio's rich user interface through our screenshots:

• Overview Page
• Tables Page
• Query Page

(Note: Images for the screenshots are hosted elsewhere and should be referenced directly)

Get Started with SQL Studio

Whether you prefer shell scripts, Docker, or using Nix, SQL Studio offers flexible installation options to suit your workflow. Robust performance and user-friendly management tools ensure that you spend less time configuring and more time developing.

Embrace the ease of exploring your SQL databases with SQL Studio today!