Mcp Mysql Connector
This is a straightforward MySQL adapter that gives Claude direct access to your database through stdio transport. It covers the full range of operations you'd expect: executing raw SQL queries, creating and dropping databases and tables, managing indexes, and handling user privileges. You get transaction control with commit and rollback, schema introspection through describe_table and show_columns, and dynamic resources for browsing database and table metadata. Connection management is handled through a dedicated connect tool that takes standard MySQL credentials. Reach for this when you want Claude to query your data, generate reports, or help manage database schemas without building custom tooling. Requires Python 3.11+ and uses pymysql under the hood.
- tools
- 25
- transport
- STDIO
- last updated
- Apr 6, 2026
Tools
25 toolsPublic tool metadata for what this MCP can expose to an agent.
connectConnect to a MySQL database
Connect to a MySQL database
No parameter schema in public metadata yet.
disconnectDisconnect from MySQL
Disconnect from MySQL
No parameter schema in public metadata yet.
is_connectedCheck connection status
Check connection status
No parameter schema in public metadata yet.
commitCommit current transaction
Commit current transaction
No parameter schema in public metadata yet.
rollbackRollback current transaction
Rollback current transaction
No parameter schema in public metadata yet.
execute_queryExecute raw SQL query and return results
Execute raw SQL query and return results
No parameter schema in public metadata yet.
list_databasesList all databases on server
List all databases on server
No parameter schema in public metadata yet.
create_databaseCreate a new database
Create a new database
No parameter schema in public metadata yet.
drop_databaseDrop a database
Drop a database
No parameter schema in public metadata yet.
database_existsCheck if database exists
Check if database exists
No parameter schema in public metadata yet.
list_tablesList tables in a database
List tables in a database
No parameter schema in public metadata yet.
describe_tableGet table schema
Get table schema
No parameter schema in public metadata yet.
create_tableCreate a new table
Create a new table
No parameter schema in public metadata yet.
drop_tableDrop a table
Drop a table
No parameter schema in public metadata yet.
table_existsCheck if table exists
Check if table exists
No parameter schema in public metadata yet.
show_columnsShow column details
Show column details
No parameter schema in public metadata yet.
show_indexesShow index details
Show index details
No parameter schema in public metadata yet.
create_indexCreate an index
Create an index
No parameter schema in public metadata yet.
drop_indexDrop an index
Drop an index
No parameter schema in public metadata yet.
create_userCreate a MySQL user
Create a MySQL user
No parameter schema in public metadata yet.
drop_userDrop a MySQL user
Drop a MySQL user
No parameter schema in public metadata yet.
grant_privilegesGrant privileges to user
Grant privileges to user
No parameter schema in public metadata yet.
revoke_privilegesRevoke privileges from user
Revoke privileges from user
No parameter schema in public metadata yet.
show_privilegesShow user privileges
Show user privileges
No parameter schema in public metadata yet.
server_statusGet MySQL server status
Get MySQL server status
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
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
Details
- Repository
- github.com/daedalus/mcp-mysql-connector
- Category
- Databases
- Package
mcp-mysql-connector- Transport
- STDIO
- Registry
- MCP registry, active
More from daedalus
Related Databases MCP servers
View all
PostgreSQL MCP Serveritunified-io/mcp-postgresPostgreSQL MCP Server — 27 tools for queries, schema, CRUD, DBA, HA & server management0stars
PostgreSQL MCP Servermusaddiq-dev/postgresql-mcp-serverPython MCP server for PostgreSQL database inspection and querying0stars
Mcp Neo4j Aura Managerneo4j-contrib/mcp-neo4jMCP server for Neo4j Aura Database Instance Manager.958stars
