mcp-mysql-connector

MCP server exposing MySQL database functionalities as tools for LLM agents.

mcp-name: io.github.daedalus/mcp-mysql-connector

Overview

mcp-mysql-connector is a Model Context Protocol (MCP) server that provides MySQL database operations as tools for LLM agents. It allows AI assistants to interact with MySQL databases through a standardized protocol, enabling:

• Database and table management
• Query execution
• User authentication and privilege management
• Schema introspection
• Transaction control

Install

pip install mcp-mysql-connector

Quick Start

Running the Server

# Run with stdio transport (default)
mcp-mysql-connector

# Or run programmatically
python -c "from mcp_mysql import mcp; mcp.run()"

Configuration

Connect to MySQL using the connect tool:

{
  "host": "localhost",
  "port": 3306,
  "user": "root",
  "password": "your_password",
  "database": "your_database"
}

MCP Tools

Connection Management

Tool	Description
connect	Connect to a MySQL database
disconnect	Disconnect from MySQL
is_connected	Check connection status
commit	Commit current transaction
rollback	Rollback current transaction

Query Execution

Tool	Description
execute_query	Execute raw SQL query and return results

Database Operations

Tool	Description
list_databases	List all databases on server
create_database	Create a new database
drop_database	Drop a database
database_exists	Check if database exists

Table Operations

Tool	Description
list_tables	List tables in a database
describe_table	Get table schema
create_table	Create a new table
drop_table	Drop a table
table_exists	Check if table exists

Column & Index Operations

Tool	Description
show_columns	Show column details
show_indexes	Show index details
create_index	Create an index
drop_index	Drop an index

User Management

Tool	Description
create_user	Create a MySQL user
drop_user	Drop a MySQL user
grant_privileges	Grant privileges to user
revoke_privileges	Revoke privileges from user
show_privileges	Show user privileges

Server Information

Tool	Description
server_status	Get MySQL server status

MCP Resources

The server provides dynamic resources for database and table metadata:

• database://{name} - Database metadata including table list
• table://{db}/{table} - Table metadata including schema, columns, and indexes

Usage Examples

Connect and Query

# First, connect to database
connect(host="localhost", user="root", password="secret", database="mydb")

# Execute a query
execute_query(sql="SELECT * FROM users WHERE active = true")

# List all tables
list_tables(database="mydb")

Create Database and Table

# Create a database
create_database(name="newapp")

# Create a table
create_table(name="users", schema="id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255), email VARCHAR(255) UNIQUE")

User Management

# Create a new user with password
create_user(username="app_user", host="localhost", password="secure_password")

... [View full README on GitHub](https://github.com/daedalus/mcp-mysql-connector#readme)