MCP.so
Sign In

MySQL MCP Server

@affannahmed

Repository

About MySQL MCP Server

No overview available yet

#mysql#mcp-server#ai-integration

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "MCP-Server-with-Claude-Ai": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "mysql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MySQL MCP Server?

A Model Context Protocol (MCP) implementation that enables secure interaction between AI applications and MySQL databases through a controlled interface, making database exploration and analysis safer and more structured.

How to use MySQL MCP Server?

Install via pip install mysql-mcp-server or automatically through Smithery. Configure by setting environment variables for MySQL host, port, user, password, and database. Integrate with Claude Desktop by adding the server configuration to claude_desktop_config.json.

Key features of MySQL MCP Server

  • List available MySQL tables as resources
  • Read table contents
  • Execute SQL queries with proper error handling
  • Secure database access through environment variables
  • Comprehensive logging

Use cases of MySQL MCP Server

  • Exploring database schemas by listing tables
  • Analyzing data by reading table contents
  • Running controlled SQL queries through AI applications

FAQ from MySQL MCP Server

Can MySQL MCP Server be run as a standalone server?

No, it is designed as a communication protocol implementation between AI applications and MySQL databases, not as a standalone server.

What are the dependencies and runtime requirements?

The server requires Python and can be installed via pip. It expects a running MySQL database accessible via environment variable configuration.

How is database access secured?

Access is configured through environment variables for host, port, user, password, and database. The README recommends creating a dedicated MySQL user with minimal permissions and never using root credentials.

What installation methods are available?

Manual installation via pip install mysql-mcp-server or automatic installation for Claude Desktop via Smithery using npx -y @smithery/cli install mysql-mcp-server --client claude.

What data does the server access and where does it live

Frequently asked questions

Can MySQL MCP Server be run as a standalone server?

No, it is designed as a communication protocol implementation between AI applications and MySQL databases, not as a standalone server.

What are the dependencies and runtime requirements?

The server requires Python and can be installed via pip. It expects a running MySQL database accessible via environment variable configuration.

How is database access secured?

Access is configured through environment variables for host, port, user, password, and database. The README recommends creating a dedicated MySQL user with minimal permissions and never using root credentials.

What installation methods are available?

Manual installation via `pip install mysql-mcp-server` or automatic installation for Claude Desktop via Smithery using `npx -y @smithery/cli install mysql-mcp-server --client claude`.

Comments

Basic information

Category

AI & Agents

License

MIT license

Transports

stdio

Author

affannahmed

More AI & Agents MCP servers

MCP-LLM Bridge

patruff

Bridge between Ollama and MCP servers, enabling local LLMs to use Model Context Protocol tools

976

MCP Client for Ollama (ollmcp)

jonigl

Harness the power of local LLMs with this TUI MCP Client for Ollama. Featuring all core MCP primitives (tools, prompts, resources), agent mode, multi-server, model switching, streaming responses, human-in-the-loop, thinking mode, model params config, system prompts, and saved pre

768

Solon Ai

opensolon

Java AI application development framework (supports LLM-tool,skill; RAG; MCP; Agent-ReAct,Team-Agent). Compatible with java8 ~ java25. It can also be embedded in SpringBoot, jFinal, Vert.x, Quarkus, and other frameworks.

416

Unreal Engine Generative AI Support Plugin

prajwalshettydev

Unreal Engine plugin for LLM/GenAI models & MCP UE5 server. OpenAI GPT-5, Deepseek R1, Claude Opus/Sonnet, Gemini 3, Grok 4, Alibaba Qwen, Kimi, ElevenLabs TTS, Inworld, OpenRouter, Groq, GLM, Ollama, Local, Meshy, Tripo, Hunyuan3D, Rodin, fal, Dashscope, Seedream. NPC AI, agenti

622

Model Context Protocol for Unreal Engine

chongdashu

Enable AI assistant clients like Cursor, Windsurf and Claude Desktop to control Unreal Engine through natural language using the Model Context Protocol (MCP).

2.0K