mysql-mcp
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.
The MySQL MCP Server is designed to facilitate secure and efficient interactions between MySQL databases and language learning models (LLMs). It offers a robust set of features for executing both read and write operations on databases, ensuring data safety and integrity through parameterized queries and transaction support. The server is equipped with security measures such as read-only transaction modes for SELECT queries, query length and result size limits, and performance monitoring. It is compatible with various platforms and can be easily integrated into existing systems using the provided configuration scripts.
Features
- Read Operations: Execute read-only SELECT queries, list all database tables, show table structures, and view schema information.
- Write Operations: Execute INSERT/UPDATE/DELETE with transaction support, parameterized queries for data safety, and return affected rows and insert IDs.
- Security: Read-only transaction mode for SELECT queries, query length and result size limits, performance monitoring and logging, and automatic transaction handling.
Tools
mysql_query
Execute read-only SELECT queries with limits on query length, result rows, and timeout.
mysql_execute
Execute data modification operations with automatic transaction handling and return affected rows count and last insert ID.
list_tables
List all tables in the current database without requiring inputs.
describe_table
Show table structure by providing the table name.
