MySQL

概要

MySQL MCP is a server that connects AI agents to a MySQL database, empowering them to interact with data programmatically. It allows agents to perform comprehensive SQL queries, from retrieving information with SELECT statements to modifying schemas and data using CREATE TABLE, INSERT INTO, UPDATE, and DELETE commands. The server delivers query results in a standardized JSON format, offers configurable database connection settings via environment variables, and ensures all operations are logged with unique transaction IDs for traceability and auditing. This integration streamlines database interaction for AI-driven applications and tools like Claude.

主な機能

• Logs all database transactions with unique IDs
• Integrates with Model Context Protocol (MCP) enabled agents
• 0 GitHub stars
• Execute full CRUD operations (Create, Read, Update, Delete) on MySQL databases
• Returns SQL query results in JSON format
• Configurable database connection settings via environment variables

ユースケース

• Allowing AI agents to query and retrieve data from a MySQL database
• Enabling AI-driven tools to manage database schemas and content
• Automating database interactions within AI-assisted development environments