kevinwatt/mysql-mcp
3.4
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 henry@mcphub.com.
An MCP server implementation that integrates with MySQL databases, providing secure database access capabilities for LLMs.
Tools
Functions exposed to the LLM to take actions
mysql_query
Execute read-only SELECT queries against the MySQL database.
- Maximum query length: 4096 characters
- Maximum result rows: 1000
- Query timeout: 30 seconds
mysql_execute
Execute data modification queries (INSERT/UPDATE/DELETE).
- Returns affected rows count and insert ID
- Supports parameterized queries
- Automatic transaction handling
list_tables
List all tables in current database
describe_table
Show table structure
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client
