Awesome
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.
- Queries page with more access to your db.
- Infinite scroll rows view.
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.27/sql-studio-installer.sh | sh
Install prebuilt binaries via powershell script
powershell -c "irm https://github.com/frectonz/sql-studio/releases/download/0.1.26/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