mcp-mysql-server
If you are the rightful owner of mcp-mysql-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 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.
The @enemyrr/mcp-mysql-server is a Model Context Protocol (MCP) server designed to facilitate interactions between AI models and MySQL databases. It provides a standardized interface for executing database operations such as connecting to databases, executing queries, and managing database schemas. The server supports multiple connection methods, including using a database URL, workspace path, or direct credentials. It is equipped with tools for executing SELECT, INSERT, UPDATE, DELETE queries, and managing database tables. The server ensures secure and efficient database operations with features like prepared statement support, automatic connection cleanup, and comprehensive error handling. It is compatible with TypeScript and can be integrated into various development environments, including Cursor IDE.
Features
- Multiple connection methods (URL, workspace, direct)
- Secure connection handling with automatic cleanup
- Prepared statement support for query parameters
- Schema management tools
- Comprehensive error handling and validation
Tools
connect_db
Connect to MySQL database using URL, workspace path, or direct credentials.
query
Execute SELECT queries with optional prepared statement parameters.
execute
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.
list_tables
List all tables in the connected database.
describe_table
Get the structure of a specific table.
create_table
Create a new table with specified fields and indexes.
add_column
Add a new column to an existing table.
