🏎️ 🏠 🍎 🪟 - Automatically generate APIs from database schema and data for PostgreSQL, ClickHouse, MySQL,…
以下摘录自该仓库的 README(片段) · 在 GitHub 读完整 README →
CentralMind Gateway: Create API or MCP Server in Minutes
🚀 Interactive Demo avialable here: https://centralmind.ai
What is Centralmind/Gateway
Simple way to expose your database to AI-Agent via MCP or OpenAPI 3.1 protocols.
This will run for you an API:
Which you can use inside your AI Agent:
Gateway will generate AI optimized API.
Why Centralmind/Gateway
AI agents and LLM-powered applications need fast, secure access to data. We're building an API layer that automatically generates secure, LLM-optimized APIs for your structured data.
- Quickly start with MCP or OpenAPI, or use Direct/Raw SQL APIs
- Filters out PII and sensitive data to ensure compliance with GDPR, CPRA, SOC 2, and other regulations
- Adds traceability and auditing capabilities, ensuring AI applications aren't black boxes and allowing security teams to maintain control
- Optimized for AI workloads: supports the Model Context Protocol (MCP) with enhanced metadata to help AI agents understand APIs, along with built-in caching and security features
It can be useful during development, when an LLM needs to create, adjust, or query data from your database.
In analytical scenarios, it enables you to chat with your database or data warehouse.
Enrich your AI agents with data from your database using remote function/tool calling.
Features
- ⚡ **Automatic API Generation** – Creates APIs automatically using LLM based on table schema and sampled data
- 🗄️ **Structured Database Support** – Supports PostgreSQL , MySQL , ClickHouse , Snowflake , MSSQL , BigQuery , Oracle Database , SQLite , ElasticSearch
- 🌍 **Multiple Protocol Support** – Provides APIs as REST or MCP Server including SSE mode
- 🔐 **Authentication Options** – Built-in support for API keys and OAuth
- 🔒 **PII Protection** – Implements regex plugin or Microsoft Presidio plugin for PII and sensitive data redaction
- 👀 **Comprehensive Monitoring** – Integration with OpenTelemetry (OTel) for request tracking and audit trails
- 📦 **Local & On-Premises** – Support for self-hosted LLMs through configurable AI endpoints and models
- 🤖 **Multiple AI Providers Support** - Support for OpenAI, Anthropic, Amazon Bedrock, Google Gemini & Google VertexAI
- ⚡ **Flexible Configuration** – Easily extensible via YAML configuration and plugin system
- 📜 **API Documentation** – Auto-generated Swagger documentation and OpenAPI 3.1.0 specification
- 🔑 **Row-Level Security (RLS)** – Fine-grained data access control using Lua scripts
- 🏎️ **Performance Optimization** – Implements time-based and LRU caching strategies
How it Works
1. Connect & Discover
Gateway connects to your structured databases like PostgreSQL and automatically analyzes the schema and data samples
to generate an optimized API structure based on your prompt. LLM is used only on discovery stage to produce API configuration.
The tool uses AI Providers to generate the API configuration while ensuring security
through PII detection.
2. Deploy
Gateway supports multiple deployment options from standalone binary, docker or Kubernetes .
Check our launching guide for detailed
instructions. The system uses YAML configuration and plugins for easy customization.