haymon-ai/dbmcp

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