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]

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

Tables Page

Query Page

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.12/sql-studio-installer.sh | sh

Install prebuilt binaries via powershell script

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

Updating

sql-studio-update

Nix

nix shell github:frectonz/sql-studio # currently broken

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 [email protected]:frectonz/sql-studio.git
cd sql-studio
nix develop # if you use nix
cd ui
npm install
npm run build
cd ..
cargo run