josiah-hester/mysql-mcp
3.1
If you are the rightful owner of mysql-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
A Model Context Protocol (MCP) server that provides tools for interacting with MySQL databases.
Tools
Functions exposed to the LLM to take actions
connect
Connect to a MySQL database using a Data Source Name (DSN).
list_databases
List all databases on the MySQL server.
list_tables
List all tables in a specific database.
describe_table
Describe the structure of a specific table, including columns, data types, and constraints.
execute_query
Execute a SQL query. SELECT queries return data, while other queries return the number of affected rows.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client