mcp-server-mysql

The @enemyrr/mcp-mysql-server is a Model Context Protocol server designed to facilitate MySQL database operations by enabling AI models to interact with databases through a standardized interface. It supports multiple connection methods, secure connection handling, and provides comprehensive error handling.

connect_db

Connect to MySQL database using URL, workspace path, or direct credentials

query

Execute SELECT query (support parameter binding)

execute

Perform INSERT/UPDATE/DELETE operation

list_tables

List all tables in the database

describe_table

Get table structure information

create_table

Create a new table (supports field and index definitions)

add_column

Add new columns to existing tables