Skip to main content
Glama

Database MCP

by swoiow
OverviewSchemaRelated ServersScoreDiscussions
Python
Remote

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.

Related MCP server: DBHub

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
F
license - not found
-
quality - not tested

How are these scores calculated?

Resources

Appeared in Searches

New MCP Servers

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/swoiow/database_mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server