MySQL MCP Server

Stabledatabase

★320 starsTypeScriptbenborla

About

Overview

The MySQL MCP Server allows AI agents to interact with MySQL and MariaDB databases. It provides tools for executing queries, listing databases and tables, inspecting schemas, and understanding foreign key relationships. Supports connection pooling and SSL connections for production environments.

Capabilities

Tools & Capabilities

⚡query

Execute a SQL query against the MySQL database

⚡list_databases

List all databases on the MySQL server

⚡list_tables

List all tables in a specific database

⚡describe_table

Get column definitions and indexes for a table

Setup

Installation

bash

Install

npm install -g mcp-server-mysql

Examples

Example Usage

javascript

Usage

{
  "mcpServers": {
    "mysql": {
      "command": "mcp-server-mysql",
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "mydb"
      }
    }
  }
}

Quick Info

Authorbenborla

LanguageTypeScript

StatusStable

Stars★ 320

Last UpdatedFeb 12, 2026