MySQL Connector

概要

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.

主な機能

• 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.

ユースケース

• 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.