MySQL
Enables AI assistants to securely manage MySQL databases by executing queries, inspecting schemas, and handling connections via the Model Context Protocol.
概要
The MySQL server is a Model Context Protocol (MCP) server designed to facilitate secure and comprehensive management of MySQL databases, including cloud instances like AWS RDS. It allows AI assistants and other MCP clients to interact with MySQL databases through a standardized interface, offering capabilities such as executing SQL queries with prepared statement support, inspecting schema details, managing indexes, and retrieving table statistics. This enables powerful natural language interactions with databases, streamlining development, data analysis, and schema exploration tasks for both local and cloud-hosted MySQL instances.
主な機能
- 4 GitHub stars
- Database Connection Management for local and cloud instances
- Comprehensive Schema Inspection (list databases, tables, describe structures)
- SQL Query Execution with Prepared Statement support
- Index and Table Statistics Management
- Secure Connection Handling with SSL support
ユースケース
- Exploring and understanding database schemas with AI assistance
- Performing data analysis and generating insights using natural language queries
- Connecting to AWS RDS, Google Cloud SQL, and other cloud MySQL instances