MySQL

概要

The MySQL MCP Server is a Model Context Protocol (MCP) server engineered for secure and resilient interaction with MySQL databases. It offers a robust interface for AI assistants like Claude Code and Codex CLI, ensuring that database operations are performed with built-in safety features. Key priorities include SQL injection prevention via prepared statements, strict schema protection that blocks DROP, TRUNCATE, and ALTER operations, and configurable resistance against INSERT, UPDATE, and DELETE commands. With comprehensive tools for query execution, table listing, and schema inspection, it provides a controlled and efficient gateway to your MySQL data.

主な機能

• Safe MySQL Operations with controlled destructive actions
• Configurable operation resistance for INSERT, UPDATE, and DELETE
• Permanent schema protection against DROP, TRUNCATE, and ALTER
• SQL injection prevention using prepared statements
• Tools for query execution, table listing, schema inspection, and database info
• 0 GitHub stars

ユースケース

• Integrating MySQL database access into AI assistant workflows (e.g., Claude Code, Codex CLI)
• Securely querying and analyzing database content with read-only defaults
• Managing controlled write operations (INSERT, UPDATE, DELETE) with explicit permissions