# MCPDBWizard MCP server

> Generates a custom Oracle MCP server that exposes specific PL/SQL packages, tables, and SQL statements as typed tools for AI agents.

- Repository: https://github.com/srmadscience/mcpdbwizard-open
- Page: https://hostedmcp.org/servers/srmadscience/mcpdbwizard-open
- Transport: remote
- Stars: 1
- License: Apache-2.0
- Latest version: 2.0.47

## Install

### Claude Code

```sh
claude mcp add mcpdbwizard-open -- docker run -i --rm ghcr.io/srmadscience/mcpdbwizard:2.0.47
```

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

```json
{
  "mcpServers": {
    "mcpdbwizard-open": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/srmadscience/mcpdbwizard:2.0.47"
      ]
    }
  }
}
```

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

```json
{
  "servers": {
    "mcpdbwizard-open": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/srmadscience/mcpdbwizard:2.0.47"
      ]
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"mcpdbwizard-open","type":"stdio","command":"docker","args":["run","-i","--rm","ghcr.io/srmadscience/mcpdbwizard:2.0.47"]}'
```

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

```json
{
  "mcpServers": {
    "mcpdbwizard-open": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/srmadscience/mcpdbwizard:2.0.47"
      ]
    }
  }
}
```

### Codex

```sh
codex mcp add mcpdbwizard-open -- docker run -i --rm ghcr.io/srmadscience/mcpdbwizard:2.0.47
```

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

```toml
[mcp_servers.mcpdbwizard-open]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/srmadscience/mcpdbwizard:2.0.47"]
```

### Gemini CLI

```sh
gemini mcp add -s user mcpdbwizard-open docker -- run -i --rm ghcr.io/srmadscience/mcpdbwizard:2.0.47
```

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

```json
{
  "mcpServers": {
    "mcpdbwizard-open": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/srmadscience/mcpdbwizard:2.0.47"
      ]
    }
  }
}
```

## FAQ

### Does this server allow running arbitrary SQL?

No, there is no run-sql tool. The server only exposes the specific objects you select during generation, and it uses fixed SQL statements with typed binds rather than composing queries at runtime.

### How are complex Oracle types handled in the MCP tools?

Complex types are mapped to JSON: records become JSON objects, REF CURSORs become arrays of row objects, and binary vectors are converted to base64.
