MySQL MCP Server

@shreyansh-ghl

Repository

Basic information

About MySQL MCP Server

No overview available yet

#mysql #mcp-server #database-access

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

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

What protocol does MySQL MCP Server use?

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

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.

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`.

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.

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

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

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

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.