Universal database MCP server for MySQL, PostgreSQL, SQL Server, MariaDB,Oracle


You may visit this Github link:
https://github.com/wenb1n-dev/SmartDB_MCP

SmartDB is a universal database gateway that implements the Model Context Protocol (MCP) server interface. This gateway allows MCP-compatible clients to connect and explore different databases.

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 Support Description
MySQL Supports MySQL 5.6+, MariaDB 10+
PostgreSQL Supports PostgreSQL 9.6+, YMatrix
Oracle Oracle 12+
SQL Server Microsoft SQL Server 2012+



Tool List

Tool Name Description
execute_sql SQL execution tool that can execute [“SELECT”, “SHOW”, “DESCRIBE”, “EXPLAIN”, “INSERT”, “UPDATE”, “DELETE”, “CREATE”, “ALTER”, “DROP”, “TRUNCATE”] commands based on permission configuration
get_db_health Analyzes database health status (connection status, transaction status, running status, lock detection) and outputs professional diagnostic reports and solutions
get_table_desc Searches for table structures in the database based on table names, supports multi-table queries
get_table_index Searches for table indexes in the database based on table names, supports multi-table queries
get_table_name Database table name query tool. Used to query all table names in the database or search for corresponding table names based on Chinese table names or table descriptions
get_db_version Database version query tool
sql_creator SQL query generation tool that generates corresponding SQL query statements based on different database types
sql_optimize A professional SQL performance optimization tool that provides expert optimization suggestions based on execution plans, table structure information, table data volume, and table indexes.



Usage Examples

  1. Query the table data of the default connection pool
    image

  2. Query the table data of the others connection pool
    image

  3. Query data from tables in other connection pools and other databases
    image

  4. Query database health status
    image

  5. Sql Optimize
    image



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *