wenb1n-dev/SmartDB_MCP

Overview

A Python-based MCP server that provides universal database connectivity to MySQL, PostgreSQL, SQL Server, MariaDB, DM8, and Oracle. It handles OAuth 2.0 authentication, health checks, SQL optimization, and index health detection.

Best for

Best for
Developers needing a unified MCP server to manage and monitor multiple relational databases through a single interface

Use cases

• Connect a single MCP interface to multiple relational databases simultaneously
• Automate database health checks and index performance monitoring
• Integrate SQL optimization into an agent or developer workflow

How to use

Install

pip install SmartDB-MCP

Tools exposed

• execute_sql
• get_db_health
• get_table_desc
• get_table_index
• get_table_name
• get_db_version
• sql_creator
• sql_optimize
• pool_size
• max_overflow
• pool_recycle
• pool_timeout
• service_name

Tested with

Cursor, Cline

Notes

A Python-based MCP server that provides universal database connectivity to MySQL, PostgreSQL, SQL Server, MariaDB, DM8, and Oracle. It handles OAuth 2.0 authentication, health checks, SQL optimization, and index health detection.

84 stars on GitHub. Last updated 2025-09-14. Licensed MIT.

Use cases

• Connect a single MCP interface to multiple relational databases simultaneously
• Automate database health checks and index performance monitoring
• Integrate SQL optimization into an agent or developer workflow

Pros

• Supports six major relational database engines in one tool
• Includes built-in SQL optimization and index health analysis
• Handles OAuth 2.0 authentication out of the box

Cons

• Relatively small community with only 84 stars
• Limited to relational databases, no NoSQL support
• Python only, may not fit non-Python stacks

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.