Skip to main content

MCP server for database management

Project description

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mcp_database_manager-0.1.2.tar.gz (78.1 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

mcp_database_manager-0.1.2-py3-none-any.whl (7.3 kB view details)

Uploaded Python 3

File details

Details for the file mcp_database_manager-0.1.2.tar.gz.

File metadata

File hashes

Hashes for mcp_database_manager-0.1.2.tar.gz
Algorithm Hash digest
SHA256 9fb3a32936ab484f5be69ded7d09638c4474ddf076f3206df839e20de6a0def5
MD5 11a4dd109398888a1ad3398c684bf5a2
BLAKE2b-256 42df896dab5b4cb6f4015d7a2b0808ec8e18bb4916e7db330aef7242440714fa

See more details on using hashes here.

File details

Details for the file mcp_database_manager-0.1.2-py3-none-any.whl.

File metadata

File hashes

Hashes for mcp_database_manager-0.1.2-py3-none-any.whl
Algorithm Hash digest
SHA256 380cfe599cbe2283ee51ecd1701b6ec99d616cb428281e2c3d3448ba220b6971
MD5 add0c164e6d399ed1fd397f3316640a9
BLAKE2b-256 e1d006f035bad44351ce3be6509fbdf9640d33180d3d40e178f30f21413cfd9c

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page