MySQL Database
Summary
MCP MySQL Server provides a standardized interface for AI models to interact with MySQL databases, enabling operations like executing queries, listing tables, and describing table structures. Built by f4ww4z, it leverages the Model Context Protocol SDK and mysql2 library to offer secure database connections with prepared statements to prevent SQL injection. The server handles connection management automatically, provides comprehensive error handling, and can be easily configured through environment variables, making it ideal for AI workflows that require database access without leaving the conversation context.
Available Actions(5)
connect_db
Establish connection to MySQL database using provided credentials. Parameters: host (string), user (string), password (string), database (string)
query
Execute SELECT queries with optional prepared statement parameters. Parameters: sql (string), params (array of mixed)
execute
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters. Parameters: sql (string), params (array of mixed)
list_tables
List all tables in the connected database. Parameters: None
describe_table
Get the structure of a specific table. Parameters: table (string)
Community Reviews
No reviews yet. Be the first to review!
Sign in to join the conversation
