dvalenza/Generic-MySQL-MCP-Server
If you are the rightful owner of Generic-MySQL-MCP-Server 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 connecting to and querying generic MySQL databases.
Tools
Functions exposed to the LLM to take actions
query_database
Execute SELECT queries on the MySQL database.
update_database
Execute INSERT, UPDATE, DELETE, CREATE, ALTER, or DROP queries.
describe_table
Get detailed schema information for a specific table.
list_tables
Retrieve all table names in the current database.
list_databases
Get all databases available on the MySQL server.
test_connection
Verify the database connection is working.
explain_query
Get the execution plan for a SELECT query.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client