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)
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIOur bundler currently only supports TypeScript-based servers. Check back soon!