Mcp Mysql Connector

mcp-mysql-connector

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

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

[PyPI] [Python] [Coverage] [Ruff]

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 programmaticallypython -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

Query Execution

Database Operations

Table Operations

Column & Index Operations

User Management

Server Information

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 databaseconnect(host="localhost", user="root", password="secret", database="mydb")
# Execute a queryexecute_query(sql="SELECT * FROM users WHERE active = true")
# List all tableslist_tables(database="mydb")

Create Database and Table

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

User Management

# Create a new user with passwordcreate_user(username="app_user", host="localhost", password="secure_password")
# Grant privilegesgrant_privileges(privileges="SELECT,INSERT,UPDATE,DELETE", on="newapp.*", username="app_user", host="localhost")

Transaction Control

# Start transactionexecute_query(sql="BEGIN")
# Execute operationsexecute_query(sql="INSERT INTO accounts (balance) VALUES (100)")
# Commit or rollbackcommit()  # or rollback()

Environment Variables

The server supports configuration via environment variables:

export MYSQL_HOST=localhostexport MYSQL_PORT=3306export MYSQL_USER=rootexport MYSQL_PASSWORD=secretexport MYSQL_DATABASE=mydb

Development

# Clone repositorygit clone https://github.com/daedalus/mcp-mysql-connector.gitcd mcp-mysql-connector
# Create virtual environmentpython -m venv venvsource venv/bin/activate
# Install dependenciespip install -e ".[test]"
# Run testspytest
# Format coderuff format src/ tests/
# Lintruff check src/ tests/
# Type checkmypy src/

Architecture

mcp-mysql-connector/├── src/mcp_mysql/│   ├── core/models.py       # Data models (QueryResult, TableSchema, etc.)│   ├── adapters/mysql.py    # MySQL connection & pooling│   ├── services/connection.py  # Connection manager│   ├── tools/mysql_tools.py   # MCP tool implementations│   └── mcp.py              # FastMCP server setup└── tests/                   # Test suite

Requirements

• Python 3.11+
• fastmcp >= 2.0.0
• pymysql >= 1.1.0
• sqlparse >= 0.4.0

License

MIT License - see LICENSE for details.