Advertise
MCP.so
Sign In

MySQL Database Access MCP Server

@MCP-Mirror

Repository

Basic information

Category

Databases

License

MIT license

Transports

stdio

Author

MCP-Mirror

About MySQL Database Access MCP Server

Mirror of

#mysql#database#mcp-server

MySQL Database Access MCP Server config

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

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "mysql-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "",
        "MYSQL_PORT": "",
        "MYSQL_USER": "",
        "MYSQL_PASSWORD": "",
        "MYSQL_DATABASE": ""
      }
    }
  }
}

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. It allows listing databases, listing tables, describing table schemas, and executing read-only SQL queries. It is designed for developers who need safe, read-only database exploration and querying via the Model Context Protocol.

How to use MySQL Database Access MCP Server?

Install globally via npm install -g mysql-mcp-server or locally. Configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE). Add the server to your MCP settings file using either npx mysql-mcp-server (npm install) or node /path/to/build/index.js (build from source).

Key features of MySQL Database Access MCP Server

  • Read-only access: only SELECT, SHOW, DESCRIBE, EXPLAIN allowed
  • Query validation prevents SQL injection and data modification
  • Query timeout prevents long-running queries
  • Row limit prevents excessive data return
  • Tools: list_databases, list_tables, describe_table, execute_query

Use cases of MySQL Database Access MCP Server

  • Exploring database structure (list tables, describe schemas)
  • Running safe, read-only analytics queries
  • Integrating MySQL data with AI assistants via MCP
  • Checking database content without write risk

Frequently asked questions

1

What dependencies does this server require?

Node.js and npm. A MySQL database server accessible via the provided credentials is also required.

2

How is authentication handled?

Authentication uses environment variables: `MYSQL_USER`, `MYSQL_PASSWORD`, and optionally `MYSQL_HOST` and `MYSQL_PORT`.

3

What security restrictions are in place?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Query validation blocks injection and data modification attempts. A query timeout and row limit protect resources.

4

Do I need to set up a MySQL user with specific permissions?

Yes. Your MySQL user must have appropriate permissions to list databases, list tables, describe schemas, and execute read-only queries on the target databases.

5

Can I modify data through this server?

No. The server enforces strict read-only access; any attempt to execute INSERT, UPDATE, DELETE, or other modification statements will be rejected.

Comments

More Databases MCP servers

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

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

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412
Advertise