anydb-mcp

One MCP server. Any database. PostgreSQL, MySQL, and MongoDB — all at once. Give Claude, Cursor, Windsurf, or any MCP-compatible AI safe, structured access to all your databases without ever exposing credentials.

What is this?

anydb-mcp is a Model Context Protocol (MCP) server that connects AI assistants to your databases. Connect up to 3 databases simultaneously — mix and match PostgreSQL, MySQL, and MongoDB. The AI can inspect schemas, diagnose performance problems, detect missing indexes, analyze locks, find slow queries across all databases in one call, and run safe read-only queries — all through a single, unified interface.

Works with: Claude Desktop, Claude Code, Cursor, Windsurf, Zed, and any MCP-compatible client.

Related MCP server: PostgreSQL MCP Server

Features

• PostgreSQL + MySQL + MongoDB — connect any combination, up to 3 at once

• Auto-detects DB type from the URL prefix (postgresql://, mysql://, mongodb://)

• Up to 3 databases simultaneously — primary, secondary, tertiary — switchable per tool call

• 14 built-in tools — schema inspection, health checks, index analysis, lock detection, bloat, slow queries

• list_slow_queries fans out across all DBs — one call, combined report from every connected database

• Credential isolation — passwords never appear in tool calls or AI responses; AI only sees aliases like "primary"

• Restricted mode — read-only transactions enforced at the database level (PostgreSQL/MySQL), 30s timeout

• Index miss detection — sequential scan hotspots, FK columns without indexes, unused index stats

• Lock analysis — blocking chains (PostgreSQL/MySQL), current operations (MongoDB)

• Table bloat — dead-tuple analysis with VACUUM recommendations (PostgreSQL)

• hypopg support — simulate hypothetical indexes before creating them (PostgreSQL)

• Zero config — credentials go in the MCP client env block, no .env file needed

Quick start

npx (no install needed)

npx anydb-mcp

Global install

npm install -g anydb-mcp
anydb-mcp

Local clone

git clone https://github.com/shubham4038/anydb-mcp.git
cd anydb-mcp
npm install && npm run build
node dist/index.js

Connect to your AI

Credentials go in the env block — no .env file needed on the user's side.

Claude Desktop

File: ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "anydb": {
      "command": "npx",
      "args": ["anydb-mcp"],
      "env": {
        "DB_PRIMARY_URL": "postgresql://user:pass@localhost:5432/mydb",
        "ACCESS_MODE": "restricted"
      }
    }
  }
}

Claude Code

File: ~/.claude/settings.json

{
  "mcpServers": {
    "anydb": {
      "command": "npx",
      "args": ["anydb-mcp"],
      "env": {
        "DB_PRIMARY_URL": "postgresql://user:pass@localhost:5432/mydb",
        "ACCESS_MODE": "restricted"
      }
    }
  }
}

Cursor

Settings → MCP → Add new MCP server:

{
  "command": "npx",
  "args": ["anydb-mcp"],
  "env": {
    "DB_PRIMARY_URL": "mysql://user:pass@localhost:3306/mydb",
    "ACCESS_MODE": "restricted"
  }
}

Windsurf

File: ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "anydb": {
      "command": "npx",
      "args": ["anydb-mcp"],
      "env": {
        "DB_PRIMARY_URL": "mongodb://user:pass@localhost:27017/mydb"
      }
    }
  }
}

Connecting multiple databases

Mix any combination of PostgreSQL, MySQL, and MongoDB. The AI uses the alias to target the right database — it never sees connection strings.

{
  "env": {
    "DB_PRIMARY_URL":    "postgresql://user:pass@pg-host:5432/production",
    "DB_PRIMARY_NAME":   "production",

    "DB_SECONDARY_URL":  "mysql://user:pass@mysql-host:3306/legacy",
    "DB_SECONDARY_NAME": "legacy",

    "DB_TERTIARY_URL":   "mongodb://user:pass@mongo-host:27017/analytics",
    "DB_TERTIARY_NAME":  "analytics",

    "ACCESS_MODE": "restricted"
  }
}

DB type is auto-detected from the URL prefix:

Example multi-DB AI prompts:

• "List slow queries across all my databases"

• "Compare index health between production and legacy"

• "Show me what's currently locking on production"

• "Is the analytics MongoDB missing any indexes?"

Tools

Every tool accepts an optional database parameter (defaults to the primary database). Call list_databases first to see what's configured.

Schema inspection

SQL & query execution

Index analysis

Health checks

Pass health_type: "all" or any specific check:

Advanced diagnostics

Security model

Optional extensions

PostgreSQL

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;  -- enables get_top_queries
CREATE EXTENSION IF NOT EXISTS hypopg;               -- enables hypothetical index simulation

Add to postgresql.conf:

shared_preload_libraries = 'pg_stat_statements'

MySQL

performance_schema should be enabled by default in MySQL 5.6+. Verify:

SHOW VARIABLES LIKE 'performance_schema';

MongoDB

Enable the profiler for slow query tracking:

db.setProfilingLevel(1, { slowms: 100 })

Docker

docker build -t anydb-mcp .

docker run --rm -i \
  -e DB_PRIMARY_URL="postgresql://user:pass@host:5432/mydb" \
  -e DB_SECONDARY_URL="mysql://user:pass@host:3306/mydb" \
  -e ACCESS_MODE=restricted \
  anydb-mcp

Local development

git clone https://github.com/shubham4038/anydb-mcp.git
cd anydb-mcp
npm install
npm run dev        # runs with tsx, no build step needed
npm run typecheck  # type check only
npm run build      # production build

Architecture

Each database adapter is 100% self-contained. PostgreSQL code never imports MySQL code, MySQL never imports MongoDB code. They only share a common TypeScript interface.

src/
  adapters/
    types.ts              ← shared interface only (no logic)
    postgres/             ← all PostgreSQL code, isolated
    mysql/                ← all MySQL code, isolated
    mongodb/              ← all MongoDB code, isolated
  db/
    registry.ts           ← only place that knows all 3 adapters exist
  server.ts               ← MCP tools, calls adapter.method() without knowing which DB

GitHub topics

Add these in Settings → Topics for discoverability:

mcp model-context-protocol postgresql mysql mongodb database multi-database ai claude cursor llm developer-tools typescript nodejs

License

MIT — free to use, modify, and distribute.