MySQL Mcp

Tools · 13

• execute_query Run SELECT, INSERT, UPDATE, or DELETE statements with parameterized query support (`?` placeholders)
• execute_transaction Execute multiple statements as an atomic batch; if any statement fails the entire transaction is automatically rolled back
• create_table Create a new table
• alter_table Add/drop columns, rename columns, add indexes, and more
• drop_table Drop a table (requires `ALLOW_DESTRUCTIVE_DDL=true`)
• show_tables List all tables in a database
• describe_table Show column structure of a table
• list_databases List all user databases (system databases excluded)
• create_database Create a new database with optional charset and collation
• drop_database Drop a database (requires `ALLOW_DESTRUCTIVE_DDL=true`)
• ping Check MySQL connection health
• show_columns Show detailed column information for a table
• get_server_info Return MySQL version, character set, and collation (read-only)