sql-studio

SQL Studio is a powerful, single-command SQL database explorer designed for seamless interaction with various SQL databases, including SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB, and ClickHouse. This versatile tool provides an intuitive overview of your database and simplifies the process of executing complex queries.

Key Features

• User-Friendly Overview: Access and manage common metadata with ease.
• Detailed Table Insights: Browse through tables along with their metadata for enhanced understanding.
• Advanced Query Capabilities: Utilize the queries page for deeper access and control over your database.
• Infinite Scrolling: Effortlessly navigate through rows of data without the hassle of pagination.
• Rich SQL IntelliSense: Get intelligent code suggestions while crafting custom SQL queries.

Usage Examples

Explore SQL Studio effortlessly with the following command examples:

Access Local SQLite Database

sql-studio sqlite [sqlite_db]

Connect to Remote libSQL Server

sql-studio libsql [url] [auth_token]

Use Local SQLite DB with libSQL Driver

sql-studio local-libsql [database]

Query a PostgreSQL Server

sql-studio postgres [url]

Interact with MySQL/MariaDB Server

sql-studio mysql [url]

Access Local DuckDB File

sql-studio duckdb [duckdb_file]

Connect to ClickHouse Server (Partial Support)

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

Discover more features and updates on the releases page.

Screenshots

Gain insights into the user interface with the following screenshots:

• Overview Page
  
• Tables Page
  
• Query Page
  

SQL Studio empowers database enthusiasts and developers alike with its streamlined design and extensive features, making database management and query execution simpler and more efficient.