MCP Server for MySQL based on NodeJS
Overview
What is MCP Server for MySQL?
MCP Server for MySQL is a Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
How to use MCP Server for MySQL?
To use the MCP Server, you can install it via Smithery, MCP Get, or manually using NPM/PNPM. After installation, configure your LLM application to connect to the MCP server using your MySQL connection details.
Key features of MCP Server for MySQL?
- Execute read-only SQL queries securely.
- Provides comprehensive database information including table schemas and statistics.
- Security features like SQL injection prevention and query whitelisting.
- Performance optimizations such as connection pooling and query caching.
- Monitoring and debugging tools for query logging and performance metrics.
Use cases of MCP Server for MySQL?
- Allowing LLMs to query MySQL databases without write access.
- Providing a secure interface for data analysis and reporting.
- Enabling developers to build applications that require read-only access to database information.
FAQ from MCP Server for MySQL?
- Can I use MCP Server for write operations?
No, the MCP Server is designed for read-only access to ensure data integrity.
- How do I troubleshoot connection issues?
Verify that your MySQL server is running and that the connection details are correct. Use the built-in diagnostics from Smithery or MCP Get for troubleshooting.
- Is there a license for MCP Server?
Yes, the MCP Server is licensed under the MIT License.
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
WindsurfThe new purpose-built IDE to harness magic
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.
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.
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
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"
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
Serper MCP ServerA Serper MCP Server
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.
Amap Maps高德地图官方 MCP Server
Playwright McpPlaywright MCP server
ChatWiseThe second fastest AI chatbot™
Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors
CursorThe AI Code Editor
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
Tavily Mcp
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
DeepChatYour AI Partner on Desktop