Sponsored by Deepsite.site

MySQL MCP Server

Created By
MCP-Mirrora year ago
Mirror of
Overview

what is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) server that provides access to a MySQL database, allowing agents to execute SQL queries.

how to use MySQL MCP Server?

To use the MySQL MCP Server, clone the repository, install dependencies, configure the database connection settings, and run the server. You can then execute SQL queries through the MCP interface.

key features of MySQL MCP Server?

  • Execute SQL queries (SELECT, CREATE, INSERT, UPDATE, DELETE)
  • Returns results in JSON format
  • Configurable database connection settings
  • Transaction logging with unique IDs

use cases of MySQL MCP Server?

  1. Accessing and manipulating data in a MySQL database.
  2. Integrating SQL query execution into applications using the MCP protocol.
  3. Logging and auditing database transactions.

FAQ from MySQL MCP Server?

  • What are the prerequisites for using MySQL MCP Server?

You need Node.js (v14 or higher), a MySQL server, and the MCP SDK.

  • How do I configure the MySQL MCP Server?

You need to set environment variables for the MySQL connection and configure the MCP settings file.

  • Can I use MySQL MCP Server for production?

Yes, but ensure to follow security best practices for database access.

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