Database MCP

database_mcp

Pluggable MCP servers for MySQL and PostgreSQL with a shared core. Each database has its own driver, prompts and server process. A gateway.py file exposes both servers under a single FastAPI app.

Features

MySQL / PostgreSQL split: independent servers, drivers and prompts.
Optional TTL cache: global .env switch and per-call use_cache/ttl parameters.
Gateway: /mysql/* and /pgsql/* routes served from one process.
Easy extension: add new drivers, prompts and server files for other databases.

Project Structure

core/               # Base driver & TTL cache
  base.py
  cache.py

drivers/            # Pluggable DB drivers
  mysql_driver.py
  pgsql_driver.py

prompts/            # Built-in prompts (bilingual)
  mysql_prompts.py
  pgsql_prompts.py

server_mysql.py     # MySQL MCP server
server_pgsql.py     # PostgreSQL MCP server
gateway.py          # FastAPI gateway exposing both servers
requirements.txt
Dockerfile
.env.sample

Running

Local

MySQL server: uvicorn server_mysql:mcp.app --host 0.0.0.0 --port 8001
PostgreSQL server: uvicorn server_pgsql:mcp.app --host 0.0.0.0 --port 8002
Gateway (both): uvicorn gateway:app --host 0.0.0.0 --port 8000

Docker

Build image:

docker build -t db-mcp:latest .

Run gateway (default):

docker run --rm -p 8000:8000 db-mcp:latest

Run only MySQL server:

docker run --rm -p 8001:8001 -e TARGET=mysql db-mcp:latest

Run only PostgreSQL server:

docker run --rm -p 8002:8002 -e TARGET=pgsql db-mcp:latest

Environment variables for connection details and cache options are listed in .env.sample.

This server cannot be installed

security - not tested

license - not found

quality - not tested

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

Enables interaction with MySQL and PostgreSQL databases through separate pluggable MCP servers with shared core functionality. Features optional TTL caching, bilingual prompts, and a unified gateway for managing multiple database connections.

Related MCP Servers

MySQL MCP Server
kevinwatt
-
security
A
license
-
quality
An MCP server that integrates with MySQL databases, enabling secure read and write operations through LLM-driven interfaces with support for transaction handling and performance monitoring.
Last updated -
751
14
JavaScript
MIT License
DBHub
bytebase
-
security
A
license
-
quality
Universal database MCP server connecting to MySQL, PostgreSQL, SQLite, DuckDB and etc.
Last updated -
6
1,079
TypeScript
MIT License
MySQL MCP Server
vitalyDV
-
security
F
license
-
quality
An MCP server that allows working with MySQL databases by providing tools for executing read-only SQL queries, getting table schemas, and listing database tables.
Last updated -
600
2
JavaScript
Python MySQL MCP
hoonzinope
-
security
F
license
-
quality
A FastMCP-based server that enables interaction with MySQL databases, supporting client-server communication for querying and analyzing MySQL data.
Last updated -
Python

View all related MCP servers

Database MCP

database_mcp

Features

Project Structure

Running

Local

Docker

Related MCP Servers

MySQL MCP Server

DBHub

MySQL MCP Server

Python MySQL MCP

New MCP Servers

MCP directory API