CentralMind Gateway
MCP-Server from your Database optimized for LLMs and AI-Agents. Supports PostgreSQL, MySQL, ClickHouse, Snowflake, MSSQL, BigQuery, Oracle Database, SQLite, ElasticSearch, DuckDB
What is CentralMind Gateway?
CentralMind Gateway is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp-server from your database optimized for llms and ai-agents. supports postgresql, mysql, clickhouse, snowflake, mssql, bigquery, oracle database, sqlite, elasticsearch, duckdb
MCP-Server from your Database optimized for LLMs and AI-Agents. Supports PostgreSQL, MySQL, ClickHouse, Snowflake, MSSQL, BigQuery, Oracle Database, SQLite, ElasticSearch, DuckDB
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- MCP-Server from your Database optimized for LLMs and AI-Agen
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx centralmind-gatewayConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use CentralMind Gateway
CentralMind Gateway automatically generates an LLM-optimized MCP server (and REST API) directly from your database schema, eliminating the need to hand-write database tools for AI agents. It connects to PostgreSQL, MySQL, ClickHouse, Snowflake, MSSQL, BigQuery, Oracle, SQLite, ElasticSearch, and DuckDB, then uses an LLM during a one-time discovery phase to build a secure, documented API that AI agents can query in plain language. PII redaction, row-level security, OAuth/API key auth, and OpenTelemetry tracing are available as plugins, making it production-ready out of the box.
Prerequisites
- Docker installed (recommended path) or Go 1.21+ for building from source
- An existing database with a connection string (PostgreSQL, MySQL, ClickHouse, Snowflake, MSSQL, BigQuery, Oracle, SQLite, ElasticSearch, or DuckDB)
- An AI provider API key for the discovery phase — Google Gemini offers a free tier; alternatively OpenAI, Anthropic, AWS Bedrock, or Vertex AI keys work
- An MCP-compatible client such as Claude Desktop or Cursor
Run the discovery command to generate your API config
Gateway uses an LLM only during this one-time step to analyze your schema and produce a gateway.yaml configuration file. The example uses Gemini (free tier). Set GEMINI_API_KEY first, then point the tool at your database.
export GEMINI_API_KEY='your-gemini-api-key'
docker run --platform linux/amd64 -it \
-e GEMINI_API_KEY=$GEMINI_API_KEY \
-v $(pwd):/workspace \
ghcr.io/centralmind/gateway:v0.2.18 discover \
--ai-provider gemini \
--connection-string "postgresql://user:password@host:5432/mydb?sslmode=require" \
--prompt "Generate a readonly API for analytics" \
--output /workspace/gateway.yamlReview the generated gateway.yaml
The discovery step creates gateway.yaml listing all discovered tables, columns, and generated API endpoints. Review it to confirm no sensitive columns are exposed and that the generated endpoint paths match your expectations before starting the server.
Start the Gateway server in MCP+REST mode
Run the gateway with your generated config. It exposes an MCP SSE endpoint at /sse and a Swagger UI at the root. The LLM API key is NOT needed at runtime — inference only happened during discovery.
docker run --platform linux/amd64 -p 9090:9090 \
-v $(pwd)/gateway.yaml:/gateway.yaml \
ghcr.io/centralmind/gateway:v0.2.18 start \
--config /gateway.yaml stdioAdd Gateway to your MCP client config
Point Claude Desktop or Cursor at the Gateway SSE endpoint. The MCP server is now live and all discovered database endpoints appear as tools.
{
"mcpServers": {
"centralmind-gateway": {
"command": "docker",
"args": [
"run", "-i", "--platform", "linux/amd64",
"ghcr.io/centralmind/gateway:v0.2.18",
"--connection-string", "postgresql://user:password@host:5432/mydb",
"start", "stdio"
]
}
}
}Optionally enable PII redaction and authentication plugins
Add plugin entries to gateway.yaml to activate PII scrubbing (Microsoft Presidio or regex), API key auth, OAuth, or OpenTelemetry tracing. See the plugin documentation at docs.centralmind.ai/plugins for YAML syntax.
CentralMind Gateway Examples
Client configuration
Claude Desktop configuration using the CentralMind Gateway Docker image in stdio MCP mode with a PostgreSQL connection string.
{
"mcpServers": {
"centralmind-gateway": {
"command": "docker",
"args": [
"run", "-i", "--platform", "linux/amd64",
"ghcr.io/centralmind/gateway:v0.2.18",
"--connection-string", "postgresql://myuser:mypass@localhost:5432/analytics",
"start", "stdio"
]
}
}
}Prompts to try
Once Gateway is connected, ask questions about your database using natural language — the tools it exposes map directly to your discovered schema.
- "Show me the top 10 customers by total order value this month."
- "How many rows are in the events table and what is the date range?"
- "Summarize the payment_dim table and list all distinct payment methods."
- "What are the most frequently queried tables according to the API logs?"
- "List all columns in the fact_table and their data types."Troubleshooting CentralMind Gateway
Discovery fails with 'connection refused' or database authentication errors
Ensure the database is reachable from inside Docker. For local databases, use host.docker.internal instead of localhost in the connection string, e.g. postgresql://user:[email protected]:5432/mydb.
LLM provider returns errors during the discover step
Verify the correct environment variable is set for your provider (GEMINI_API_KEY, OPENAI_API_KEY, ANTHROPIC_API_KEY, etc.) and that the API key has sufficient quota. The Gemini free tier is recommended for initial testing.
Gateway starts but no tools appear in Claude Desktop
The stdio mode config must use the exact Docker image tag. If using SSE mode instead, set the mcpServers url to http://localhost:9090/sse and ensure port 9090 is forwarded with -p 9090:9090.
Frequently Asked Questions about CentralMind Gateway
What is CentralMind Gateway?
CentralMind Gateway is a Model Context Protocol (MCP) server that mcp-server from your database optimized for llms and ai-agents. supports postgresql, mysql, clickhouse, snowflake, mssql, bigquery, oracle database, sqlite, elasticsearch, duckdb It connects AI assistants to external tools and data sources through a standardized interface.
How do I install CentralMind Gateway?
Follow the installation instructions on the CentralMind Gateway GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with CentralMind Gateway?
CentralMind Gateway works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is CentralMind Gateway free to use?
Yes, CentralMind Gateway is open source and available under the Apache 2.0 license. You can use it freely in both personal and commercial projects.
CentralMind Gateway Alternatives — Similar Databases Servers
Looking for alternatives to CentralMind Gateway? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up CentralMind Gateway in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use CentralMind Gateway?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.