Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|
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.52/sql-studio-installer.sh | shpowershell -ExecutionPolicy Bypass -c "irm https://github.com/frectonz/sql-studio/releases/download/0.1.52/sql-studio-installer.ps1 | iex"sql-studio-updatenix shell nixpkgs#sql-studioA 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 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