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

Fetch the live tool list by running this server in a temporary sandbox using the button above.

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

Transform MCP

Unstructured

The Unstructured Transform MCP Server connects your ADK agent to Unstructured, a document processing platform that turns raw files into structured, AI-ready data. This integration gives your agent the ability to parse PD

Lumify Sports Intelligence

Lumify

Agent-ready sports intelligence API: live scores, odds, line movement, public betting splits, and explainable bet confidence — via 16 MCP tools at https://lumify.ai/mcp. Get a free key instantly — no signup, email, or ca

XDC AI

XDC AI is a remote MCP server available at https://xdcai.tech.

GetIntel

tarang8811

Public docs + tool manifest for the GetIntel MCP connector (app.getintel.ai)

q-ring

I4cTime

Quantum-inspired keyring for AI coding agents. Secure secrets with superposition, entanglement, tunneling, and teleportation — CLI + 44 MCP tools.

3