ProxySQL

ProxySQL Configuration

ProxySQL tools allow monitoring and management of ProxySQL proxy instances via the admin interface.

---

Prerequisites

• ProxySQL 2.x+ with admin interface enabled
• Admin interface credentials (default: admin/admin on port 6032)
• Network access to ProxySQL admin port

---

Available Tools (12)

Tool	Description
proxysql_status	Get ProxySQL version, uptime, and runtime stats
proxysql_servers	List configured backend MySQL servers
proxysql_hostgroups	List hostgroup configurations and connection stats
proxysql_query_rules	List query routing rules
proxysql_query_digest	Get query digest statistics (top queries)
proxysql_connection_pool	Get connection pool statistics per server
proxysql_users	List configured MySQL users
proxysql_global_variables	Get global variables (mysql-* and admin-*)
proxysql_runtime_status	Get runtime configuration status
proxysql_memory_stats	Get memory usage metrics
proxysql_commands	Execute LOAD/SAVE admin commands
proxysql_process_list	Get active sessions like SHOW PROCESSLIST

---

Setting Up ProxySQL Admin Access

Default Admin Interface

ProxySQL's admin interface is enabled by default on port 6032. Connect using:

mysql -h127.0.0.1 -P6032 -uadmin -padmin

---

Environment Variables

Variable	Default	Description
PROXYSQL_HOST	localhost	ProxySQL admin interface host
PROXYSQL_PORT	6032	ProxySQL admin port
PROXYSQL_USER	admin	Admin username
PROXYSQL_PASSWORD	admin	Admin password

⚠️ Change default ProxySQL admin credentials in production. Use environment variables or secure secrets management.

---

MCP Configuration

{
  "mcpServers": {
    "mysql-mcp": {
      "command": "node",
      "args": [
        "C:/path/to/mysql-mcp/dist/cli.js",
        "--transport", "stdio",
        "--mysql", "mysql://user:password@localhost:3306/database"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "app_user",
        "MYSQL_PASSWORD": "secure_password",
        "MYSQL_DATABASE": "production",
        "PROXYSQL_HOST": "localhost",
        "PROXYSQL_PORT": "6032",
        "PROXYSQL_USER": "admin",
        "PROXYSQL_PASSWORD": "admin"
      }
    }
  }
}

---

ProxySQL-Only Configuration

If you only want ProxySQL tools:

{
  "args": [
    "--transport", "stdio",
    "--mysql", "mysql://user:password@localhost:3306/database",
    "--tool-filter", "-core,-json,-text,-fulltext,-performance,-optimization,-admin,-monitoring,-backup,-replication,-partitioning,-transactions,-router,-shell"
  ]
}

This exposes only the 12 ProxySQL management tools.

---

See Also

• Tool-Reference - Complete tool list
• Tool-Filtering - Custom tool filtering
• Configuration - General configuration