Kri8tivemike/MySQL-MCP-Local-Server
If you are the rightful owner of MySQL-MCP-Local-Server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MySQL MCP Server v2.0 is a comprehensive server designed for efficient MySQL database management, offering a suite of 37 tools for various operations.
Tools
Functions exposed to the LLM to take actions
mysql_query
Execute SELECT queries on the database.
mysql_insert
Insert data into a table.
mysql_update
Update data in a table.
mysql_delete
Delete data from a table.
mysql_create_table
Create new tables with column definitions.
mysql_drop_table
Drop tables safely.
mysql_alter_table
Modify table structure (add/drop columns).
mysql_create_index
Create database indexes.
mysql_drop_index
Remove indexes.
mysql_aggregate_query
Execute aggregate functions (COUNT, SUM, AVG, etc.).
mysql_join_query
Execute complex JOIN operations.
mysql_bulk_insert
Insert multiple records efficiently.
mysql_upsert
INSERT ON DUPLICATE KEY UPDATE operations.
mysql_search
Full-text search with LIKE/MATCH operations.
mysql_show_databases
List all databases on server.
mysql_create_database
Create new databases.
mysql_backup_table
Export table data to SQL.
mysql_restore_table
Import data from SQL backup.
mysql_optimize_table
Optimize table performance.
mysql_analyze_table
Analyze table statistics.
mysql_show_users
List database users.
mysql_show_grants
Show user permissions.
mysql_create_user
Create database users.
mysql_grant_privileges
Grant user permissions.
mysql_show_processlist
Show running queries.
mysql_explain_query
Analyze query execution plan.
mysql_show_status
Database server status.
mysql_show_variables
Server configuration variables.
mysql_table_size
Get table size information.
mysql_export_csv
Export query results to CSV.
mysql_import_csv
Import CSV data to tables.
mysql_export_json
Export data as JSON.
mysql_clone_table
Copy table structure/data.
mysql_transaction
Execute multiple queries in a transaction.
mysql_list_tables
List all tables in the database.
mysql_describe_table
Get detailed information about a table structure.
mysql_health_check
Check the health of the database connection.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client