Sponsored by Deepsite.site

MySQL MCP Server

Created By
MCP-Mirror8 months ago
Mirror of
Overview

what is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) server that provides secure MySQL database operations for AI assistants and other MCP clients.

how to use MySQL MCP Server?

To use MySQL MCP Server, install it via npm and configure it with your MySQL database credentials. You can then connect it to various MCP clients to perform database operations.

key features of MySQL MCP Server?

  • Execute safe SQL queries (SELECT, INSERT, SHOW, DESCRIBE)
  • Get detailed table structure information
  • Convenient data insertion with automatic parameterization
  • List all tables in the database
  • Security features including SQL injection protection and connection pooling

use cases of MySQL MCP Server?

  1. Securely managing database operations for AI applications.
  2. Integrating with AI assistants to provide dynamic data access.
  3. Facilitating safe database interactions in multi-client environments.

FAQ from MySQL MCP Server?

  • What operations are allowed?

Only safe operations like SELECT, INSERT, SHOW, and DESCRIBE are permitted.

  • How do I install the server?

You can install it using npm with the command npm install mysql-mcp-server.

  • Is there support for SQL injection protection?

Yes, the server uses parameterized queries to protect against SQL injection.

Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
DeepChatYour AI Partner on Desktop
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.
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
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.
CursorThe AI Code Editor
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"
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.
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
Amap Maps高德地图官方 MCP Server
Playwright McpPlaywright MCP server
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
ChatWiseThe second fastest AI chatbot™
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.
Serper MCP ServerA Serper MCP Server
WindsurfThe new purpose-built IDE to harness magic
Tavily Mcp
Baidu Map百度地图核心API现已全面兼容MCP协议,是国内首家兼容MCP协议的地图服务商。
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.