dlbiaan/mcp-server-mysql
If you are the rightful owner of mcp-server-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.
A Model Context Protocol server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.
Tools
Functions exposed to the LLM to take actions
connect_db
Connect to MySQL database using URL, workspace path, or direct credentials
query
Execute SELECT query (support parameter binding)
execute
Perform INSERT/UPDATE/DELETE operation
list_tables
List all tables in the database
describe_table
Get table structure information
create_table
Create a new table (supports field and index definitions)
add_column
Add new columns to existing tables
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client