默认只监听 127.0.0.1，要在局域网访问需设置 HOST 并把访问用的主机名或 IP 加入 ALLOWED_HOSTS，之后还需输入启动时打印的密码或 DB_STUDIO_PASSWORD；默认端口是 3333，被占用时用 --port 改；AI 功能需自备 Gemini、OpenAI、Anthropic 等厂商的 API Key；默认会收集匿名使用数据，可用 DB_STUDIO_TELEMETRY=0 关闭
db-studio
husamql3Apache-2.0活跃维护一站式开源数据库图形界面，用同一个客户端连接 SQL、文档和键值数据库，省去在多个管理工具之间来回切换。
Every database. One studio. A free, open-source database GUI for SQL, document, and key-value databases.
v2.2.1发布于 2026-11-04 11:19 UTC313star +3 / 7 天29fork同步于 2026-11-10 12:02 UTC
npx db-studio 硬件要求按 README 说明
README 未说明；工具以 npx 或 Docker 方式运行，未提及显存、GPU 或 CPU 要求
有 Docker 镜像
一条 npx 命令启动的免费开源数据库 GUI，用同一个界面管理 SQL、文档和键值数据库
一站式开源数据库图形界面，用同一个客户端连接 SQL、文档和键值数据库，省去在多个管理工具之间来回切换。
核心能力
- 用单个连接 URL 接入 PostgreSQL、MySQL、MongoDB、Redis 等十余种数据库
- 表格网格支持行内编辑、筛选排序分页和实时刷新高亮变更
- 支持从 CSV、Excel、JSON 批量导入记录并导出表数据
- Monaco 编辑器运行查询，带语法高亮和自动补全
- 接入自带 API Key 的 AI 助手，用自然语言提问并生成或修复查询
容易踩的坑
内容由模型根据 README 生成，可能不完整或不准确，以官方文档为准。看原文 README
- v2.2.1最新正式版2026-11-04 · 2026-11-04 11:19 UTC
Bug Fixes
- The Linux AppImage opens faster — @husamql3
Desktop app
Installers are under Assets. Which one to pick and how to install: https://dbstudio.sh/docs/desktop
macOS: the app is not signed yet, so run
xattr -dr com.apple.quarantine /Applications/db-studio.appafter installing. - v2.2.02026-11-02 · 2026-11-02 22:12 UTC
查看更新说明
Improvements
- Browse MongoDB documents in individual cards with collapsible fields and editor colors — @a7medayman6, @husamql3
- Updated the desktop app and CLI dependencies — @husamql3
Bug Fixes
- Writes refused by a read-only connection now show clear guidance — @husamql3
- Your home directory is removed from error reports, including encoded Windows paths — @husamql3
- MongoDB databases with views now list their collections correctly — @husamql3
- Unreachable SQL Server connections now show a connection error — @husamql3
Desktop app
Installers are under Assets. Which one to pick and how to install: https://dbstudio.sh/docs/desktop
macOS: the app is not signed yet, so run
xattr -dr com.apple.quarantine /Applications/db-studio.appafter installing. - v2.1.02026-10-29 · 2026-10-29 23:13 UTC
查看更新说明
Features
- Select a range of cells, copy it with headers, and paste cells from a spreadsheet — @husamql3
- Review unsaved cell edits, revert a single cell, and undo with Cmd/Ctrl+Z — @husamql3
- Set a cell to NULL, empty text or its column default as explicit choices — @husamql3
- Copy a row as JSON or as a SQL INSERT, and duplicate it from the row menu — @husamql3
- Mark a saved connection read-only so the database refuses any write — @husamql3
Bug Fixes
- Saving a value PostgreSQL cannot read as the column's type now shows a clear error — @husamql3
- Opening a MySQL table that no longer exists now says so instead of a server error — @husamql3
Desktop app
Installers are under Assets. Which one to pick and how to install: https://dbstudio.sh/docs/desktop
macOS: the app is not signed yet, so run
xattr -dr com.apple.quarantine /Applications/db-studio.appafter installing. - v2.0.12026-10-29 · 2026-10-29 15:45 UTC
查看更新说明
Improvements
- The website and docs now use our new slogan: Every database. One studio — @husamql3
Desktop app
Installers are under Assets. Which one to pick and how to install: https://dbstudio.sh/docs/desktop
macOS: the app is not signed yet, so run
xattr -dr com.apple.quarantine /Applications/db-studio.appafter installing. - v2.0.02026-10-29 · 2026-10-29 01:07 UTC
查看更新说明
Features
- db-studio is now a desktop app for macOS, Windows and Linux, sharing saved connections with the CLI — @husamql3
Improvements
- The website has a new design — @husamql3
- Menus, dialogs, tooltips and tabs open with smoother motion and consistent corners, and respect reduced motion — @husamql3
- The visualizer uses the full width without the tables sidebar — @husamql3
Bug Fixes
- A query result too large to send now shows a clear error asking you to add a LIMIT — @husamql3
Desktop app
Installers are under Assets. Which one to pick and how to install: https://dbstudio.sh/docs/desktop
macOS: the app is not signed yet, so run
xattr -dr com.apple.quarantine /Applications/db-studio.appafter installing.
用户点评
登录用户的真实使用记录，可按版本和硬件筛选共 0 条
还没有人点评。第一个说出真实体验的人最有价值。
db-studio
Installation
No installation required:
npx db-studio
db-studio searches the current directory, then its parents, for a .env file with DATABASE_URL, then the environment. Without one, open the printed address and paste a connection URL on the Connect page.
Every connection that opens is saved to ~/.dbstudio/connections.json, readable only by your user, so you can switch between them from the sidebar. The server listens on 127.0.0.1 only; to serve it on your network, set HOST and list the hostname or IP you connect through in ALLOWED_HOSTS. db-studio then asks for a password: any username, and the password printed at startup or set in DB_STUDIO_PASSWORD.
You can also run db-studio as a Docker container. Simply run:
docker build -t db-studio .
docker run --rm -p 127.0.0.1:3333:3333 -v db-studio-config:/home/node/config db-studio
Check Running db studio with Docker to learn more and customize the container.
As a project script:
{
"scripts": {
"db:studio": "npx db-studio"
}
}
Flags:
| Flag | Description | Example |
|---|---|---|
-e, --env <path> | Use a specific .env file | npx db-studio --env .env.local |
-n, --var-name <name> | Read a different environment variable | npx db-studio --var-name MY_DB_URL |
-p, --port <number> | Change the server port (default: 3333) | npx db-studio --port 4000 |
-d, --database-url <url> | Pass the connection string directly | npx db-studio -d "postgresql://localhost/mydb" |
--open | Open db-studio in your browser once it starts | npx db-studio --open |
--no-open | Do not open the browser (the default) | npx db-studio --no-open |
-s, --status | Check the connection only, without the UI | npx db-studio --status |
-v, --version | Show the installed version | npx db-studio --version |
-h, --help | Show all options | npx db-studio --help |
Full documentation: dbstudio.sh
Features
Databases
- 🐘 PostgreSQL, CockroachDB, MySQL, MariaDB, TiDB, SQL Server, Oracle
- 🪶 SQLite, Turso / libSQL, Cloudflare D1, DuckDB
- 🍃 MongoDB, Redis, ClickHouse
- 🔌 Connect with a single connection URL
Table Browser
- 📋 Spreadsheet-like grid with inline cell editing
- 🔎 Filter, sort, and paginate rows
- 🔴 Live mode refreshes the grid and highlights changed rows and cells
- 🧾 Row details sheet with keyboard navigation between rows
- 🙈 Hide and reorder columns, saved per table
- 📤 Export tables as CSV, Excel, or JSON
Records
- ➕ Add records with type-aware forms
- 📥 Bulk insert from CSV, Excel, or JSON
- 🔗 Pick foreign key values from the referenced table
- 🗑️ Delete rows, with force delete for dependent rows
Schema
- 🏗️ Create and rename tables, with foreign keys
- ✏️ Add and edit columns
- 📇 Create and drop indexes
Query Runner
- ⌨️ Monaco-powered editor with syntax highlighting and autocomplete
- ✨ Generate, optimize, or fix queries with AI
AI Assistant
- 💬 Ask questions about your data in plain English
- 🔑 Bring your own key for Gemini, OpenAI, Anthropic, Grok, or OpenRouter
Everywhere
- ⌘ Command palette to jump to tables and run actions
- 🌗 Light and dark themes
- 📊 Anonymous usage data, off with
DB_STUDIO_TELEMETRY=0
Contributing
See CONTRIBUTING.md for development setup. Check the roadmap and changelog for what's planned and what shipped.
License
Apache License 2.0 - see LICENSE.
dbeaver
dbeaver·Java
免费通用的数据库管理工具和 SQL 客户端，支持 MySQL、Oracle、DB2、Databricks 等多种数据库，用图形界面统一管理连接、执行查询和查看 ERD。
数据库客户端+4数据库工具
52386+534.5k26.2.42026-11-10 17:10 UTC
tidb
pingcap·Go
面向不可预测增长的 Agent 负载设计的分布式数据库，原生支持事务、分析与向量检索，避免数据孤岛和资源争抢。
分布式数据库+4数据库工具
40729+116.3kv8.5.82026-11-10 15:58 UTC
dbx
t8y2·Rust
25 MB 的轻量跨平台数据库客户端，一个界面连 MySQL、PostgreSQL、Redis、MongoDB、达梦等 100+ 数据库，还自带 AI 助手、MCP Server 和 CLI。
数据库客户端+4数据库工具
29907+4062.7kpackages-v0.4.1412026-11-10 14:24 UTC
Chat2DB
OtterMind·Java
跨平台本地优先的数据库客户端和 SQL 工作台，支持 40+ 数据库，可接入自有 AI 模型生成、解释和优化查询，桌面、Web、Docker、CLI 多端可用。
数据库客户端+4数据库工具
28360+53.0kv5.3.9-beta.22026-11-02 06:24 UTC