MySQL MCP Server provides read-only access to MySQL databases, allowing AI assistants to list databases, explore table schemas, and execute SELECT queries with built-in security safeguards. Developed by Diogo Lucas, it implements strict query validation to prevent SQL injection and data modification, enforces query timeouts and row limits to protect resources, and can be easily configured through environment variables. The server is particularly valuable for workflows requiring database exploration and data analysis without compromising database security or performance.
暂无评论. 成为第一个评论的人！
登录以参与讨论
Lists all accessible databases on the MySQL server. Parameters: None
Lists all tables in a specified database. Parameters: database (optional): Database name (uses default if not specified)
Shows the schema for a specific table. Parameters: database (optional): Database name (uses default if not specified), table (required): Table name
Executes a read-only SQL query. Parameters: query (required): SQL query (only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed), database (optional): Database name (uses default if not specified)
