/sql-studio

SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB, ClickHouse]

Primary LanguageRustMIT LicenseMIT

banner

SQL Studio

Single binary, single command SQL database explorer. SQL studio supports SQLite, libSQL, PostgreSQL, MySQL and DuckDB.

Local SQLite DB File

sql-studio sqlite [sqlite_db]

Remote libSQL Server

sql-studio libsql [url] [auth_token]

PostgreSQL Server

sql-studio postgres [url]

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]

Features

  • Overview page with common metadata.
  • Tables page with each table's metadata, including the disk size being used by each table.
  • Infinite scroll rows view.
  • A custom query page that gives you more access to your db.

More features available on the releases page.

Screenshots

Overview Page

overview overview dark

Tables Page

tables tables dark

Query Page

query query dark

Installation

Install prebuilt binaries via shell script (MacOS and Linux)

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/frectonz/sql-studio/releases/download/0.1.21/sql-studio-installer.sh | sh

Install prebuilt binaries via powershell script

powershell -c "irm https://github.com/frectonz/sql-studio/releases/download/0.1.21/sql-studio-installer.ps1 | iex"

Updating

sql-studio-update

Nix

nix shell github:frectonz/sql-studio

Contributing

Before executing cargo run you need to build the UI because the rust app statically embedded the UI files in the binary.

git clone git@github.com:frectonz/sql-studio.git
cd sql-studio
nix develop # if you use nix
cd ui
npm install
npm run build
cd ..
cargo run