MySQL Connector
Createdzhaoxin34
Enables LLMs to inspect MySQL database schemas and execute read-only queries for enhanced data access.
About
MySQL Connector is a Model Context Protocol (MCP) server designed to provide Large Language Models (LLMs) with secure, read-only access to MySQL databases. It empowers LLMs to inspect database schemas, execute SQL queries within a read-only transaction, and retrieve valuable data for a variety of applications. With features like SQL injection prevention, query whitelisting, and performance optimizations, it offers a robust and secure solution for integrating MySQL databases with LLM-powered systems.
Key Features
- Enables query logging and performance metrics collection.
- Offers SQL injection prevention and query whitelisting.
- Includes query result caching and connection pooling for performance.
- Provides comprehensive database schema information in JSON format.
- Executes read-only SQL queries with prepared statements.
Use Cases
- Enabling LLMs to answer questions based on data stored in MySQL databases.
- Automating data extraction and analysis using LLMs.
- Building LLM-powered applications that interact with MySQL databases.