{"slug":"turkeryildirim/mysql-mcp","name":"MySQL Mcp","description":"Production safe MCP server that gives AI agents direct access to MySQL databases.","category":"database","tags":[],"official":false,"stars":1,"transport":"stdio","install":null,"tools":[{"name":"execute_query","description":"Run SELECT, INSERT, UPDATE, or DELETE statements with parameterized query support (`?` placeholders)"},{"name":"execute_transaction","description":"Execute multiple statements as an atomic batch; if any statement fails the entire transaction is automatically rolled back"},{"name":"create_table","description":"Create a new table"},{"name":"alter_table","description":"Add/drop columns, rename columns, add indexes, and more"},{"name":"drop_table","description":"Drop a table (requires `ALLOW_DESTRUCTIVE_DDL=true`)"},{"name":"show_tables","description":"List all tables in a database"},{"name":"describe_table","description":"Show column structure of a table"},{"name":"list_databases","description":"List all user databases (system databases excluded)"},{"name":"create_database","description":"Create a new database with optional charset and collation"},{"name":"drop_database","description":"Drop a database (requires `ALLOW_DESTRUCTIVE_DDL=true`)"},{"name":"ping","description":"Check MySQL connection health"},{"name":"show_columns","description":"Show detailed column information for a table"},{"name":"get_server_info","description":"Return MySQL version, character set, and collation (read-only)"}],"env_vars":["MYSQL_HOST","MYSQL_PORT"],"auth_type":"none","github":"https://github.com/turkeryildirim/mysql-mcp","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}