Awesome MCPDatabases

centralmind/gateway

⭐ 548 Go added to this list on 2025-03-09 repository created 2025-02-10

CentralMind Gateway is a universal server designed to automatically generate secure, AI-optimized APIs for structured databases, facilitating seamless integration with AI agents and large language models (LLMs) through the Model Context Protocol (MCP) and OpenAPI 3.1 protocols. It enables developers and organizations to quickly expose their databases to AI agents, providing a fast, secure, and compliant API layer optimized for AI workloads. The Gateway supports multiple structured database systems including PostgreSQL, MySQL, ClickHouse, Snowflake, MSSQL, BigQuery, Oracle Database, SQLite, and ElasticSearch, making it versatile for various data environments. The project emphasizes security and compliance by filtering out personally identifiable information (PII) and sensitive data to meet regulations such as GDPR, CPRA, and SOC 2. It also incorporates traceability and auditing features to ensure transparency and control over AI interactions with data. The Gateway supports multiple authentication methods including API keys and OAuth, and offers row-level security through Lua scripting for fine-grained access control. CentralMind Gateway automatically generates APIs by analyzing database schemas and sampled data using LLMs during the discovery phase, creating an optimized API structure. It supports REST APIs with Swagger UI and MCP servers with Server-Sent Events (SSE) mode, allowing flexible integration options. The system is designed for easy deployment via standalone binaries, Docker containers, or Kubernetes, and is configurable through YAML files and a plugin system. Additional features include built-in caching strategies for performance optimization, comprehensive monitoring with OpenTelemetry integration, and support for multiple AI providers such as OpenAI, Anthropic, Amazon Bedrock, Google Gemini, and Google VertexAI. The Gateway is useful for development scenarios where LLMs need to query or modify data, as well as analytical use cases that enable conversational interaction with databases or data warehouses. It also supports remote function or tool calling to enrich AI agents with database data. Overall, CentralMind Gateway provides a powerful, secure, and flexible solution for bridging structured databases with AI applications using the Model Context Protocol and OpenAPI standards.

https://github.com/centralmind/gateway

ai-agentsai-integrationai-optimized-apisai-providersamazon-bedrockanthropicanthropic-claudeapiapi-generationapi-keysaudit-trailsauditingauthenticationautomatic-apiautomatic-api-generationbigquerycachingcentralmind-gatewaychatgptclickhousecpra-compliancedatabase-apidockerduckdbelasticsearchfunction-callinggdpr-compliancegolanggoogle-geminigoogle-vertex-aigoogle-vertexaihelmkuberneteslangchainllmllmslua-scriptinglua-scriptsmcpmcp-servermodel-context-protocolmssqlmysqlmysql-databaseoauthopenaiopenapiopenapi-3.1opentelemetryoracleoracle-databaseperformance-optimizationpii-protectionplugin-systempostgresqlrest-apirow-level-securitysecure-apisself-hosted-llmself-hosted-llmsserver-sent-eventssnowflakesoc-2-compliancesqlitessestructured-databasessupabaseswagger-documentationtelemetrytraceabilityyaml-configuration

Also in Databases

dolthub/dolt

Dolt is a SQL database with Git-like version control capabilities, enabling users to manage, version, and collaborate on data and schemas as easily as code in Git repositories.

t8y2/dbx

DBX is a lightweight, cross-platform database client supporting over 70 databases, featuring a built-in AI assistant, MCP Server, and available as desktop, Docker, or CLI.

Canner/WrenAI

Open-source generative BI engine that exposes governed text-to-SQL, a semantic layer and dashboard generation to AI agents through an MCP server and CLI across more than twenty data sources.

googleapis/mcp-toolbox

MCP Toolbox for Databases is an open-source Model Context Protocol (MCP) server that connects AI agents, IDEs, and applications directly to enterprise databases, offering both pre-built and custom ...

makenotion/notion-mcp-server

The Notion MCP Server is an official MCP server implementation that enables secure, programmatic interaction with Notion content through MCP commands, optimized for AI agents and supporting multiple deployment options.

bytebase/dbhub

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface, enabling MCP clients to connect to and explore multiple database systems including MySQL, PostgreSQL, Oracle, SQL Server, MariaDB, and SQLite.

crystaldba/postgres-mcp

Postgres MCP Pro is an open-source Model Context Protocol server for PostgreSQL that provides advanced database health monitoring, index tuning, query plan analysis, and safe SQL execution to support AI agents and developers throughout the application lifecycle.

supabase-community/supabase-mcp

Supabase MCP Server connects Supabase projects to AI assistants using the Model Context Protocol, enabling LLMs to manage and query Supabase resources.