enemyrr_mcp-mysql-server
If you are the rightful owner of enemyrr_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 robust Model Context Protocol server designed to facilitate seamless interaction between AI models and MySQL databases. It offers a standardized interface for executing various database operations, ensuring secure and efficient data handling. The server supports multiple connection methods, including database URLs, workspace paths, and direct credentials, making it versatile for different deployment scenarios. With built-in tools for executing queries, managing schemas, and handling errors, the server is equipped to meet the needs of developers working with MySQL databases in AI applications. Additionally, it provides comprehensive error handling and validation to ensure reliable operation.
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.
