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

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.1.tar.gz (75.4 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.1-py3-none-any.whl (6.5 kB view details)

Uploaded Python 3

File details

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

File metadata

File hashes

Hashes for mcp_database_manager-0.1.1.tar.gz
Algorithm Hash digest
SHA256 ef079534fc9d3dc48b50c3acf9884e671bdf172679a1a0c1efae8b0d7a97a96b
MD5 e751d01b3b84ad9ac3e742dc9708266d
BLAKE2b-256 1f36634983d75af452e818d7d320391efef8ebebb45ec339dd007bbfee2ee5eb

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mcp_database_manager-0.1.1-py3-none-any.whl
Algorithm Hash digest
SHA256 8758ba71b8d28d25182fc02bb659caf62a7ec2d99c2054c999d193bff60ea693
MD5 5ac3e2ccdc62083fe9d0764c1062211a
BLAKE2b-256 745bbfe2a187a4377dd1c5ebb8f42eff9c489670afa7d717bc9d7ec591299b2d

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