Which integrations are available for this server?

Allows executing SQL queries against MySQL databases by providing connection to MySQL databases and tools for executing SQL queries

How do I use MySQL Server MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MySQL Server MCP Server show me the top 10 customers by total purchases" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

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

Related MCP server: MySQL MCP Server

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" } } } }