MySQL Query MCP Server

Name: MySQL Query MCP Server
Author: devakone

@devakone

Repository

About MySQL Query MCP Server

MySQL Query MCP server for AI assistants - execute read-only MySQL queries

Basic information

Config

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

{
  "mcpServers": {
    "mysql-query-mcp-server": {
      "command": "npx",
      "args": [
        "mysql-query-mcp-server"
      ]
    }
  }
}

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 Query MCP Server?

A Model Context Protocol (MCP) server that provides read-only MySQL database queries for AI assistants. It enables AI-powered tools like Cursor IDE and Anthropic Claude to execute queries, explore database structures, and investigate data directly.

How to use MySQL Query MCP Server?

Install globally with npm install -g mysql-query-mcp-server or run instantly with npx mysql-query-mcp-server. Configure your AI tool’s MCP settings (e.g., .cursor/mcp.json) with environment variables for database credentials (LOCAL_DB_HOST, LOCAL_DB_USER, etc.). The server exposes three tools: query (read-only SQL), info (database metadata), and environments (list configured environments).

Key features of MySQL Query MCP Server

Read-only MySQL queries (SELECT, SHOW, DESCRIBE)
Predefined environments: local, development, staging, production
SSL support for secure database connections
Query timeout to prevent long-running operations
Database information and metadata retrieval
Lists available database environments

Use cases of MySQL Query MCP Server

Investigate database structure and table schemas via AI assistants
Run read-only analytical queries on production data without risk
Explore development and staging databases for debugging
List available database environments from configuration
Retrieve database metadata such as version and connection status

FAQ from MySQL Query MCP Server

What types of queries can I execute?

Only read‑only SQL statements: SELECT, SHOW

Comments

More Databases MCP servers

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245