How do I install the easy mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASSWORD`, `MYSQL_DATABASE`, `MYSQL_LOG_PATH`, `TEST_HOST` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Easy MCP Server

High performance MySQL MCP Server using mysql2

Local serverstdioTypeScript

What is the Easy MCP Server?

High performance MySQL MCP Server using mysql2

What the server does

A lightweight Model Context Protocol (MCP) server that lets AI assistants inspect and query a MySQL database through a safe, structured tool interface.

MySQL connection pooling powered by mysql2/promise
Read-only query tool for data retrieval
Execute tool for data modification statements
Batch execution and CSV import/export helpers
Schema discovery tools for tables, views, indexes, and triggers
Query plan inspection with EXPLAIN

Credentials and setup notes

Node.js 20 or newer - npm - A reachable MySQL-compatible database

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
mysql_manual	Return the built-in manual. Use this first when you are unsure how to use MySQL tools or need help diagnosing an operation error
mysql_query	Execute a SQL query intended for data retrieval, such as SELECT
mysql_execute	Execute a data modification statement, such as INSERT, UPDATE, or DELETE
mysql_schema_execute	Execute schema modification statements in advanced mode, such as CREATE TABLE, ALTER TABLE, CREATE VIEW, CREATE TRIGGER, and CREATE INDEX
mysql_batch_execute	Execute one data modification statement repeatedly with multiple parameter sets
mysql_import_csv	Import a UTF-8 CSV file into a table using the header row as column names
mysql_export_csv	Export all rows from a table to a UTF-8 CSV file
explain_query	Run EXPLAIN for a SQL query and return the execution plan
list_tables	List base tables in the current database, including approximate row counts and comments
list_views	List views in the current database
describe_table	Show column information for one or more tables
describe_index	Show indexes for a table
list_triggers	List triggers in the current database
get_current_privileges	Show the current MySQL user and grants

How to install the Easy MCP Server

{
  "mcpServers": {
    "easy-mysql-mcp": {
      "command": "npx",
      "args": ["-y", "easy-mysql-mcp"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "YOUR USERNAME",
        "MYSQL_PASSWORD": "YOUR PASSWORD",
        "MYSQL_DATABASE": "YOUR DB NAME"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

Node.js 20 or newer - npm - A reachable MySQL-compatible database

Variable	Description	Required
MYSQL_HOST	Endpoint or connection string the server talks to.	Optional
MYSQL_PORT	Configuration value read at startup.	Optional
MYSQL_USER	Configuration value read at startup.	Optional
MYSQL_PASSWORD	Configuration value read at startup.	Optional
MYSQL_DATABASE	Configuration value read at startup.	Optional
MYSQL_LOG_PATH	Filesystem location the server is allowed to use.	Optional
TEST_HOST	Endpoint or connection string the server talks to.	Optional

Example prompts to try

“Use Easy to mysql manual.”
“Use Easy to mysql query.”
“Use Easy to mysql execute.”

Frequently asked questions

High performance MySQL MCP Server using mysql2 Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.