3,693 stars · MIT, read from /blob/main/LICENSE — plain and unmodified, holder named 'Copyright (c) 2024 frectonz'. Cargo.toml declares NO license field and no license-file, which is why the crate is not on crates.io · 0.1.53 (2026-08-26), read from /releases/latest as a yearless '26 Aug 15:03' and settled by the ungh releases/latest record (2026-08-26T15:03:19Z). crates.io 404s for this name · Track this in Scout
One command opens a browser page that explores any of nine kinds of database, including CSV and Parquet files.
▶Repo detailsthe review · specs · pros & cons · install
What it is
SQL Studio is a single program that reads a database and serves a small web page describing it. It covers SQLite, libSQL, PostgreSQL, MySQL and MariaDB, DuckDB, ClickHouse and Microsoft SQL Server, plus Parquet and CSV files; ClickHouse is marked as partly supported on its own page.
What it is good for. The moment when a database file lands on a machine and nobody can say what is in it. A full database tool is a large install and a long first hour; this is one file, one command, and a page that answers the obvious questions. It is also useful for a CSV file too large to open in a spreadsheet.
- Plain, unmodified MIT licence with a named holder, which is the simplest licence situation in this edition.
- Nine database kinds through one program, so the same habit works whatever the project uses.
- Two minutes to a working page. No configuration file exists.
- It has no login, and it can write. There is no password option of any kind on the web page. The query box hands whatever you type straight to the database, so
DELETEandDROPwill run. It opens your own database file for reading and writing; only the bundled demo file is read-only. - The documented container command binds to every network interface —
--address=0.0.0.0:3030is printed in the project's own instructions with no warning beside it. Anyone who can reach that port gets a database console with no password. On a laptop it defaults to127.0.0.1:3030, which is the machine itself only, and that is the safe way to use it. - The headline install pipes a script from the internet straight into a shell, and the Windows version also tells you to switch off the execution policy first. The project's
Cargo.tomldeclares no licence field, so the crate is not published to crates.io, and the README still installs version 0.1.52 while 0.1.53 is current. No memory, disk or processor figure is published anywhere.
- coleifer/sqlite-web
The closest match in shape, one command and a browser page with a query box, but SQLite only and it needs Python installed.
Track this in Scout - beekeeper-studio/beekeeper-studio
A desktop application covering the same browsing and querying, with a free GPL-3.0 edition and a paid commercial edition beside it.
Track this in Scout - dbeaver/dbeaver
Far deeper tooling across many more databases, at the cost of a large Java application and a driver download before anything works.
Track this in Scout
docker run -p 3030:3030 frectonz/sql-studio /bin/sql-studio --no-browser --no-shutdown --address=127.0.0.1:3030 sqlite preview
