SmartDB_MCP
by wenb1n-dev
Universal database MCP server connecting to MySQL, PostgreSQL, SQL Server, MariaDB,DM8,Oracle,not only provides basic database connection such as OAuth 2.0 authentication , health checks, SQL optimization, and index health detection
116stars
10forks
Python
Added 12/27/2025
MCP Serversaidameng8difymcpmcp-server
Installation
# Add to your Claude Code skills
git clone https://github.com/wenb1n-dev/SmartDB_MCP
SmartDB
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.
<img width="1303" height="697" alt="image" src="https://github.com/user-attachments/assets/9340f85e-28b0-45f2-8cb2-768b0d1c8b5c" />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+ | | Dameng | √ | Dameng 8.0+ |
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 ...