MySQL Database Access is an MCP server that provides secure, read-only access to MySQL databases for exploration and querying without risk of data modification. Key features: - Browse database structure by listing databases and tables - Inspect table schemas with detailed column information - Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN statements only) - Query validation to prevent SQL injection attacks - Configurable query timeouts to prevent resource exhaustion - Row limits to control data return volumes - Environment variable configuration for host, port, credentials, and default database

[](https://www.npmjs.com/package/mysql-mcp-server) [](https://smithery.ai/server/@dpflucas/mysql-mcp-server)

MySQL Database Access MCP Server

This MCP server provides read-only access to MySQL databases. It allows you to:

Security Features

Installation

1. Install using one of these methods:

#### Install from NPM

# Install globally
npm install -g mysql-mcp-server
Or install locally in your project
npm install mysql-mcp-server

#### Build from Source

# Clone the repository
git clone https://github.com/dpflucas/mysql-mcp-server.git
cd mysql-mcp-server
Install dependencies and build
npm install
npm run build

#### Install via Smithery

To install MySQL Database Access MCP Server for Claude AI automatically via Smithery:

npx -y @smithery/cli install @dpflucas/mysql-mcp-server --client claude

2. Configure environment variables

The server requires the following environment variables:

3. Add to MCP settings

Add the following configuration to your MCP settings file:

If you installed via npm (Option 1):

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["mysql-mcp-server"],
      "env": {
        "MYSQL_HOST": "your-mysql-host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your-mysql-user",
        "MYSQL_PASSWORD": "your-mysql-password",
        "MYSQL_DATABASE": "your-default-database"
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

If you built from source (Option 2):

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": ["/path/to/mysql-mcp-server/build/index.js"],
      "env": {
        "MYSQL_HOST": "your-mysql-host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your-mysql-user",
        "MYSQL_PASSWORD": "your-mysql-password",
        "MYSQL_DATABASE": "your-default-database"
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

Available Tools

list_databases

Lists all accessible databases on the MySQL server.

Parameters: None

Example:

{
  "server_name": "mysql",
  "tool_name": "list_databases",
  "arguments": {}
}

list_tables

Lists all tables in a specified database.

Parameters:

Example:

{
  "server_name": "mysql",
  "tool_name": "list_tables",
  "arguments": {
    "database": "my_database"
  }
}

describe_table

Shows the schema for a specific table.

Parameters:

Example:

{
  "server_name": "mysql",
  "tool_name": "describe_table",
  "arguments": {
    "database": "my_database",
    "table": "my_table"
  }
}

execute_query

Executes a read-only SQL query.

Parameters:

Example:

{
  "server_name": "mysql",
  "tool_name": "execute_query",
  "arguments": {
    "database": "my_database",
    "query": "SELECT * FROM my_table LIMIT 10"
  }
}

Advanced Connection Pool Configuration

For more control over the MySQL connection pool behavior, you can configure additional parameters:

```json { "mcpServers": { "mysql": { "command": "npx", "args": ["mysql-mcp-server"], "env": { "MYSQL_HOST": "your-mysql-host", "MYSQL_PORT": "3306", "MYSQL_USER": "your-mysql-user", "MYSQL_PASSWORD": "your-mysql-password", "MYSQL_DATABASE": "your-default-database", "MYSQL_CONNECTION_LIMIT": "10", "MYSQL_QUEUE_LIMIT": "0", "MYSQL_CONNECT_TIMEOUT": "10000", "MYSQL_IDLE_TIMEOUT": "60000", "MYSQL_MAX_IDLE": "10"