SmartDB MCP
Universal database MCP server connecting to MySQL, PostgreSQL, SQL Server, MariaDB,DM8,Oracle,not only provides basic database connection such as OAuth 2.0 auth…
SmartDB is a universal multi-paradigm data-infrastructure gateway that implements the Model Context Protocol (MCP) server interface. This gateway allows MCP-compatible clients to connect and explore different data sources in a unified way.
It currently covers 6 data paradigms and 10 data sources: 5 relational databases (MySQL, PostgreSQL, Oracle, SQL Server, Dameng), KV store (Redis), document store (MongoDB), vector database (Milvus), search engine (Elasticsearch), and message queue (Apache Kafka), with 26 MCP tools in total. Tools are dynamically filtered and exposed according to the paradigm of each connection pool.
Compared to similar products, SmartDB not only provides basic database connection and exploration capabilities but also adds advanced features such as OAuth 2.0 authentication, health checks, SQL optimization, and index health detection, making database management and maintenance more secure and intelligent.
Currently Supported Databases
| Database | Type | Support | Description |
|---|---|---|---|
| MySQL | Relational | √ | Supports MySQL 5.6+, MariaDB 10+ |
| PostgreSQL | Relational | √ | Supports PostgreSQL 9.6+, YMatrix |
| Oracle | Relational | √ | Oracle 12+ |
| SQL Server | Relational | √ | Microsoft SQL Server 2012+ |
| Dameng | Relational | √ | Dameng 8.0+ |
| Redis | KV Store | √ | Redis 5.0+ |
| MongoDB | Document | √ | MongoDB 4.0+ |
| Milvus | Vector | √ | Milvus 2.3+ |
| Elasticsearch | Search Engine | √ | Python driver ≥ 8.0, auto-adapts to ES 7/8/9 servers |
| Apache Kafka | Message Queue | √ | kafka-python-ng driver ≥ 2.2.2 |
Tool List
There are 26 tools in total. get_db_health and get_db_version are universal tools available for every data source; the other tools are exposed according to the paradigm of the connection pool.
From the project's README.