MySQL MCP Server

@affannahmed

Repository

Basic information

About MySQL MCP Server

No overview available yet

#mysql #mcp-server #ai-integration

MySQL MCP Server 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"
      ]
    }
  }
}

MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

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

More AI & Agents MCP servers

FLORA

FLORA is a remote MCP server available at https://agents.flora.ai. The FLORA MCP lets users generate, organize, and iterate on visual assets — hero images, moodboards, lifestyle shots, promo graphics — directly from a co

Plainpaper

The AI marketing canvas for Claude and MCP agents. Your agent drafts campaigns as cards on a shared board, briefed by your brand rules, approved by you.

PDI Bridge for Claude

jxrlabs

Connect Claude Desktop to your ServiceNow PDI. Query records, inspect Business Rules, review ACLs, and troubleshoot against your live instance.

Krafters

Krafters (Romain Duclos)

Krafters is a French club of specialized AIs for freelancers and small businesses. Its connector opens the member's AI kits for Facebook and Instagram ads, SEO/GEO and short videos directly in Claude, and gives the next

CrawlForge MCP Server

mysleekdesigns

28-tool MCP server for web scraping, crawling, deep research & autonomous extraction — clean Markdown & structured JSON for Claude, Cursor & any MCP client. 1,000 free one-time credits, local-Ollama LLM support.