mcpField
M
MySQL MCP Server

MySQL MCP Server

Local
github.com/tqvthu-worksDatabases0Updated 79w ago
Repository

About MySQL MCP Server

MySQL MCP Server connects Cursor IDE to MySQL databases for users who need to query data and inspect schemas from the IDE. Queries are read-only by default, with configurable write permissions.

Key features

  1. 01Run SQL queries, read-only by default
  2. 02Inspect database schemas
  3. 03Configure insert and update permissions

Use cases

  1. 01Query MySQL data from Cursor IDE
  2. 02Inspect database tables and schemas
  3. 03Enable insert or update operations when needed

MCP support

The MCP server provides Cursor IDE clients with MySQL query and schema-inspection capabilities, with configurable write permissions.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

MySQL MCP Server

A Model Context Protocol (MCP) server for interacting with MySQL databases in Cursor IDE.

Features

  • Execute SQL queries (read-only by default).
  • Inspect database schemas.
  • Configurable write permissions.

Installation

npm install

Configuration

Create .env with:
MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=your_username
MYSQL_PASS=your_password
MYSQL_DB=your_database
ALLOW_INSERT_OPERATION=false
ALLOW_UPDATE_OPERATION=false
ALLOW_DELETE_OPERATION=false

Usage in Cursor

Add to .cursor/mcp.json
{
  "mcpServers": {
    "mysqlMcpServer": {
      "command": "npx",
      "args": ["ts-node", "path/to/src/index.ts"],
      "env": {
        "MYSQL_HOST": "<host>",
        "MYSQL_PORT": "<port>",
        "MYSQL_USER": "<user>",
        "MYSQL_PASS": "<pass>",
        "MYSQL_DB": "db",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false"
      }
    }
  }
}

License

MIT

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.