mysql-mcp-server
1
The MySQL MCP Server is a model context protocol server designed to facilitate the execution of SQL queries on a MySQL database. It offers configurable settings and logs transactions for auditing purposes, serving as a bridge for integrating database operations into conversations with AI.
MySQL MCP Server
This project provides a Model Context Protocol (MCP) server for accessing a MySQL database. It enables agents to execute SQL queries, featuring:
- Execution of SQL queries (SELECT, CREATE TABLE, INSERT INTO, UPDATE, DELETE)
- Query results returned in JSON format
- Configurable database connection settings
- Transaction logging with unique IDs
Prerequisites
- Node.js (v14 or higher)
- MySQL server
- MCP SDK
Usage
Once configured, the server can be integrated into conversations with Claude to perform SQL operations.
Security Considerations
- Use dedicated MySQL user privileges
- Consider read-only privileges for queries
- Log operations with unique transaction IDs