This MCP MySQL server, developed by f4ww4z, enables AI assistants like Claude to interact with MySQL databases through a standardized interface. Built in JavaScript/TypeScript, it provides capabilities for executing queries, managing database connections, and retrieving schema information. The implementation stands out by offering prepared statement support, automatic connection management, and comprehensive error handling. By connecting AI capabilities with relational database operations, this server allows AI systems to query and manipulate data in MySQL databases programmatically. It is particularly useful for building AI-powered data analysis tools, automated reporting systems, and intelligent assistants that need to interact with MySQL-based applications and data stores.
Establish connection to MySQL database using provided credentials. Parameters: host (string), user (string), password (string), database (string)
Execute SELECT queries with optional prepared statement parameters. Parameters: sql (string), params (array of values)
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters. Parameters: sql (string), params (array of values)
List all tables in the connected database. Parameters: none
Get the structure of a specific table. Parameters: table (string)
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIStart the server with node to access it via any client or IDE.
node path/to/downloaded/file.mjs