MySQL MCP Server

A powerful MCP server that provides direct access to MySQL databases. This server enables AI agents to interact with MySQL databases, execute SQL queries, and manage database content through a simple interface.

Features

Resources

• Access notes stored in the database via note:///{id} URIs

• Each note has a title and content

• Plain text mime type for simple content access

Tools

• create_note - Create new text notes in the database

  • Takes title and content as required parameters

  • Stores note in the MySQL database

• list_tables - List all tables in the connected database

• count_tables - Get the total number of tables in the database

• search_tables - Search for tables using LIKE pattern

• describe_table - Get the structure of a specific table

• execute_sql - Execute custom SQL queries

Related MCP server: MCP-MySQL Server

Prerequisites

• Node.js 18 or higher

• MySQL server installed and running

• A database with appropriate permissions

Setup

1. Clone this repository:

   git clone git@github.com:LeonMelamud/mysql-mcp.git cd mysql-mcp

2. Install dependencies:

   npm install

3. Create a .env file in the root directory with your MySQL connection details:

   MYSQL_HOST=localhost MYSQL_USER=your_username MYSQL_PASSWORD=your_password MYSQL_DATABASE=your_database

4. Build the server:

   npm run build

Installation

For Claude Desktop

Add the server config to your Claude Desktop configuration file:

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

For Cline

Add the server config to your Cline MCP settings file:

On MacOS: ~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json On Windows: %APPDATA%\Code\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json

Usage Examples

Once installed, you can use the MySQL MCP server in your conversations with Claude:

List all tables in the database

Execute a SQL query

Create a note

Development

For development with auto-rebuild:

Debugging

Use the MCP Inspector to debug the server:

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

License

MIT