Skip to content

SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB]

License

Notifications You must be signed in to change notification settings

jamietanna/sql-studio

 
 

Repository files navigation

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

overview overview dark

Tables Page

tables tables dark

Query Page

query query dark

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

About

SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB]

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Rust 52.2%
  • TypeScript 42.2%
  • Nix 2.0%
  • JavaScript 2.0%
  • CSS 1.1%
  • HTML 0.5%