# 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`:

```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.

```json
{
  "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.

```json
{
  "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.