MySQL Database
Summary
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.
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: {}
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
Highlight AI