MySQL MCP Server

@shreyansh-ghl

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

shreyansh-ghl

关于 MySQL MCP Server

暂无概览

#mysql #mcp-server #database-access

MySQL MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MySQL MCP Server 工具

Execute read-only SQL queries against the connected database

概览

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.

常见问题

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.

数据库分类下的更多 MCP 服务器

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