db-mcp-server

db-mcp-server

0

MCP Stdio Server is a Model Context Protocol server designed to integrate with Cursor IDE, offering extensive support for MySQL or MariaDB databases. It facilitates database structure insights, data analysis, and performance optimizations.

mysql.get_schema

Query all table structures and foreign key relationships

mysql.get_table_stats

Get table statistics

mysql.get_sample_data

Query table sample data

mysql.get_column_stats

Get column detailed statistics

mysql.execute_query

Perform read-only query

mysql.explain_query

Analyze query execution plan

mysql.optimize_query

Provide query optimization suggestions

mysql.get_db_status

Get database status information

mysql.get_table_size

Get table size information

mysql.get_index_usage

Get index usage statistics

mysql.analyze_performance

Analyzing performance bottlenecks

mysql.suggest_indexes

Provide index creation suggestions

mysql.optimize_tables

Provide table optimization suggestions