mysql-mcp-server
0
The MySQL MCP Server enables secure communication between AI applications and MySQL databases via the Model Context Protocol. It offers features for error-handling SQL execution, resource listing, and secure access, aimed at enhancing database interaction in a structured manner.
MySQL MCP Server
The MySQL MCP Server facilitates secure interactions between AI applications and MySQL databases through the Model Context Protocol (MCP). It provides a controlled interface for structured database exploration and analysis.
Key Features
- List available MySQL tables as resources
- Read table contents
- Execute SQL queries with error handling
- Secure database access via environment variables
- Comprehensive logging
Installation
- Manual Installation: Use the command
pip install mysql-mcp-server. - Smithery Installation: Use Smithery to automate the installation for Claude Desktop.
Usage
- Configure using
claude_desktop_config.jsonormcp.jsonfor Visual Studio Code.
Security Best Practices
- Use a dedicated MySQL user with minimum permissions.
- Never use root credentials.
- Restrict database access to necessary tasks only. Enable logging for all operations.