MySQL Ops MCP

A generic MCP server for MySQL operations.

It supports:

• Listing databases and tables.
• Describing tables.
• Showing indexes and triggers.
• Running read-only SQL: SELECT, SHOW, DESCRIBE, DESC, EXPLAIN.
• Running explicitly requested write SQL when MYSQL_WRITE_ENABLED=true.
• Logging every executed write SQL file under mysql-ops-logs/ in the current project root.

Configuration

Copy .env.example to .env.local and set your MySQL connection:

MYSQL_HOST=127.0.0.1
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASSWORD=change-me
MYSQL_DEFAULT_DATABASE=insurance
MYSQL_WRITE_ENABLED=true
MYSQL_EXECUTION_LOG_DIR=mysql-ops-logs

.env.local is ignored by Git.

Tools

• mysql_current_config
• mysql_list_databases
• mysql_list_tables
• mysql_describe_table
• mysql_show_indexes
• mysql_show_triggers
• mysql_query_readonly
• mysql_explain
• mysql_execute_sql
• mysql_execute_file
• mysql_create_backup_sql

High-risk SQL such as DROP DATABASE, TRUNCATE TABLE, and UPDATE or DELETE without WHERE requires confirmHighRisk=true.