Documentation
Documentation
MCPDBWizard reads your Oracle, PostgreSQL or MariaDB schema and generates an MCP server for the objects you selected. An object you did not select has no tool, no method and no class — the curation is enforced by absence from the binary rather than by a rule at request time.
New here? Start with the quickstart for your database: Oracle, PostgreSQL or MariaDB.
Getting started
Get a server running and an agent talking to it.
-
Quickstart
Point MCPDBWizard at an Oracle schema, select the objects you will expose, generate an MCP server and connect an agent to it — on Docker or on AWS.
-
Quickstart: Docker
From nothing to a login page on Docker — one image, one port, one volume — then back to the Quickstart to build your first MCP server.
-
Quickstart: AWS
One CloudFormation stack — an EC2 instance, one ECS task and an EFS volume — from nothing to a login page, then back to the Quickstart to build your first MCP server.
-
Quickstart: Postgres
From nothing to an agent calling your PostgreSQL schema — one image, one port, one volume, then a config, a server and a token.
-
Quickstart: MariaDB
From nothing to an agent calling your MariaDB schema — one image, one port, one volume, then a config, a server and a token.
-
Launching on Docker outline
Running the MCPDBWizard container — ports, the data volume, secrets, memory limits and compose.
-
Docker parameters outline
Every environment variable the container reads, what it does, and which ones need a regeneration rather than a restart.
Oracle
The database side: the account, the connection, sessions and pooling.
-
Creating an Oracle user with minimal privileges
The database account an agent reaches Oracle through, and why its grants are the real security boundary.
-
Connecting to Oracle
How the console reaches your database — SID versus service name, the one password, and what happens when it cannot.
-
Session management
What a generated server tells Oracle about itself, how to find its sessions in V$SESSION and its SQL in V$SQL, and when a transaction ends.
-
Connection pooling
Give each concurrent caller its own DAO factory instead of queueing them all on one connection — and size it against the database, not the CPU.
PostgreSQL
MCPDBWizard for Postgres: what it generates, how types cross, the connection and the role, and its release notes.
-
MCPDBWizard for Postgres
The same generator for PostgreSQL 16, 17 and 18 — tables, views, functions, procedures, sequences and SQL statements become typed MCP tools, and nothing else reaches the database.
-
Connecting to Postgres
How the Postgres console reaches your database — the settings, which schemas it lists, the one password, and the grants the login role needs.
-
Sessions and pooling on Postgres
How a generated Postgres server names its sessions in pg_stat_activity, why it is always pooled, how to size the pool against max_connections, and what the statement timeout raises.
-
Release notes for Postgres
What changed in each release of MCPDBWizard for Postgres, newest first, which image tag to pull, and what is known not to work.
Operating
Running it for real — connecting clients, logs, audit records, metrics and accounts, plus what is broken and what changed.
-
Connecting to the MCP server
Point an agent at a running config — the proxy URL, the API token, what each refusal means, and why you connect to port 8080 rather than to the server itself.
-
Setting up logging
Where the console and generated servers write, what one tool call looks like in the log, and how to point logging somewhere else.
-
Setting up auditing outline
The local trail every install keeps, how long it is kept, streaming records to Kafka, Splunk, S3 or syslog, and the write-ahead spool that survives an outage.
-
Setting up metrics and Grafana outline
Two Prometheus endpoints, why an empty dashboard is nearly always the second one, and the label that makes the data worth having.
-
Oracle parameters
The database settings a busy MCP server can outgrow — chiefly open_cursors, why a config with many tools reaches it, what the server does about it since 2.0.38, and how to fix it on the database side.
-
Creating application users
Accounts, API tokens and the access matrix — how a client proves who it is, and what it is allowed to drive.
-
Known issues
What is wrong and what it looks like from a client — a record collection that will not bind both ways on Oracle 12c, generated keys a DML statement will not hand back, and the workaround for each.
-
Verifying the image
The published container carries a build record and a bill of materials — the commands to read them without pulling, and plainly what none of it proves.
-
Release notes
What changed in each release, newest first — 2.0.47 back to 2.0.0 — and which image tag to pull.
MariaDB
MCPDBWizard for MariaDB: what it generates, how types cross, the connection and the grants, and its release notes.
-
MCPDBWizard for MariaDB
The same generator for MariaDB 11.4, 11.8, 12.3 and 13 — tables, views, procedures, functions, Oracle-mode package members, sequences and SQL statements become typed MCP tools, and nothing else reaches the database.
-
Connecting to MariaDB
How the MariaDB console reaches your database — the settings, which databases it lists, the one password, and the grants the login needs, SHOW CREATE ROUTINE among them.
-
Sessions and pooling on MariaDB
How to find a generated MariaDB server's connections, why each tool call is one transaction with package state reset after it, how to size the pool against max_connections, and what the statement timeout does.
-
Release notes for MariaDB
What changed in each release of MCPDBWizard for MariaDB, newest first, which image tag to pull, and what is known not to work.
Curating
Choosing what an agent can reach. This is the security model.
-
Creating configs
The config file is the security model — what a config is, how it is stored, and why two small ones usually beat one large one.
-
Context Pinning
Pin a connection to one customer — or tenant, or branch — by putting it on the connection URL. Your routines read it — SYS_CONTEXT on Oracle, a setting on PostgreSQL, a user variable on MariaDB — and the agent has no way to ask for anyone else's rows.
-
Working with procedures
Exposing PL/SQL routines as tools — every OUT parameter comes back, collections keep their subscripts, overloads never collide, and you decide who commits.
-
Working with sequences
The smallest surface in the product — one selected sequence, one tool, and nothing else.
-
Working with tables
Read operations by primary key, unique key, index and foreign key — and why insert, update and delete deserve a second thought.
-
Working with SQL statements
Your own curated, tested SQL, exposed as tools — how parameters get names and types, and what crosses JSON.
Beyond this site
The repository carries two long-form guides these pages summarise:
DEPLOYMENT.md for the operator's side and
USING-MCP.md for the caller's, with every request and response
taken from a live server. Where a page here disagrees with those, they are
right and the page is a bug.