MySQL Query MCP Server

@devakone

About MySQL Query MCP Server

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

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

Frequently asked questions

What types of queries can I execute?

Only read‑only SQL statements: SELECT, SHOW

Comments

Basic information

More Databases MCP servers

mcp_mysql_server

xwb602625136

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

245

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s