Single binary, single command SQL database explorer. SQL studio supports SQLite, libSQL, PostgreSQL, MySQL, DuckDB, ClickHouse, Microsoft SQL Server, Parquet and CSV.
sql-studio sqlite [sqlite_db]
sql-studio libsql [database] [auth_token]
sql-studio postgres [url]
sql-studio mysql [url]
sql-studio duckdb [duckdb_file]
sql-studio parquet [parquet_file]
sql-studio csv [csv_file]
sql-studio clickhouse [URL] [USER] [PASSWORD] [DATABASE]
sql-studio mssql [connection]
- 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.
curl --proto '=https' --tlsv1.2 -LsSf https://github.com/frectonz/sql-studio/releases/download/0.1.53/sql-studio-installer.sh | sh
powershell -ExecutionPolicy Bypass -c "irm https://github.com/frectonz/sql-studio/releases/download/0.1.53/sql-studio-installer.ps1 | iex"
sql-studio-update
nix shell nixpkgs#sql-studio
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/
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