Skip to main content
Glama
Sign In
MCP Server MySQL

MCP Server MySQL

by nilsir
OverviewSchemaSourceRelated ServersDiscussionsAdmin
JavaScript
Hybrid

MCP Server MySQL

A Model Context Protocol (MCP) server that provides MySQL database operations. This server enables LLMs to interact with MySQL databases through a standardized protocol.

Features

  • Database Management: Create, drop, list, and switch databases

  • Table Operations: Create, alter, drop, describe, and list tables

  • Data Queries: Execute SELECT queries and retrieve results

  • Data Modification: Execute INSERT, UPDATE, DELETE statements

  • Index Management: Create and drop indexes

Related MCP server: MySQL MCP Server

Installation

npm install
npm run build

Configuration

Set environment variables for database connection:

export MYSQL_HOST=localhost
export MYSQL_PORT=3306
export MYSQL_USER=root
export MYSQL_PASSWORD=your-password
export MYSQL_DATABASE=your-database  # optional

Safety and Permission Controls

The server defaults to read-only mode. Enable write or schema operations explicitly:

export MYSQL_MODE=readonly       # readonly | data-write | schema-write | admin
export MYSQL_ALLOW_DDL=false     # Set to "true" to enable schema/admin tools
export MYSQL_MAX_ROWS=100        # Optional cap for query result rows

Legacy data-write controls are still supported and are enforced when MYSQL_MODE allows data writes:

export MYSQL_ALLOW_INSERT=true   # Set to "false" to disable INSERT
export MYSQL_ALLOW_UPDATE=true   # Set to "false" to disable UPDATE
export MYSQL_ALLOW_DELETE=false  # Set to "false" to disable DELETE

Or use the connect tool at runtime to specify connection parameters.

High-risk DDL tools require a confirm parameter that matches the target name:

  • alter_table: confirm must match the table name

  • drop_table: confirm must match the table name

  • drop_database: confirm must match the database name

  • drop_index: confirm must match the index name

For AI-assisted development, prefer least-privilege MySQL users. Use a read-only database account for exploration and enable MYSQL_MODE=data-write, MYSQL_MODE=schema-write, or MYSQL_MODE=admin only for trusted workflows.

Supported AI Applications

This MCP server can be used with any application that supports the Model Context Protocol (MCP):

  • Claude Desktop - Anthropic's official desktop application

  • Claude Code - Anthropic's official CLI tool for developers

  • Cline - AI coding assistant VS Code extension

  • Zed - High-performance code editor with built-in AI

  • Any MCP-compatible application - MCP is an open protocol developed by Anthropic

Usage with Claude Desktop

Using npx (Recommended)

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@nilsir/mcp-server-mysql"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_DATABASE": "your-database",
        "MYSQL_MODE": "readonly",
        "MYSQL_ALLOW_DDL": "false",
        "MYSQL_ALLOW_INSERT": "true",
        "MYSQL_ALLOW_UPDATE": "true",
        "MYSQL_ALLOW_DELETE": "false",
        "MYSQL_MAX_ROWS": "100"
      }
    }
  }
}

Using Local Installation

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": ["/absolute/path/to/mcp-server-mysql/dist/index.js"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_DATABASE": "your-database",
        "MYSQL_MODE": "readonly",
        "MYSQL_ALLOW_DDL": "false",
        "MYSQL_ALLOW_INSERT": "true",
        "MYSQL_ALLOW_UPDATE": "true",
        "MYSQL_ALLOW_DELETE": "false",
        "MYSQL_MAX_ROWS": "100"
      }
    }
  }
}

Available Tools

Tool

Description

connect

Connect to a MySQL database

query

Execute SELECT queries

explain_query

Run EXPLAIN for a single SELECT query

execute

Execute INSERT/UPDATE/DELETE queries when policy allows

dry_run_execute

Execute INSERT/UPDATE/DELETE in a transaction and roll it back

list_databases

List all databases

list_tables

List tables in a database

describe_table

Get table structure

inspect_schema

Inspect tables, columns, and indexes for AI context

find_tables

Find tables by table or column name

sample_rows

Read a capped sample of rows from a table

create_table

Create a new table

alter_table

Modify table structure

drop_table

Drop a table

create_database

Create a new database

drop_database

Drop a database

use_database

Switch to a database

create_index

Create an index

drop_index

Drop an index

Examples

Query data

Use the query tool with sql: "SELECT * FROM users WHERE active = ?"
and params: [true]

Analyze a SELECT query plan

Use the explain_query tool with:
- sql: "SELECT * FROM users WHERE email = ?"
- params: ["user@example.com"]
- format: "traditional"

explain_query only accepts one SELECT statement. Use format: "json" when an AI-readable JSON plan is more useful.

Create a table

Use the create_table tool with:
- table: "users"
- columns: [
    {"name": "id", "type": "INT", "primaryKey": true, "autoIncrement": true},
    {"name": "email", "type": "VARCHAR(255)", "nullable": false},
    {"name": "created_at", "type": "TIMESTAMP", "default": "CURRENT_TIMESTAMP"}
  ]

Inspect schema for AI context

Use the inspect_schema tool with:
- database: "nilsir"
- includeColumns: true
- includeIndexes: true

Find likely tables or columns

Use the find_tables tool with:
- database: "nilsir"
- term: "user"

Sample rows safely

Use the sample_rows tool with:
- database: "nilsir"
- table: "users"
- limit: 5

Sampling is read-only and capped at 50 rows.

Insert data

Use the execute tool with sql: "INSERT INTO users (email) VALUES (?)"
and params: ["user@example.com"]

Requires MYSQL_MODE=data-write or higher.

Dry-run a data change

Use the dry_run_execute tool with sql: "UPDATE users SET active = ? WHERE id = ?"
and params: [false, 123]

The statement runs inside a transaction and is rolled back before returning.

Drop a table

Use the drop_table tool with:
- table: "users"
- confirm: "users"

Requires MYSQL_MODE=schema-write or MYSQL_MODE=admin and MYSQL_ALLOW_DDL=true.

Development

npm install
npm run build
npm test

Integration coverage for dry-run rollback is opt-in because it needs a real test database:

MYSQL_INTEGRATION_TEST=true npm test

License

MIT

Available Tools

15 tools
alter_tableC

Modify an existing table structure

Inputs: table (required), operation (required), column (required), definition, +2 more.

connectA

Connect to a MySQL database. If not called explicitly, will use environment variables for connection.

Inputs: host, port, user, password, +1 more.

create_databaseC

Create a new database

Inputs: database (required), charset, collation.

create_indexC

Create an index on a table

Inputs: table (required), indexName (required), columns (required), unique, +1 more.

create_tableC

Create a new table with specified columns

Inputs: table (required), columns (required), database.

describe_tableC

Get the structure/schema of a table

Inputs: table (required), database.

drop_databaseC

Drop/delete a database

Inputs: database (required).

drop_indexC

Drop an index from a table

Inputs: table (required), indexName (required), database.

drop_tableC

Drop/delete a table

Inputs: table (required), database.

executeB

Execute an INSERT, UPDATE, DELETE or other modifying query. Returns affected rows count.

Inputs: sql (required), params.

health_checkB

Check database connection health and get server status

Inputs: no named parameters.

list_databasesB

List all databases on the MySQL server

Inputs: no named parameters.

list_tablesB

List all tables in the current or specified database

Inputs: database.

queryB

Execute a SELECT query and return results. Use this for reading data.

Inputs: sql (required), params.

use_databaseC

Switch to a different database

Inputs: database (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Deploy Server
    Claude Code, inside the Godot 4 editorFlockbay puts an AI agent in the real Godot 4 editor: it writes GDScript, runs your game and fixes what breaks. Free, or bring your own Claude Code or Codex.flockbay.comAd

    TDQS

    A3.6/5.0

    Scored across 15 tools

    Disambiguation5/5

    Every tool has a clearly distinct purpose with no ambiguity. Each tool targets a specific database operation (e.g., create_table vs. alter_table, query vs. execute) with clear boundaries between read operations, write operations, and administrative tasks.

    Naming Consistency5/5

    Tool names follow a consistent verb_noun pattern throughout (e.g., create_database, list_tables, drop_index). All names use snake_case with descriptive verbs that clearly indicate the action being performed.

    Tool Count5/5

    15 tools is well-scoped for a MySQL database server, covering essential CRUD operations, schema management, and administrative functions. Each tool earns its place without redundancy or bloat.

    Completeness5/5

    The toolset provides complete coverage for MySQL database operations including connection management, database/table lifecycle (create, describe, drop), data manipulation (query, execute), indexing, and administrative functions. No obvious gaps exist for core database workflows.

    Maintenance

    ActivityInactive
    ResponsivenessOutdated data

    Resources

    Related MCP Connectors

    Related MCP Servers

    • MCP-MySQL Server

      enemyrr
      A
      license
      B
      quality
      D
      maintenance
      Enables AI models to perform MySQL database operations through a standardized interface, supporting secure connections, query execution, and comprehensive schema management.
      7
      81 npm
      33
      MIT

    • MySQL MCP Server

      guangxiangdebizi
      A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to securely connect to and manage MySQL databases with support for multiple database connections, complete CRUD operations, schema inspection, and dynamic connection management through natural language.
      31 npm
      81
      MIT

    • MySQL MCP Server

      za2keep
      A
      license
      Not graded
      quality
      Not graded
      maintenance
      Enables AI assistants to securely interact with MySQL databases through tools for query execution, schema inspection, and transaction management. It features built-in safety controls like row limits and query validation to ensure safe and standardized database access.
      896 npm
      -

    • mysql-mcp-tool

      Feixu2015
      A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI models to interact with MySQL databases through MCP protocol, supporting queries, table schema inspection, and data manipulation operations.
      47 npm
      MIT