I built db-studio, a free, open-source database studio you can run with npx

Description and use

db‑studio is a free, open‑source database GUI that runs with a single npx db-studio command. It supports nine database engines, offers spreadsheet‑style editing, query execution, schema diagrams, and optional AI assistance.

Problem

Developers need a lightweight, cross‑engine database GUI that can be launched with a single command and does not require a hosted account.

Outcome

db‑studio offers a single‑command, local database studio that supports PostgreSQL, MySQL, SQL Server, MongoDB, SQLite, Redis, DuckDB, Oracle, ClickHouse, and more, with spreadsheet‑style editing, query execution, schema visualization, and optional AI assistance.

Workflow

• 1. Run npx db-studio from a project directory.
• 2. If a DATABASE_URL exists in .env or the environment, db‑studio connects automatically; otherwise paste the URL on the Connect page.
• 3. Open the local address shown in the terminal to access the web UI.
• 4. Use the table editor to edit data like a spreadsheet, copy rows as JSON or SQL, and undo changes.
• 5. Run queries with syntax highlighting, autocomplete, and export results to CSV, Excel, or JSON.
• 6. View schema diagrams for relational databases and browse related records via foreign keys.
• 7. Optionally enable AI assistance with a provider key to write or optimize queries.

Evidence

Run the command from your project directory. db-studio looks for a DATABASE_URL in your project's .env file or environment.

Source

Edit data like a spreadsheet

Source

db-studio supports PostgreSQL, MySQL, SQL Server, MongoDB, SQLite, Redis, DuckDB, Oracle, and ClickHouse.

Source