DB MCP Server
mysql tdengin ๆฐๆฎๅบ mcpserver
Ask AI about DB MCP Server
Powered by Claude ยท Grounded in docs
I know everything about DB MCP Server. Ask me about installation, configuration, usage, or troubleshooting.
0/500
Reviews
Documentation
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
