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.3.tar.gz (78.2 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.3-py3-none-any.whl (7.4 kB view details)

Uploaded Python 3

File details

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

File metadata

File hashes

Hashes for mcp_database_manager-0.1.3.tar.gz
Algorithm Hash digest
SHA256 41e4012330ce15570dc0a8ac36abf207dfd20d2ebeb4bbd26659951d5b774c66
MD5 d8a29f2b62289f966b6bfd3523bc9c78
BLAKE2b-256 80ab8da09f0a29b62961550bbfa35149c308c057ab17caffe5b6d3963dae107c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mcp_database_manager-0.1.3-py3-none-any.whl
Algorithm Hash digest
SHA256 50ca40cd161f83d41850c1095ca06cd633a04d4568197e22fc0c8b9f955f4532
MD5 d076cf94a16668abf91929dfaf20715f
BLAKE2b-256 15a3dc86652652c9766f1f340640d9163dc62c74ca26e2cab0d77483de78ba9a

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