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 values)
execute
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters. Parameters: sql (string), params (array of values)
list_tables
List all tables in the connected database. Parameters: none
describe_table
Get the structure of a specific table. Parameters: table (string)
社区评论
暂无评论. 成为第一个评论的人！
登录以参与讨论
