metamfetemin/mcp-mysql
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 dayong@mcphub.com.
The MCP MySQL Server is an advanced Model Context Protocol server designed to enhance MySQL database interactions with features like authentication, caching, and dynamic configuration.
Tools
Functions exposed to the LLM to take actions
mysql_auth
Authenticate user and receive a session token.
mysql_list_databases
List all available databases on the MySQL server.
mysql_list_tables
List all tables in a specific database.
mysql_describe_table
Get the structure/schema of a specific table.
mysql_query
Execute raw SQL queries with automatic permission checking and caching.
mysql_get_table_data
Retrieve data from a specific table with optional row limiting.
mysql_insert
Insert data into a table using key-value pairs.
mysql_update
Update existing records in a table.
mysql_delete
Delete records from a table.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client