Advertise
MCP.so
Sign In

MySQL Database Access MCP Server

@dpflucas

Repository

Basic information

Category

Databases

Last updated

License

MIT

Transports

stdio

Author

dpflucas

About MySQL Database Access MCP Server

An MCP server provides read-only access to MySQL databases.

MySQL Database Access MCP Server config

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

{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@dpflucas/mysql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

MySQL Database Access 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 Database Access MCP Server?

This MCP server provides read-only access to MySQL databases, allowing users to list databases, list tables, describe schemas, and execute safe SQL queries. It is designed for AI assistants and tools that need to inspect or query MySQL data without modification.

How to use MySQL Database Access MCP Server?

Install via npm (npm install -g mysql-mcp-server), build from source, or use Smithery. Configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) and add the server to your MCP settings file. Once connected, invoke the tools list_databases, list_tables, describe_table, or execute_query with the required parameters.

Key features of MySQL Database Access MCP Server

  • Read-only access to MySQL databases
  • Query validation against injection and modification
  • Query timeout and row limit protection
  • Tools: list databases, list tables, describe schema
  • Execute SELECT, SHOW, DESCRIBE, EXPLAIN queries
  • Advanced connection pool configuration

Use cases of MySQL Database Access MCP Server

  • Exploring database structure (tables, schemas) via an AI assistant
  • Retrieving read-only data for analysis or reporting
  • Inspecting table schemas before integration or migration
  • Debugging queries without risk of accidental writes

Frequently asked questions

1

What types of queries are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted. All other statements are blocked for safety.

2

What environment variables are required?

`MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER` are required. `MYSQL_PASSWORD` and `MYSQL_DATABASE` are optional but recommended.

3

How do I install the server?

Install globally from npm (`npm install -g mysql-mcp-server`), locally in a project, build from source, or use the Smithery CLI.

4

Are there any limits on queries?

Yes: a query timeout prevents long-running queries, and a row limit prevents excessive data return. The connection pool is also configurable.

5

Can I write or modify data?

No. The server enforces read-only access; any attempt to execute INSERT, UPDATE, DELETE, or DDL statements is rejected.

Comments

More Databases MCP servers

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Advertise