mcp-database-universal

MCP Database Universal

A reasoning interface for databases — not a thin execution wrapper. Designed so LLM agents understand what the data means, not just how to fetch it.

What it does

• 7 tools designed for agent thinking: test_connection, list_tables, inspect_table, query, natural_query, profile_database, schema_graph
• 4 database engines: SQLite (built-in), PostgreSQL, MySQL, MSSQL (optional extras)
• Read-only by default — write operations only with DATABASE_WRITE_ENABLED=true
• Safety layer — SQL injection detection, read-only classification, LIMIT enforcement, query timeout, row limits
• LLM formatter — type translation (e.g. VARCHAR(255) → "text, max 255 chars"), NULL → (empty), output size cap
• Schema inspector — relationship discovery + Mermaid ER diagram generation
• Zero-config SQLite via DATABASE_URL=sqlite:///path/to.db

Installation

pip install mcp-database-universal
pip install "mcp-database-universal[postgres]"   # PostgreSQL support
pip install "mcp-database-universal[mysql]"      # MySQL support
pip install "mcp-database-universal[mssql]"      # MSSQL support

Quick Start

Run locally

DATABASE_URL=sqlite:///app.db python -m mcp_database_universal

Run with Docker

docker run -i -e DATABASE_URL=sqlite:////data/app.db \
  -v ./data:/data mcp-database-universal:latest

Configuration (env vars)

Tools

License

MIT