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

xuwenbin — Wed, 27 Aug 2025 06:21:40 +0000

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

Query the table data of the default connection pool

Query the table data of the others connection pool

Query data from tables in other connection pools and other databases

Query database health status

Sql Optimize

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

xuwenbin — Wed, 20 Aug 2025 07:28:49 +0000

Hi! I'd like to share the tool that I just worked. If you are using Anthropic's Claude AI and Database, this might be helpful to you.

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.

SmartDB’s “Superpowers”: Seven Core Advantages

Multi-Database Support: One Tool for All Major Databases
SmartDB supports four major database systems, covering a wide range of versions:
MySQL: 5.6+ (including MariaDB 10+)
PostgreSQL: 9.6+ (including YMatrix)
Oracle: 12c+
SQL Server: 2012+
No matter which database your enterprise uses, SmartDB has you covered—no more switching tools for different databases.
Connection Pool Management: Boost Performance, Save Resources
Database connections are a common performance bottleneck. SmartDB uses an efficient connection pool mechanism to reuse connections and reduce overhead, resulting in faster query responses and lower server load.
Health Checks & Monitoring: Your Database’s “Personal Doctor”
SmartDB can monitor database status in real time, automatically detect anomalies (such as connection interruptions or slow queries), and generate professional diagnostic reports—transforming DBAs from “firefighters” to “prevention experts.”
SQL Execution & Optimization: From “Writing SQL” to “Smart Optimization”
The built-in sql_optimize tool analyzes execution plans and table structures, automatically providing optimization suggestions (e.g., “Create an index on the user_id field”) to boost SQL performance!
Table Structure & Index Management: Instantly Map Your Database
With the get_table_desc and get_table_index tools, developers can quickly query table structures and index information, supporting multi-table queries and even Chinese/English table name searches—like a CT scanner for your database.
OAuth Security Authentication: A “Golden Shield” for Data Security
SmartDB integrates OAuth 2.0 authentication, supporting role-based access control (read-only, read-write, admin), ensuring only authorized users can access data and eliminating leakage risks at the source.
Extensible Architecture: As Flexible as LEGO
Modular design makes SmartDB easy to extend—whether adding support for new databases or customizing features, it’s a breeze.

Let me know what you think of it. Thanks!

DEV Community: xuwenbin

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

Currently Supported Databases

Tool List

Usage Examples

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