MySQL MCP Server

MCP server for MySQL database operations: query, execute, list and describe tables via prepared statements.

Unverified

stdio (local)

No auth

Stale

JavaScript

View repo 162 npm

Add to your client

Copy the config for your MCP client and paste it into its config file.

Install / run

npx @f4ww4z/mcp-mysql-server

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@f4ww4z/mcp-mysql-server",
        "mysql://user:password@localhost:port/database"
      ]
    }
  }
}

Step-by-step guides: Add to Claude Desktop · Add to Cursor · Add to Windsurf

Before you start

Node.js (for npx)
A reachable MySQL database with valid credentials

About MySQL MCP Server

A Model Context Protocol server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface. It supports secure connection handling with automatic cleanup, prepared statement support for query parameters, comprehensive error handling and validation, and automatic connection management. Credentials can be passed either as a MySQL connection URL argument or through MYSQL_HOST/MYSQL_USER/MYSQL_PASSWORD/MYSQL_DATABASE environment variables.

Tools & capabilities (5)

connect_db

Establish connection to MySQL database using provided credentials (host, user, password, database).

query

Execute SELECT queries with optional prepared statement parameters.

execute

Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.

list_tables

List all tables in the connected database.

describe_table

Get the structure of a specific table.

What this server can do

MySQL MCP Server provides tools for these capabilities — tap one to see every MCP server that does the same:

Inspect database schema

When to use it

Let an AI assistant inspect a MySQL schema by listing and describing tables.
Run parameterized SELECT queries against a MySQL database from an AI client.
Perform INSERT/UPDATE/DELETE operations on MySQL data through prepared statements.
Explore and prototype against a live MySQL database during development.

Security notes

Uses prepared statements to prevent SQL injection and validates queries before execution. Supports secure password handling through environment variables and automatically closes connections when done.

MySQL MCP Server FAQ

How do I provide database credentials?

Either pass a MySQL connection URL (mysql://user:password@host:port/database) as an argument in the args array, or set the MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE environment variables in your MCP settings.

Does it protect against SQL injection?

Yes. The server uses prepared statements for query parameters and validates queries before execution.

How do I install it for Claude Desktop?

You can install it automatically via Smithery with: npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude, or configure it manually with npx @f4ww4z/mcp-mysql-server.

#mysql #database #sql #query #prepared-statements

Alternatives to MySQL MCP Server

Compare all alternatives →

MCP Toolbox for Databases (BigQuery)

Databases

16k

Google's official MCP server with prebuilt BigQuery tools, querying datasets via Application Default Credentials.

Verified

stdio (local)

OAuth

10 tools

Updated 15 days agoRepo

Postgres MCP Pro

Databases

2.9k

Read/write Postgres access plus index tuning, EXPLAIN plans, and database health analysis for AI agents.

Verified

stdio (local)

API key

Python

9 tools

Updated 3 months agoRepo

Supabase MCP Server

Databases

2.7k

Official Supabase server: manage tables, run SQL, branches, configs and edge functions from your AI client.

Verified

HTTP (remote)

OAuth

TypeScript

12 tools

Updated 1 month agoRepo

Compare MySQL MCP Server with:

vs MCP Toolbox for Databases (BigQuery)vs Postgres MCP Pro vs Supabase MCP Server vs Neon MCP Server