mcpField
M
mysql-server MCP Server

mysql-server MCP Server

Local
github.com/xianzong85Databases0Updated 94w ago
Repository

About mysql-server MCP Server

mysql-server MCP Server is a TypeScript MCP server for accessing MySQL databases. It exposes a query tool that runs SQL and returns results, with connection settings supplied through environment variables.

Key features

  1. 01Execute SQL queries
  2. 02Return query results
  3. 03Configure database connection with environment variables

Use cases

  1. 01Run SQL against a configured MySQL database
  2. 02Retrieve query results for an MCP client

MCP support

Exposes a `query` tool to MCP clients for executing SQL statements against a MySQL database and returning results.

#mysql#mcp#database#typescript#mcp-server#database-access

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-server MCP Server

A Model Context Protocol server for MySQL database access

This is a TypeScript-based MCP server that provides tools for querying MySQL databases. It demonstrates core MCP concepts by providing:

  • Tools for executing SQL queries
  • Connection to MySQL databases via environment variables

Features

Tools
  • query - Execute SQL queries
    • Takes SQL query string as required parameter
    • Returns query results

Configuration

Set the following environment variables in your MCP server configuration:

  • MYSQL_HOST: MySQL server host
  • MYSQL_USER: MySQL username
  • MYSQL_PASSWORD: MySQL password
  • MYSQL_DATABASE: MySQL database name

Development

Install dependencies:

npm install

Build the server:

npm run build

For development with auto-rebuild:

npm run watch

Installation

To use with Claude Desktop, add the server config:

On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json On Windows: %APPDATA%/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mysql": {
      "command": "/path/to/mysql-server/build/index.js",
      "env": {
        "MYSQL_HOST": "your-mysql-host",
        "MYSQL_USER": "your-mysql-user",
        "MYSQL_PASSWORD": "your-mysql-password",
        "MYSQL_DATABASE": "your-mysql-database"
      }
    }
  }
}
Debugging

Since MCP servers communicate over stdio, debugging can be challenging. We recommend using the MCP Inspector, which is available as a package script:

npm run inspector

The Inspector will provide a URL to access debugging tools in your browser.

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.