Simple MCP MySQL Server
Overview
What is Simple MCP MySQL Server?
Simple MCP MySQL Server is a lightweight Model Context Protocol (MCP) server built with Python that enables secure interaction with MySQL databases, allowing AI assistants to execute SQL queries and retrieve data through a controlled interface.
How to use Simple MCP MySQL Server?
To use the server, clone the repository, install dependencies, set the required environment variables for database access, and run the server using the provided commands. You can also configure it to work with Claude Desktop for easier access.
Key features of Simple MCP MySQL Server?
- List all MySQL tables in the database
- Retrieve detailed schema information for all tables
- Execute read-only SQL queries with proper error handling
- Secure database access through environment variables
- Simple configuration and deployment
Use cases of Simple MCP MySQL Server?
- Enabling AI assistants to interact with MySQL databases securely.
- Facilitating data retrieval and manipulation through SQL queries.
- Providing a controlled environment for executing database operations.
FAQ from Simple MCP MySQL Server?
- Is the server secure for production use?
Yes, it is designed with security considerations, including using a database user with minimal permissions and avoiding root credentials.
- What are the requirements to run the server?
You need Python 3.12.2+, a MySQL server, and the 'uv' package for optimal performance.
- Can I use this server with other AI assistants?
Yes, it can be integrated with any AI assistant that supports the Model Context Protocol.
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
Tavily Mcp
RedisA Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
DeepChatYour AI Partner on Desktop
Playwright McpPlaywright MCP server
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.
WindsurfThe new purpose-built IDE to harness magic
ChatWiseThe second fastest AI chatbot™
CursorThe AI Code Editor
BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.
Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题；
Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"
Amap Maps高德地图官方 MCP Server
Serper MCP ServerA Serper MCP Server
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code