SQL Studio

Single binary, single command SQL database explorer. SQL studio supports SQLite, libSQL, PostgreSQL, MySQL, DuckDB, ClickHouse, Microsoft SQL Server, Parquet and CSV.

Documentation

Local SQLite DB File

sql-studio sqlite [sqlite_db]

libSQL

sql-studio libsql [database] [auth_token]

PostgreSQL Server

sql-studio postgres [url]

MySQL/MariaDB Server

sql-studio mysql [url]

Local DuckDB File

sql-studio duckdb [duckdb_file]

Local Parquet File

sql-studio parquet [parquet_file]

Local CSV File

sql-studio csv [csv_file]

ClickHouse Server

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

Microsoft SQL Server

sql-studio mssql [connection]

Features

• Overview page with common metadata.
• Tables page with each table's metadata.
• Queries page with more access to your db.
• Infinite scroll rows view.
• Rich SQL IntelliSense for custom queries.

More features available on the releases page.

Screenshots

Overview Page

Tables Page

Query Page

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

Install prebuilt binaries via powershell script

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

Updating

sql-studio-update

Nix

nix shell nixpkgs#sql-studio

Docker

A Docker image of SQL Studio is available on Docker Hub. The following is an example of how to run SQL Studio with the Postgres driver on port 3030.

docker run -p 3030:3030 frectonz/sql-studio /bin/sql-studio \
  --no-browser \
  --no-shutdown \
  --address=0.0.0.0:3030 \
  postgres \
  postgres://localhost:5432/

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