CentralMind Gateway

v1.0.0Databasesstable

MCP-Server from your Database optimized for LLMs and AI-Agents. Supports PostgreSQL, MySQL, ClickHouse, Snowflake, MSSQL, BigQuery, Oracle Database, SQLite, ElasticSearch, DuckDB

amazon-bedrockanthropic-claudeapiautomatic-apiclickhouse
Share:
531
Stars
0
Downloads
0
Weekly
0/5

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

Multi-database query interface
PostgreSQL, MySQL, Snowflake, BigQuery access
Data-optimized LLM integration
centralmind

Maintainer

LicenseApache 2.0
Languagego
Versionv1.0.0
UpdatedMay 20, 2026
Statushealthy
Maintenanceactive

Works with

ClaudeOpenAIwindowsmacoslinux

Installation

Manual Installation

npx centralmind-gateway

Configuration

Configuration Details

Config File

claude_desktop_config.json

Performance

Response Metrics

Response Time< 200ms
ThroughputMedium

Resource Usage

Memory UsageLow
CPU UsageLow

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
1

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.yaml
2

Review 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.

3

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 stdio
4

Add 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"
      ]
    }
  }
}
5

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.

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.

Quick Config Preview

{ "mcpServers": { "centralmind-gateway": { "command": "npx", "args": ["-y", "centralmind-gateway"] } } }

Add this to your claude_desktop_config.json or .cursor/mcp.json

Read the full setup guide →

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.

33,000+ ServersFree & Open SourceStep-by-Step Guides