Mcp Mysql Connector
by daedaluscommunityv0.1.1
MCP server exposing MySQL database functionalities as tools for LLM agents, allowing interaction with MySQL databases through a standardized protocol.
From the registry: MCP server exposing MySQL database functionalities as tools
Install & configure
Prerequisites
- requiredInstall mcp-mysql-connectorInstall from PyPI
https://pypi.org/project/mcp-mysql-connector/$ pip install mcp-mysql-connector - requiredPython 3.11+Requires Python 3.11 or newer
Install in your client
Paste into the AI you're chatting with — it will figure out the rest
Please install the `mcp-mysql-connector` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Install mcp-mysql-connector** — Install from PyPI Run: `pip install mcp-mysql-connector` (https://pypi.org/project/mcp-mysql-connector/)
- **Python 3.11+** — Requires Python 3.11 or newer
Canonical MCP server config (stdio transport):
- command: `mcp-mysql-connector`
- args: []
- optional environment variables:
- `MYSQL_HOST`: MySQL host (example: `localhost`)
- `MYSQL_PORT`: MySQL port (example: `3306`)
- `MYSQL_USER`: MySQL user (example: `root`)
- `MYSQL_PASSWORD`: MySQL password (example: `<your-password>`)
- `MYSQL_DATABASE`: Default database (example: `<your-database>`)
Note: MySQL operations as MCP tools (databases, tables, queries, users, transactions). Connection can be made via env vars or via the connect tool at runtime.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.Note: MySQL operations as MCP tools (databases, tables, queries, users, transactions). Connection can be made via env vars or via the connect tool at runtime.
Tools (25)
connect
Connect to a MySQL database
disconnect
Disconnect from MySQL
is_connected
Check connection status
commit
Commit current transaction
rollback
Rollback current transaction
execute_query
Execute raw SQL query and return results
list_databases
List all databases on server
create_database
Create a new database
drop_database
Drop a database
database_exists
Check if database exists
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
show_columns
Environment variables
MYSQL_HOSTrequiredHost of the MySQL serverMYSQL_PORTrequiredPort of the MySQL serverMYSQL_USERrequiredUsername for MySQL authenticationMYSQL_PASSWORDrequiredPassword for MySQL authenticationMYSQL_DATABASErequiredDatabase to connect toPrerequisites
- • Python 3.11+
Packages
mcp-mysql-connector
pypiv0.1.1transport: stdio
Details
- Language
- Python
- License
- MIT
- Released
- Apr 6, 2026
- Last commit
- Apr 21, 2026
- Registry name
- io.github.daedalus/mcp-mysql-connector