MCP server/database

MCP Database Manager MCP Server

Enables LLM agents to perform CRUD operations across multiple databases.

meimingqi222/mcp-database-manager ↗by meimingqi222updated
1

Add it to Claude Code

claude mcp add database-manager -- uvx --from "mcp-database-manager[all]" mcp-database-manager
2

Make your agent remember this setup

database-manager's config, env vars, and the gotchas you hit — recalled in every future Claude Code, Cursor, and Codex session.

npx conare@latest

Free · one command · indexes the sessions already on disk. Set up in the browser instead →

What it does

  • Multi-database support including PostgreSQL, MySQL, and SQL Server
  • SQLAlchemy integration for robust database interaction
  • Configurable permission management with read-only defaults
  • Secure connection handling with automatic password redaction

Tools 1

list_connectionsLists configured database connections with passwords redacted from URLs.

Try it

List all available database connections.
Query the main_db to find all users who signed up in the last 30 days.
Update the status of order #12345 to 'shipped' in the production database.
Fetch the schema information for the products table in the inventory database.
Original README from meimingqi222/mcp-database-manager

MCP Database Manager

An MCP server that enables LLM agents to perform CRUD operations across multiple databases.

Features

  • Multi-Database Support
  • Permission Management (Read-only by default)
  • SQLAlchemy Integration
  • list_connections redacts passwords from connection URLs in its output

Database Support

This MCP server supports multiple databases. You can enable specific database drivers using installation extras:

Extra Database Drivers Installed
postgres PostgreSQL psycopg2-binary
mysql MySQL pymysql, cryptography
mssql SQL Server pymssql
all All of the above All drivers

Configuration

The configuration file is located at:

  • ~/.mcp-database-manager/config.yaml (on all platforms)

Example config.yaml:

connections:
  - name: "main_db"
    url: "sqlite:///./main.db"
    readonly: true

Cursor Configuration

To use this MCP server in Cursor, add the following to your MCP settings (Settings > Features > MCP):

Option 1: Local Development (Recommended for debugging)

Use this if you have the source code locally and want to test changes immediately.

{
  "mcpServers": {
    "database-manager": {
      "command": "uv",
      "args": [
        "run",
        "--extra",
        "all",
        "mcp-database-manager"
      ],
      "cwd": "/absolute/path/to/mcp-database-manager"
    }
  }
}

Note: Replace /absolute/path/to/mcp-database-manager with the actual path to your project directory.

Option 2: Using PyPI (Published version)

Use this to run the stable version published on PyPI without cloning the repository.

{
  "mcpServers": {
    "database-manager": {
      "command": "uvx",
      "args": [
        "--from",
        "mcp-database-manager[all]",
        "mcp-database-manager"
      ]
    }
  }
}

Troubleshooting

If you see "Module not found" errors, ensure you are using uv run which handles the virtual environment automatically.

Frequently Asked Questions

What are the key features of MCP Database Manager?

Multi-database support including PostgreSQL, MySQL, and SQL Server. SQLAlchemy integration for robust database interaction. Configurable permission management with read-only defaults. Secure connection handling with automatic password redaction.

What can I use MCP Database Manager for?

Allowing an LLM to perform data analysis directly on production or staging databases. Automating database record updates based on natural language instructions. Enabling developers to query database schemas using natural language. Managing multiple database environments through a single unified interface.

How do I install MCP Database Manager?

Install MCP Database Manager by running: uvx --from mcp-database-manager[all] mcp-database-manager

What MCP clients work with MCP Database Manager?

MCP Database Manager works with any MCP-compatible client including Claude Desktop, Claude Code, Cursor, and other editors with MCP support.

Conare · memory for coding agents

Turn this server into reusable context

Keep MCP Database Manager docs, env vars, and workflow notes in Conare so your agent carries them across sessions.

Set up free$npx conare@latest