XMQSVIP/mysql-mcp-xu

3.2

If you are the rightful owner of mysql-mcp-xu and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

MySQL MCP Xu is a MySQL MCP Server project based on FastMCP, providing a secure and efficient interface for executing SQL operations.

Tools

Functions exposed to the LLM to take actions

execute_sql

Executes SQL statements and returns results, automatically adding LIMIT 1000 to SELECT statements without a LIMIT.

get_table_structure

Retrieves field information for a specified table.

get_table_indexes

Retrieves index information for a specified table.

get_mysql_health

Retrieves the health status of MySQL.

get_database_info

Retrieves basic database information.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

XMQSVIP

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/XMQSVIP/mysql-mcp-xu

GitHub Stars

License

MIT License

Last publish date

2025-06-08

Last update date

2025-06-13

Server configs

via uvx

{
  "mcpServers": {
    "mysql-mcp-xu": {
      "command": "uvx",
      "args": [
        "mysql-mcp-xu"
      ],
      "env": {
         "MYSQL_HOST": "", 
         "MYSQL_PORT": "3306",
         "MYSQL_USER": "",
         "MYSQL_PASSWORD": "",
         "MYSQL_DATABASE": "",
         "MYSQL_ROLE": "r",
         "MYSQL_MAXSIZE": "2"
      }
    }
  }
}

via uvx

{
  "mcpServers": {
    "mysql-mcp-xu": {
      "name": "mysql-mcp-xu",
      "type": "streamableHttp",
      "description": "",
      "isActive": true,
      "url": "http://localhost:9009/mcp"
    }
  }
}

via uvx

{
  "mcpServers": {
    "mysql-mcp-xu": {
      "name": "mysql-mcp-xu",
      "description": "",
      "isActive": true,
      "url": "http://localhost:9009/sse"
    }
  }
}