// the find
frectonz/sql-studio
SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, ClickHouse, DuckDB, Microsoft SQL Server]
A single-binary SQL database explorer that runs a local web UI for querying and browsing databases. Supports an unusually wide range of backends — SQLite, PostgreSQL, MySQL, DuckDB, ClickHouse, MSSQL, libSQL, Parquet, and CSV — all from one command. Aimed at developers who want something lighter than DBeaver or TablePlus for quick database inspection.
Single binary with zero runtime dependencies means you can drop it on a server and immediately browse a Postgres or SQLite file without installing anything else. The Rust backend embeds the entire UI statically, so there's no asset server to run. DuckDB, Parquet, and CSV support in the same tool is genuinely useful for data exploration workflows without switching tools. The ERD viewer is a practical addition that most CLI-adjacent DB tools skip.
ClickHouse support is explicitly marked 'partial' with no documentation on what's missing, which makes it unreliable for anything serious. No authentication or access control — if you run this with --no-shutdown on a server, the connection string and all your data are exposed to anyone who can reach the port. The UI build step (npm build required before cargo run) adds friction for contributors and means the binary size is inflated with bundled JS. Query history and saved queries don't appear to exist, which becomes annoying fast in any real session.