H
haymon-ai/dbmcp
MySQL, MariaDB, PostgreSQL and SQLite, with PII redaction
View on GitHub ↗Link checked 2026-11-12 · HTTP 200 · opens the vendor's own site
Install & config
Client config (built from the install command this repo gives)
{
"mcpServers": {
"haymon-ai-dbmcp": {
"command": "npx",
"args": ["@modelcontextprotocol/inspector"]
}
}
}Parsed from the README we fetched on 2026-11-04; we have not executed it.
command/args come from the install command the repository states. When it is ambiguous, the project README wins.
VS Code (.vscode/mcp.json - the key is servers)
{
"servers": {
"haymon-ai-dbmcp": {
"command": "npx",
"args": ["@modelcontextprotocol/inspector"]
}
}
}Same server, but VS Code keeps it under <code>servers</code>.
Claude Code (command line)
claude mcp add --transport stdio haymon-ai-dbmcp -- npx @modelcontextprotocol/inspector
Claude Code does not read a config file; add the server with this command.
Key names differ by client: Clients & CLI
- Source
- collected from the abordage/awesome-mcp list · type: MCP server
- Harvest history
- first seen 2026-11-05 · last seen 2026-11-14 · seen 10× · listed by 10 sources
- Score
- score 1,003 · 10 sources · mcp
- Install
npx @modelcontextprotocol/inspector
FAQ (answers come from our records)
How do I install it?
The repository provides this install command:
npx @modelcontextprotocol/inspector. It comes from the repository itself; we cannot guarantee it runs as-is in your client.Who is it for?
We filed it under these tags: MCP 服务. The tags come from the entry itself, not a taxonomy we imposed.
Who maintains it?
first catalogued 2026-11-05;last seen 2026-11-14。There is no official certification or quality rating here — we record sources and dates only.
# Database MCP
以下摘录自该仓库的 README(片段) · 在 GitHub 读完整 README →
A single-binary MCP server for SQL databases. Connect your AI assistant to MySQL/MariaDB, PostgreSQL, or SQLite with zero runtime dependencies.
Website · Documentation · Releases
## Features ✨
Multi-database — MySQL/MariaDB, PostgreSQL, and SQLite from one binary
MCP tools — schema discovery (listDatabases, listTables, listViews, listTriggers, listFunctions, listProcedures, listMaterializedViews), data access (readQuery, writeQuery), DDL (createDatabase, dropDatabase, dropTable), and explainQuery. Read-only mode hides the write tools (writeQuery, createDatabase, dropDatabase, dropTable). See MCP Tools for per-backend availability.
Single binary — ~7 MB, no Python/Node/Docker needed
Multiple transports — stdio (for Claude Desktop, Cursor) and HTTP (for remote/multi-client)
Layered config — DBMCP environment variables, an env file, and an optional YAML config file with ${} interpolation, with sensible defaults per backend
SSH tunnel — reach MySQL/MariaDB/PostgreSQL through an SSH bastion with an embedded client: password or key auth, knownhosts verification, automatic reconnect
## Install 📦
macOS, Linux, WSL:
bash
curl -fsSL https://dbmcp.haymon.ai/install.sh | bash
Windows PowerShell:
powershell
irm https://dbmcp.haymon.ai/install.ps1 | iex
Windows CMD:
batch
curl -fsSL https://dbmcp.haymon.ai/install.cmd -o install.cmd && install.cmd && del install.cmd
See the installation docs for Docker, Cargo, and other methods.
## Quick Start 🚀
### Using .mcp.json (recommended)
Add a .mcp.json file to your project root. MCP clients read this file and configure the server automatically.
Stdio transport — the client starts and manages the server process:
json
"mcpServers": {
"dbmcp": {
"command": "dbmcp",
"env": {
"DBMCPDBBACKEND": "mysql",
"DBMCPDBHOST": "127.0.0.1",
"DBMCPDBPORT": "3306",
"DBMCPDBUSER": "root",
"DBMCPDBPASSWORD": "secret",
"DBMCPDBNAME": "mydb"
HTTP transport — you start the server yourself, the client connects to it:
bash
# Start the server first
DBMCPTRANSPORT=http DBMCPDBBACKEND=mysql DBMCPDBUSER=root DBMCPDBNAME=mydb dbmcp
json
"mcpServers": {
"dbmcp": {
"type": "http",
"url": "http://127.0.0.1:9001/mcp"
> Note: The "type": "http" field is required for HTTP transport. Without it, clients like Claude Code will reject the config.
To require a bearer token, start the server with DBMCPHTTPAUTHTOKEN and send it from the client:
bash
DBMCPHTTPAUTHTOKEN="$(openssl rand -hex 32)" DBMCPTRANSPORT=http DBMCPDBBACKEND=mysql DBMCPDBUSER=root DBMCPDBNAME=mydb dbmcp
json
"mcpServers": {
"dbmcp": {
"type": "http",
"url": "http://127.0.0.1:9001/mcp",
"headers": { "Authorization": "Bearer ${DBMCPTOKEN}" }
### Using environment variables
bash
# MySQL/MariaDB
DBMCPDBBACKEND=mysql DBMCPDBHOST=localhost DBMCPDBUSER=root DBMCPDBNAME=mydb dbmcp
# PostgreSQL
DBMCPDBBACKEND=postgres DBMCPDBHOST=localhost DBMCPDBUSER=postgres DBMCPDBNAME=mydb dbmcp
# SQLite
DBMCPDBBACKEND=sqlite DBMCPDBNAME=./data.db dbmcp
# PostgreSQL through an SSH bastion (DB host is resolved by the bastion)
DBMCPDBBACKEND=postgres DBMCPDBHOST=db.internal DBMCPDBUSER=postgres DBMCPDBNAME=mydb \
DBMCPSSHHOST=bastion.example.com DBMCPSSHUSER=deploy DBMCPSSHKEY=~/.ssh/ided25519 dbmcp
Website · Documentation · Releases
## Features ✨
Multi-database — MySQL/MariaDB, PostgreSQL, and SQLite from one binary
MCP tools — schema discovery (listDatabases, listTables, listViews, listTriggers, listFunctions, listProcedures, listMaterializedViews), data access (readQuery, writeQuery), DDL (createDatabase, dropDatabase, dropTable), and explainQuery. Read-only mode hides the write tools (writeQuery, createDatabase, dropDatabase, dropTable). See MCP Tools for per-backend availability.
Single binary — ~7 MB, no Python/Node/Docker needed
Multiple transports — stdio (for Claude Desktop, Cursor) and HTTP (for remote/multi-client)
Layered config — DBMCP environment variables, an env file, and an optional YAML config file with ${} interpolation, with sensible defaults per backend
SSH tunnel — reach MySQL/MariaDB/PostgreSQL through an SSH bastion with an embedded client: password or key auth, knownhosts verification, automatic reconnect
## Install 📦
macOS, Linux, WSL:
bash
curl -fsSL https://dbmcp.haymon.ai/install.sh | bash
Windows PowerShell:
powershell
irm https://dbmcp.haymon.ai/install.ps1 | iex
Windows CMD:
batch
curl -fsSL https://dbmcp.haymon.ai/install.cmd -o install.cmd && install.cmd && del install.cmd
See the installation docs for Docker, Cargo, and other methods.
## Quick Start 🚀
### Using .mcp.json (recommended)
Add a .mcp.json file to your project root. MCP clients read this file and configure the server automatically.
Stdio transport — the client starts and manages the server process:
json
"mcpServers": {
"dbmcp": {
"command": "dbmcp",
"env": {
"DBMCPDBBACKEND": "mysql",
"DBMCPDBHOST": "127.0.0.1",
"DBMCPDBPORT": "3306",
"DBMCPDBUSER": "root",
"DBMCPDBPASSWORD": "secret",
"DBMCPDBNAME": "mydb"
HTTP transport — you start the server yourself, the client connects to it:
bash
# Start the server first
DBMCPTRANSPORT=http DBMCPDBBACKEND=mysql DBMCPDBUSER=root DBMCPDBNAME=mydb dbmcp
json
"mcpServers": {
"dbmcp": {
"type": "http",
"url": "http://127.0.0.1:9001/mcp"
> Note: The "type": "http" field is required for HTTP transport. Without it, clients like Claude Code will reject the config.
To require a bearer token, start the server with DBMCPHTTPAUTHTOKEN and send it from the client:
bash
DBMCPHTTPAUTHTOKEN="$(openssl rand -hex 32)" DBMCPTRANSPORT=http DBMCPDBBACKEND=mysql DBMCPDBUSER=root DBMCPDBNAME=mydb dbmcp
json
"mcpServers": {
"dbmcp": {
"type": "http",
"url": "http://127.0.0.1:9001/mcp",
"headers": { "Authorization": "Bearer ${DBMCPTOKEN}" }
### Using environment variables
bash
# MySQL/MariaDB
DBMCPDBBACKEND=mysql DBMCPDBHOST=localhost DBMCPDBUSER=root DBMCPDBNAME=mydb dbmcp
# PostgreSQL
DBMCPDBBACKEND=postgres DBMCPDBHOST=localhost DBMCPDBUSER=postgres DBMCPDBNAME=mydb dbmcp
# SQLite
DBMCPDBBACKEND=sqlite DBMCPDBNAME=./data.db dbmcp
# PostgreSQL through an SSH bastion (DB host is resolved by the bastion)
DBMCPDBBACKEND=postgres DBMCPDBHOST=db.internal DBMCPDBUSER=postgres DBMCPDBNAME=mydb \
DBMCPSSHHOST=bastion.example.com DBMCPSSHUSER=deploy DBMCPSSHKEY=~/.ssh/ided25519 dbmcp
Listed badge (optional)
Copy this line into the README if you want the listing mark. Optional, and it does not affect being listed.
[](https://anclum.com/en/s/haymon-ai-dbmcp/)
- Source
- awesome · https://github.com/haymon-ai/dbmcp
- Browse by field
- MCP servers
- Listed by
- 10 independent sources
- added
- today
More like this
Filed under
Every tag opens the full list for that filter. Counts are the live catalogue figures.