# SQL MCP server

> Provides a governed SQL gateway for AI agents to access PostgreSQL, MySQL, and OceanBase through controlled relational algebra and strict security policies.

- Repository: https://github.com/nethinwei/sql-mcp-server
- Page: https://hostedmcp.org/servers/nethinwei/sql-mcp-server
- Transport: stdio
- Stars: 1
- License: MIT
- Latest version: 0.1.21

## Install

### Claude Code

```sh
claude mcp add --env 'DATABASE_DSN=<YOUR_DATABASE_DSN>' sql-mcp-server -- docker run -i --rm ghcr.io/nethinwei/sql-mcp-server:0.1.21
```

### Cursor (`~/.cursor/mcp.json`)

```json
{
  "mcpServers": {
    "sql-mcp-server": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/nethinwei/sql-mcp-server:0.1.21"
      ],
      "env": {
        "DATABASE_DSN": "<YOUR_DATABASE_DSN>"
      }
    }
  }
}
```

### VS Code (`.vscode/mcp.json`)

```json
{
  "servers": {
    "sql-mcp-server": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/nethinwei/sql-mcp-server:0.1.21"
      ],
      "env": {
        "DATABASE_DSN": "<YOUR_DATABASE_DSN>"
      }
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"sql-mcp-server","type":"stdio","command":"docker","args":["run","-i","--rm","ghcr.io/nethinwei/sql-mcp-server:0.1.21"],"env":{"DATABASE_DSN":"<YOUR_DATABASE_DSN>"}}'
```

### Claude Desktop (`claude_desktop_config.json`)

```json
{
  "mcpServers": {
    "sql-mcp-server": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/nethinwei/sql-mcp-server:0.1.21"
      ],
      "env": {
        "DATABASE_DSN": "<YOUR_DATABASE_DSN>"
      }
    }
  }
}
```

### Codex

```sh
codex mcp add sql-mcp-server --env 'DATABASE_DSN=<YOUR_DATABASE_DSN>' -- docker run -i --rm ghcr.io/nethinwei/sql-mcp-server:0.1.21
```

### Codex config.toml (`~/.codex/config.toml`)

```toml
[mcp_servers.sql-mcp-server]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/nethinwei/sql-mcp-server:0.1.21"]

[mcp_servers.sql-mcp-server.env]
DATABASE_DSN = "<YOUR_DATABASE_DSN>"
```

### Gemini CLI

```sh
gemini mcp add -s user -e 'DATABASE_DSN=<YOUR_DATABASE_DSN>' sql-mcp-server docker -- run -i --rm ghcr.io/nethinwei/sql-mcp-server:0.1.21
```

### Gemini settings.json (`~/.gemini/settings.json`)

```json
{
  "mcpServers": {
    "sql-mcp-server": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/nethinwei/sql-mcp-server:0.1.21"
      ],
      "env": {
        "DATABASE_DSN": "<YOUR_DATABASE_DSN>"
      }
    }
  }
}
```

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `DATABASE_DSN` | no | yes | Database DSN referenced by ${DATABASE_DSN} in config.yaml |

## FAQ

### Which databases are supported?

The server supports PostgreSQL, MySQL, and OceanBase.

### How can a trusted operator execute raw SQL?

Trusted operators can use a separate SQL escape channel called `execute_sql`, which is disabled by default and requires explicit permission.

### What security measures are in place for data access?

The server enforces RBAC, field ACLs, row policies, and masking.
