DB MCP Server
概览
作者提供的说明(英文原文)
Database MCP server for MySQL, PostgreSQL, MongoDB, and SQLite with SSH tunneling support.
PopNx MCP 的三大支柱
这三项永远不会合并成一个分数:意见、测量和人气是不同的东西。
- 用户评价i暂无评价评价功能将在后续阶段与账户功能一起开放
- 我们的基础检查i1 项中通过 1 项依据公开信息检查;尚未扫描代码
- 使用情况i非常新↓ 64/周 · ★ –
它能帮你做什么
我们还没有为它写通俗的介绍。下面是我们从注册中心读取到的事实。
- 连接方式: 在你的电脑上运行
- 传输方式: stdio
- 分类: 数据库与数据集
- 你需要填写:DB_TYPE, DB_DATABASE, DB_PASSWORD, DB_URL, SSH_PASSWORD
安装
选择你使用的 AI 应用,然后复制设置。
安装之前
- 基础检查:1 项中通过 1 项
- 在你的电脑上运行,拥有你的用户账户的权限(文件、网络、应用)。
- 需要你自己填写:
DB_TYPE,DB_DATABASE,DB_MODE,DB_HOST,DB_PORT,DB_USER,DB_PASSWORD,DB_URL,SSH_HOST,SSH_PORT,SSH_USER,SSH_KEY,SSH_PASSWORD
标为机密的值是你账户的钥匙。千万不要分享给别人,也不要粘贴到聊天里。
你需要
- PyPI已安装 Python 的 uv(用于 uvx 命令)
你用的是哪个应用?
在上方选择你的应用。我们会记住它,下次按钮会显示“安装到 …”。
打开 Claude Desktop → Settings → Developer → Edit Config,把下面的内容粘贴到 claude_desktop_config.json
{
"mcpServers": {
"db": {
"command": "uvx",
"args": [
"db-mcp-server"
],
"env": {
"DB_TYPE": "your-value",
"DB_DATABASE": "your-value",
"DB_MODE": "your-value",
"DB_HOST": "your-value",
"DB_PORT": "your-value",
"DB_USER": "your-value",
"DB_PASSWORD": "your-value",
"DB_URL": "your-value",
"SSH_HOST": "your-value",
"SSH_PORT": "your-value",
"SSH_USER": "your-value",
"SSH_KEY": "your-value",
"SSH_PASSWORD": "your-value"
}
}
}
}在终端中运行这条命令
claude mcp add db --env DB_TYPE=your-value --env DB_DATABASE=your-value --env DB_MODE=your-value --env DB_HOST=your-value --env DB_PORT=your-value --env DB_USER=your-value --env DB_PASSWORD=your-value --env DB_URL=your-value --env SSH_HOST=your-value --env SSH_PORT=your-value --env SSH_USER=your-value --env SSH_KEY=your-value --env SSH_PASSWORD=your-value -- uvx db-mcp-server运行前请先填写空着的值。
或者自己复制设置
粘贴到项目中的 .cursor/mcp.json,或 ~/.cursor/mcp.json
{
"mcpServers": {
"db": {
"command": "uvx",
"args": [
"db-mcp-server"
],
"env": {
"DB_TYPE": "your-value",
"DB_DATABASE": "your-value",
"DB_MODE": "your-value",
"DB_HOST": "your-value",
"DB_PORT": "your-value",
"DB_USER": "your-value",
"DB_PASSWORD": "your-value",
"DB_URL": "your-value",
"SSH_HOST": "your-value",
"SSH_PORT": "your-value",
"SSH_USER": "your-value",
"SSH_KEY": "your-value",
"SSH_PASSWORD": "your-value"
}
}
}
}浏览器会先询问是否打开应用,然后应用会显示设置并请你确认。密钥的值会留空,由你自己填写。
或者自己复制设置
粘贴到项目中的 .vscode/mcp.json
{
"servers": {
"db": {
"type": "stdio",
"command": "uvx",
"args": [
"db-mcp-server"
],
"env": {
"DB_TYPE": "your-value",
"DB_DATABASE": "your-value",
"DB_MODE": "your-value",
"DB_HOST": "your-value",
"DB_PORT": "your-value",
"DB_USER": "your-value",
"DB_PASSWORD": "your-value",
"DB_URL": "your-value",
"SSH_HOST": "your-value",
"SSH_PORT": "your-value",
"SSH_USER": "your-value",
"SSH_KEY": "your-value",
"SSH_PASSWORD": "your-value"
}
}
}
}浏览器会先询问是否打开应用,然后应用会显示设置并请你确认。密钥的值会留空,由你自己填写。
这个服务器在你的电脑上运行,而 ChatGPT 只能连接互联网上的服务器。请选择其他应用。
你的选择通过 Cookie 保存在这台设备上,无需账户。
需要你填写的值
- Database type
- Database name
DB_MODEenvAccess modeDB_HOSTenvDatabase host (MySQL/PostgreSQL)DB_PORTenvDatabase port (MySQL: 3306, PostgreSQL: 5432)DB_USERenvDatabase user (MySQL default: root, PostgreSQL default: postgres)- Database password (MySQL/PostgreSQL, optional)
- MongoDB connection URL (required for MongoDB, e.g. mongodb://...)
SSH_HOSTenvSSH bastion host for tunneling (MySQL/PostgreSQL only)SSH_PORTenvSSH portSSH_USERenvSSH username (default: current OS user)SSH_KEYenvPath to SSH private key (e.g. ~/.ssh/id_rsa)- SSH password (if no key provided)
这些设置是根据作者在注册中心的条目生成的。如果 README 的写法不同,请以 README 为准。
它能做什么
它在你的电脑上运行;安装后,工具列表会显示在你的 AI 应用中。
基础检查i
我们检查的是任何人都能看到的信息;我们没有阅读代码。不适用的检查项不计入总数。 · 检查于 2026年11月8日
- ✓ 通过
作者与仓库一致
注册名称已通过 GitHub 账户 stucchi 验证,该账户拥有此仓库
- … 尚未检查
仍在维护
我们还没有从 GitHub 读取这个仓库
- … 尚未检查
有许可证
我们还没有从 GitHub 读取这个仓库
- – 不适用
端点有响应
它在你的电脑上运行,没有互联网端点
- – 不适用
使用 OAuth 登录
在你的电脑上运行,改用本地设置
- … 尚未检查
工具描述中没有隐藏指令
它在你的电脑上运行;我们只能读取互联网端点的工具列表
与“数据库与数据集”中的其他服务器比较i
- 星标数多于此分类中其他 1146 个服务器的 0%
- 发布到注册中心的时间比此分类中其他 1146 个服务器的 7% 更新
- 基础检查结果等于或优于此分类中其他 1146 个服务器的 100%
与注册中心里这个分类中所有活跃的服务器比较。只有当发布者拥有该仓库时,星标数才计入。
常见问题
DB MCP Server 安全吗?
它在 1 项适用的基础检查中通过了 1 项。我们没有阅读代码。在添加密钥或令牌之前,请先看看这个服务器要求哪些权限,并使用只具备所需权限的密钥。
它需要哪些密钥或代码?
你需要填写:DB_TYPE, DB_DATABASE, DB_PASSWORD, DB_URL, SSH_PASSWORD
它在我的电脑上运行还是在云端?
它在你的电脑上运行。你的 AI 应用会在需要时启动它,数据不会经过作者的服务器(除非它自己调用在线服务)。
它还在维护吗?
GitHub 仓库最后更新于–,最新版本(1.2.1)于8个月前进入注册中心。
哪些应用可以使用它?
支持 MCP 的应用,例如 Claude Desktop、Claude Code、Cursor 和 VS Code。你的电脑上还需要有 Python (uv)。
有什么可以替代它?
同一分类中有:Supabase, MongoDB MCP Server, Elasticsearch MCP Server
替代选择
同一分类中其他作者的服务器,按星标数排序。
如何看卡片:↓ 每周下载量i★ GitHub 星标i三大支柱:评价 · 检查 · 使用情况i更新 = 最新版本发布到注册中心的时间i
作者的 README
打开 README
按原文从作者的仓库复制。PopNx MCP 没有审查或背书其内容。HTML、图片和脚本已被移除。链接会离开本站。
db-mcp-server
MCP server for MySQL, PostgreSQL, MongoDB, and SQLite databases. One instance per database, no Docker required.
Installation
uvx db-mcp-server
Configuration
Configure via environment variables. Each instance connects to a single database.
MySQL
| Variable | Required | Default | Description |
|---|---|---|---|
DB_TYPE | Yes | — | mysql |
DB_DATABASE | Yes | — | Database name |
DB_PASSWORD | Yes | — | Password |
DB_HOST | No | localhost | Host |
DB_PORT | No | 3306 | Port |
DB_USER | No | root | User |
DB_MODE | No | read-only | read-only or read-write |
PostgreSQL
| Variable | Required | Default | Description |
|---|---|---|---|
DB_TYPE | Yes | — | postgresql |
DB_DATABASE | Yes | — | Database name |
DB_PASSWORD | Yes | — | Password |
DB_HOST | No | localhost | Host |
DB_PORT | No | 5432 | Port |
DB_USER | No | postgres | User |
DB_MODE | No | read-only | read-only or read-write |
MongoDB
| Variable | Required | Default | Description |
|---|---|---|---|
DB_TYPE | Yes | — | mongodb |
DB_DATABASE | Yes | — | Database name |
DB_URL | Yes | — | Connection URL (mongodb://...) |
DB_MODE | No | read-only | read-only or read-write |
SQLite
| Variable | Required | Default | Description |
|---|---|---|---|
DB_TYPE | Yes | — | sqlite |
DB_PATH | Yes | — | Path to .db file (local or remote with SSH) |
DB_DATABASE | No | filename | Display name |
DB_MODE | No | read-only | read-only or read-write |
SSH Tunnel (MySQL / PostgreSQL)
Optionally connect through an SSH bastion host. Set SSH_HOST to activate.
For SQLite over SSH, the remote .db file is downloaded via SFTP before querying. In read-write mode, changes are uploaded back on shutdown.
| Variable | Required | Default | Description |
|---|---|---|---|
SSH_HOST | No | — | SSH bastion host (activates tunneling) |
SSH_PORT | No | 22 | SSH port |
SSH_USER | No | Current OS user | SSH username |
SSH_KEY | No | — | Path to private key (~/.ssh/id_rsa) |
SSH_PASSWORD | No | — | SSH password (if no key) |
At least one of SSH_KEY or SSH_PASSWORD is required when SSH_HOST is set. SSH tunneling is not supported for MongoDB.
Usage in .mcp.json
SQLite (local)
{
"mcpServers": { "db-local": { "command": "uvx", "args": ["db-mcp-server"], "env": { "DB_TYPE": "sqlite", "DB_PATH": "/path/to/database.db" } } } }
SQLite over SSH
{
"mcpServers": { "db-remote": { "command": "uvx", "args": ["db-mcp-server"], "env": { "DB_TYPE": "sqlite", "DB_PATH": "/remote/path/to/database.db", "SSH_HOST": "server.example.com", "SSH_USER": "deploy", "SSH_KEY": "~/.ssh/id_rsa" } } } }
{
"mcpServers": { "db-prod": { "command": "uvx", "args": ["db-mcp-server"], "env": { "DB_TYPE": "mysql", "DB_MODE": "read-only", "DB_HOST": "db.example.com", "DB_PORT": "3306", "DB_USER": "root", "DB_PASSWORD": "secret", "DB_DATABASE": "myapp" } } } }
With SSH tunnel
{
"mcpServers": { "db-behind-bastion": { "command": "uvx", "args": ["db-mcp-server"], "env": { "DB_TYPE": "postgresql", "DB_HOST": "10.0.0.5", "DB_PORT": "5432", "DB_USER": "postgres", "DB_PASSWORD": "secret", "DB_DATABASE": "myapp", "SSH_HOST": "bastion.example.com", "SSH_USER": "deploy", "SSH_KEY": "~/.ssh/id_rsa" } } } }
For multiple databases, add multiple instances:
{
"mcpServers": { "db-prod": { "command": "uvx", "args": ["db-mcp-server"], "env": { "DB_TYPE": "mysql", "DB_DATABASE": "prod", "..." : "..." } }, "db-analytics": { "command": "uvx", "args": ["db-mcp-server"], "env": { "DB_TYPE": "postgresql", "DB_DATABASE": "analytics", "..." : "..." } }, "db-staging": { "command": "uvx", "args": ["db-mcp-server"], "env": { "DB_TYPE": "mongodb", "DB_DATABASE": "staging", "..." : "..." } } } }
Tools
MySQL
- query — Execute read-only SQL (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH)
- execute — Execute write SQL (INSERT, UPDATE, DELETE) — requires
DB_MODE=read-write - describe — Describe table structure
- list_tables — List all tables
- status — Show connection info
PostgreSQL
- query — Execute read-only SQL (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH)
- execute — Execute write SQL (INSERT, UPDATE, DELETE) — requires
DB_MODE=read-write - describe — Describe table structure (column info from information_schema)
- list_tables — List all tables in the public schema
- status — Show connection info
SQLite
- query — Execute read-only SQL (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH)
- execute — Execute write SQL (INSERT, UPDATE, DELETE) — requires
DB_MODE=read-write - describe — Describe table structure (PRAGMA table_info)
- list_tables — List all tables
- status — Show connection info
MongoDB
- query — Find documents in a collection
- describe — Collection stats ($collStats)
- list_collections — List all collections
- aggregate — Execute aggregation pipelines ($out/$merge blocked on read-only)
- status — Show connection info
License
MIT