Mcp_server_mysql

Created By

benborla10 months ago

Overview

What is MCP Server for MySQL?

MCP Server for MySQL is a Model Context Protocol server built on Node.js that provides access to MySQL databases, enabling large language models (LLMs) to inspect database schemas and execute SQL queries.

How to use MCP Server for MySQL?

To use the MCP Server, install it via npm or through Smithery, configure your MySQL connection details, and run the server. You can execute SQL queries through the server once it's set up.

Key features of MCP Server for MySQL?

Execute SQL queries against MySQL databases.
Supports read and write operations with proper permissions.
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.

Use cases of MCP Server for MySQL?

Integrating LLMs with MySQL databases for dynamic data retrieval.
Automating database management tasks through SQL queries.
Enhancing applications with real-time data access and manipulation capabilities.

FAQ from MCP Server for MySQL?

Can I use MCP Server with any version of MySQL?
Yes, it supports MySQL 5.7 and higher, with MySQL 8.0+ recommended.
Is there a way to enable write operations?
Yes, you can enable INSERT, UPDATE, and DELETE operations through configuration settings.
How do I troubleshoot connection issues?
Ensure your MySQL server is running, check your credentials, and verify SSL settings if applicable.

Server Config

{
  "mcpServers": {
    "mcp_server_mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "password",
        "MYSQL_DB": "your_db",
        "ALLOW_INSERT_OPERATION": "true",
        "ALLOW_UPDATE_OPERATION": "true",
        "ALLOW_DELETE_OPERATION": "true"
      }
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

ChatWiseThe second fastest AI chatbot™

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

CursorThe AI Code Editor

Playwright McpPlaywright MCP server

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.

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.

DeepChatYour AI Partner on Desktop

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.

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code