# frectonz/sql-studio

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

Repository: https://github.com/frectonz/sql-studio
Canonical: https://ross.abutalabs.com/products/sql-studio
Homepage: https://sql-studio-docs.frectonz.et
Language: Rust
License: MIT
License Family: permissive
Topics: rust, sqlite, sqlite-browser, libsql, postgresql, mariadb, mysql, mssql, microsoft-sql-server, duckdb, clickhouse
Last push: 2026-08-26T14:32:48+00:00

## Health v2 (maintenance only)
Score: 91/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 99, longevity 58
- inputs: {"age_days": 813, "days_push": 7, "days_rel": 7, "gap_med": 1.0, "n_releases_24m": 23}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3683, forks 130 (observed 2026-08-28T04:08:13.804127+00:00)

## What it is
SQL Studio is a single-binary, web-based SQL database explorer written in Rust that supports SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB, ClickHouse, Microsoft SQL Server, Parquet, and CSV files. It provides a browser UI with schema browsing, table exploration, a Monaco-powered SQL editor with IntelliSense, and interactive ERD diagrams.

## Use cases
- browse a sqlite database with a gui
- explore postgres tables and run queries
- visualize database schema as an erd diagram
- inspect a parquet or csv file with sql
- query a duckdb analytics file in a browser
- connect to a turso libsql database
- view mysql table data without installing a heavy client

## When to choose
- you want a zero-config, single-binary tool to explore many SQL databases
- you need a lightweight alternative to DBeaver or pgAdmin for quick browsing
- you want to inspect local files like SQLite, DuckDB, Parquet, or CSV
- you prefer self-hosted tools served locally in your browser

## When to avoid
- you need full database administration features like user management or backups
- you need a native desktop application rather than a browser-based UI
- you require multi-database connections open simultaneously in one session
- you need write-heavy data editing workflows rather than exploration

## Facets
- artifact type: application
- maturity: active
- function: database, developer-tools, gui, cli, data-visualization
- domain: databases, developer-tools, self-hosted, data-science
- platform: windows, self-hosted, cli, rust
- tags: sql-explorer, database-gui, single-binary, sqlite-browser, sql-editor, erd-diagram, turso, parquet, csv, linux, macos, docker, web-server

## Member repositories
- frectonz/sql-studio (main) score 91

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:13.804127+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:31:11.828076+00:00, confidence not recorded.
  - readme: https://github.com/frectonz/sql-studio (fetched 2026-08-28T04:08:13.804127+00:00, sha 4c35020b2f27)
  - homepage: https://sql-studio-docs.frectonz.et (fetched 2026-08-29T09:25:11.403659+00:00, sha 3db7a50fe533)
  - site_page: https://sql-studio-docs.frectonz.et/docs (fetched 2026-08-29T09:25:11.406016+00:00, sha ad379eee1aac)
  - site_page: https://sql-studio-docs.frectonz.et/docs/installation (fetched 2026-08-29T09:25:11.407879+00:00, sha 0a8da4b8c7ab)
  - site_page: https://sql-studio-docs.frectonz.et/docs/databases/sqlite (fetched 2026-08-29T09:25:11.409528+00:00, sha 04a6c9676058)
  - site_page: https://sql-studio-docs.frectonz.et/docs/databases/postgresql (fetched 2026-08-29T09:25:11.411281+00:00, sha 9f449278cb2c)
  - site_page: https://sql-studio-docs.frectonz.et/docs/databases/mysql (fetched 2026-08-29T09:25:11.412934+00:00, sha 347294d1ef90)
  - site_page: https://sql-studio-docs.frectonz.et/docs/databases/duckdb (fetched 2026-08-29T09:25:11.414664+00:00, sha 73301a1ec20f)
  - site_page: https://sql-studio-docs.frectonz.et/docs/databases/libsql (fetched 2026-08-29T09:25:11.416547+00:00, sha 4c9c3d0d779c)
  - site_page: https://sql-studio-docs.frectonz.et/docs/databases/clickhouse (fetched 2026-08-29T09:25:11.418281+00:00, sha 132f7e2d6350)
- Data as of 2026-08-30T08:39:29.467469+00:00.