# MCPDBWizard

> MCPDBWizard is a freemium MCP server for databases. Generate an Oracle MCP server from only the tables and PL/SQL you choose. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Platforms:** self-hosted
- **Website:** https://mcpdbwizard.com
- **Repository:** https://github.com/srmadscience/mcpdbwizard-open
- **MCP Registry name:** io.github.srmadscience/mcpdbwizard
- **Categories:** databases, developer tools
- **Listing updated:** 2026-11-14

## About

MCPDBWizard works in the opposite direction from a generic database connector. You select Oracle tables, PL/SQL routines, sequences and SQL statements, and code is emitted only for those. Anything you leave out has no tool, no method and no class, so it cannot be reached by any prompt.

There is no run-sql tool. Arguments arrive as bind values against a strict schema, a misspelled argument is rejected before Oracle is touched, and DDL is out of reach. The database password stays in the environment. PL/SQL routines are called as they are, with records, collections and every OUT parameter returned.

It ships as a single Docker image. One running server is free and includes a downloadable 24-hour audit trail; a licence adds more.

## Features

- **Selection-only code:** Unselected objects get no generated code at all.
- **No free-form SQL:** The caller cannot send SQL text or DDL; arguments are bind values.
- **PL/SQL as tools:** Routines are called directly, returning records, collections and OUT parameters.
- **Table tools:** Tables get tools such as get-by-primary-key, insert, update and delete from one selection.
- **Audit trail:** A 24-hour audit trail can be downloaded on the free tier.
- **Single Docker image:** The server is packaged as one image.

## Good for

- Expose an Oracle PL/SQL package to an agent without opening up the schema
- Give an agent read access to chosen tables only
- Keep existing business rules in PL/SQL instead of rewriting them in prompts
- Produce an audit trail of what an agent called

## Install

### Claude Code (Terminal)

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

### Claude Desktop (claude_desktop_config.json)

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

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

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

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

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

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

## Tools

- `synuser_activity_log_get_by_pk`: Example generated tool: one table row by primary key
- `synuser_activity_log_insert`: Example generated tool: insert a row
- `synuser_js_admin_getadmintoolinfo`: Example generated PL/SQL routine tool
- `synuser_job_id_nextval`: Example generated sequence tool

## FAQ

### Can the agent run arbitrary SQL?

No. There is no run-sql tool, and only the selected objects and statements are usable.

### Where does the Oracle password live?

In the environment, not in anything the agent can read.

### What does it cost?

One running server is free with no expiry. Paid licence details are on the vendor site.

### How is it deployed?

As a Docker image from ghcr.io.

### Is MCPDBWizard free?

MCPDBWizard has a free plan, with paid plans for more usage or features.

### How do I add MCPDBWizard to Claude Code?

Run this command in your terminal: claude mcp add mcpdbwizard -- docker run -i --rm ghcr.io/srmadscience/mcpdbwizard:2.0.47

### What are the best alternatives to MCPDBWizard?

The closest alternatives to MCPDBWizard are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.

---
Source: https://ai-powered.com/mcp/mcpdbwizard
