MCP.so
Sign In

MySQL MCP Server

@shreyansh-ghl

Basic information

Category

Databases

Transports

stdio

Author

shreyansh-ghl

About MySQL MCP Server

No overview available yet

MySQL MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MySQL MCP Server tools

1

Execute read-only SQL queries against the connected database

Overview

What is MySQL MCP Server?

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

How to use MySQL MCP Server?

Install globally with npm link, then run mysql-mcp-server mysql://username:password@host:3306/database. Alternatively, configure it as an MCP server in Cursor by adding the command and database URL to the MCP settings JSON.

Key features of MySQL MCP Server

  • Execute read-only SQL queries against a MySQL database.
  • Automatically discover and expose table schemas as JSON resources.
  • All queries run within a READ ONLY transaction.
  • Authentication handled via database URL credentials.
  • Integrates with Cursor’s Agentic chat for natural language querying.

Use cases of MySQL MCP Server

  • Let an LLM inspect database schemas and answer questions about table structures.
  • Run read-only analytical queries via natural language prompts in Cursor.
  • Provide safe, credential‑limited database access for AI assistants.

Frequently asked questions

1

What protocol does MySQL MCP Server use?

It implements the Model Context Protocol (MCP) for read‑only database interaction.

2

How is authentication handled?

Authentication uses a database URL in the format `mysql://username:password@host:port/database`. Credentials can be passed via environment variables for security.

3

What runtime dependencies are required?

Node.js and npm are required. The server is installed from a Git repository using `npm install` and `npm link`.

4

Where does the data live?

Data stays in the connected MySQL database. The server only reads metadata and executes queries; it does not store data locally.

5

What are the security recommendations?

Use a MySQL user with minimal read‑only permissions, store credentials in environment variables, and never commit configuration files with passwords to version control.

Comments

More Databases MCP servers