MySQL Mcp

stdionone★ 1database

Production safe MCP server that gives AI agents direct access to MySQL databases.

Install

How to run this server

No install command recorded.

server path: mysql-mcp

Tools

What this server exposes

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)

Configuration

Environment & auth

authnone

envMYSQL_HOST

envMYSQL_PORT

Resources