MySQL MCP Server

by kerongon

Data/Databases MySQL Database Access SQL Server

A Model Context Protocol (MCP) server that provides MySQL database access functionality. It allows listing database tables, executing read-only SQL queries, and offers secure connection handling with connection pooling.

Last updated: N/A

MySQL MCP Server

A Model Context Protocol (MCP) server that provides MySQL database access functionality.

Features

List database tables and their schemas
Execute read-only SQL queries
Secure connection handling with connection pooling

Installation

Clone this repository
Install dependencies:

npm install

Build the project:

npm run build

Configuration

Set the following environment variables:

MYSQL_HOST: MySQL server host
MYSQL_PORT: MySQL server port
MYSQL_USER: MySQL username
MYSQL_PASS: MySQL password
MYSQL_DB: MySQL database name
MYSQL_SOCKET: MySQL socket path (alternative to host/port)
MYSQL_POOL_LIMIT: Connection pool limit (default: 10)

Usage

The server will automatically start when the MCP system initializes it. You can then use the provided tools and resources through the MCP interface.

License

MIT