designcomputer/mysql_mcp_server

Overview

A Model Context Protocol server that provides secure access to MySQL databases. It enables AI models to execute queries and manage data through a standardized interface. Written in Python.

Best for

Best for
Developers who need to give AI models controlled, secure access to MySQL databases using the Model Context Protocol

Use cases

• Connecting AI assistants to MySQL for real-time data retrieval
• Automating database queries and updates from MCP-compatible agents
• Integrating MySQL into AI-driven data processing pipelines

How to use

Install

npx -y @smithery/cli install designcomputer/mysql-mcp-server --client claude

Tools exposed

• explore_database
• analyze_table

Tested with

Claude Desktop, Claude Code

Notes

A Model Context Protocol server that provides secure access to MySQL databases. It enables AI models to execute queries and manage data through a standardized interface. Written in Python.

1,275 stars on GitHub. Last updated 2026-06-01. Licensed MIT.

Use cases

• Connecting AI assistants to MySQL for real-time data retrieval
• Automating database queries and updates from MCP-compatible agents
• Integrating MySQL into AI-driven data processing pipelines

Pros

• Well-adopted with over 1,200 GitHub stars indicating community trust
• Simple Python-based setup that follows the MCP standard
• Encourages secure interaction patterns for database access

Cons

• Requires an MCP-compatible client or host to be useful
• Database credential management introduces security considerations
• May not cover all MySQL features like advanced SQL functions or administration

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.