SmartDB_MCP

database MCP Server

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

6 views87 stars20 forksMIT

Why This Matters

Discovered via unknown and last synced 3mo ago.

Source
unknown
Stars
87
Last synced
3mo ago
Install
Check source

Install

Install instructions not detected yet

Check the source repository for the latest setup steps.

View source instructions
29
Tools
0
Resources
0
Prompts
Standard I/O
Transport

Available Tools (29)

Dameng

√

Database

Support

type

Yes

max_overflow

Yes

Parameter

Database Type

get_db_version

Database version query tool

string

Oracle service name

service_name

Oracle

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.

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

pool_timeout

Yes

pool_recycle

Yes

Oracle

√

role

Yes

get_db_health

Analyzes database health status (connection status, transaction status, running status, lock detection) and outputs professional diagnostic reports and solutions

sql_creator

SQL query generation tool that generates corresponding SQL query statements based on different database types

pool_size

Yes

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_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

user

Yes

password

Yes

MySQL

√

PostgreSQL

√

port

Yes

host

Yes

database

Yes

Type

Description

schema

PostgreSQL, SQL Server

Works Well With - Skills