This MCP server, developed by Ben Borla, provides read-only access to MySQL databases for large language models. Built in TypeScript, it integrates with Claude Desktop and enables AI assistants to inspect database schemas and execute read-only SQL queries. The implementation stands out by focusing on security through read-only transactions and offering flexible database connection options. By bridging AI models with relational databases, this server allows AI systems to analyze data patterns, extract insights, and provide data-driven responses. It is particularly useful for scenarios like data exploration, report generation, and building AI assistants that can leverage structured data from MySQL databases while maintaining data integrity.
Execute SQL queries against the connected database. Input: sql (string): The SQL query to execute. By default, limited to READ ONLY operations. Optional write operations include INSERT (requires ALLOW_INSERT_OPERATION=true), UPDATE (requires ALLOW_UPDATE_OPERATION=true), and DELETE (requires ALLOW_DELETE_OPERATION=true).
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AI