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

说明与用途

db‑studio 是一个免费、开源的数据库图形界面，可通过单条 npx db-studio 命令启动。它支持九种数据库引擎，提供类似电子表格的编辑、查询执行、架构图以及可选的 AI 帮助。

问题

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

结果

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.

工作流

• 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.

证据

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

来源

Edit data like a spreadsheet

来源

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

来源