mcp-mysql

sajithrw/mcp-mysql

3.3

If you are the rightful owner of mcp-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The MCP MySQL Server is a Model Context Protocol server designed for managing MySQL databases, including cloud instances like AWS RDS, through a standardized interface.

Tools

Functions exposed to the LLM to take actions

mysql_connect

Connect to a MySQL database.

mysql_query

Execute a SQL query on the connected database.

mysql_list_databases

List all databases on the MySQL server.

mysql_list_tables

List all tables in the current or specified database.

mysql_describe_table

Get the structure/schema of a specific table.

mysql_show_indexes

Show indexes for a specific table.

mysql_get_table_stats

Get statistics about a table (row count, size, etc.).

mysql_disconnect

Disconnect from the MySQL database.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources