polardb-mysql-mcp-server 0.7.0

MCP server for polardb mysql

PolarDB MySQL MCP Server

PolarDB MySQL MCP Server serves as a universal interface between AI Agents and PolarDB MySQL databases. It enables seamless communication between AI Agents and PolarDB MySQL, helping AI Agents retrieve PolarDB MySQL database metadata and execute SQL operations.

Environment Variables

The following environment variables are required to connect to PolarDB MySQL database,environment Variables can be set in .env file or set in command line

• POLARDB_MYSQL_HOST: Database host address
• POLARDB_MYSQL_PORT: Database port
• POLARDB_MYSQL_USER: Database user
• POLARDB_MYSQL_PASSWORD: Database password
• POLARDB_MYSQL_DATABASE: Database name
• POLARDB_MYSQL_ENABLE_UPDATE: Enable update operation(default:false)
• POLARDB_MYSQL_ENABLE_WRITE: Enable write operation(default:false)
• POLARDB_MYSQL_ENABLE_INSERT: Enable insert operation(default:false)
• POLARDB_MYSQL_ENABLE_DDL: Enable ddl operation(default:false)
• SSE_BIND_HOST: The host address to bind for SSE mode
• SSE_BIND_PORT: The port to bind for SSE mode
• RUN_MODE: The run mode(sse|stdio),(default:sse)

Components

Tools

• execute_sql: 执行符合PolarDB MySQL语法的SQL语句
• polar4ai_update_index_for_text_2_sql: 利用polardb的AI节点,对当前库的表建索引，用于文本转SQL或者文本转chart
• polar4ai_text_2_sql:利用polardb的AI节点,将用户的文本转换成sql语句
• polar4ai_text_2_chart:利用polardb的AI节点,将用户的文本统计需求直接转换成图表
• polar4ai_create_models:使用polar4ai语法，创建各种自定义算法模型
• polar4ai_import_doc:利用polardb的AI节点,将用户本地目录的文档导入到PolarDB中形成知识库
• polar4ai_search_doc:利用polardb的AI节点,从PolarDB中的知识库中搜索用户问题并返回答案

Resources

• polardb-mysql://tables: 列出当前数据库中所有的表
• polardb-mysql://models: 列出当前数据库中创建的所有自定义算法模型

Resource Templates

• polardb-mysql://{table}/field: 获取到表中字段的名称、类型和注释
• polardb-mysql://{table}/data: 从表中获取数据，默认获取50条数据

Cursor

1. config for mcp.json

{
  "mcpServers": {
    "polardb-mysql-mcp-server": {
      "command": "uvx",
      "args": [
        "--from",
        "polardb-mysql-mcp-server",
        "run_polardb_mysql_mcp_server"
      ],
      "env": {
        "POLARDB_MYSQL_HOST": "127.0.0.1",
        "POLARDB_MYSQL_PORT": "15001",
        "POLARDB_MYSQL_USER": "xxxx",
        "POLARDB_MYSQL_PASSWORD": "xxx",
        "POLARDB_MYSQL_DATABASE": "xxx",
        "RUN_MODE": "stdio",
        "POLARDB_MYSQL_ENABLE_UPDATE": "false",
        "POLARDB_MYSQL_ENABLE_UPDATE": "false",
        "POLARDB_MYSQL_ENABLE_INSERT": "false",
        "POLARDB_MYSQL_ENABLE_DDL": "false"
      }
    }
  }
}