MCP Server

PQM.guide exposes a Model Context Protocol (MCP) endpoint so AI assistants can query Power Query M documentation directly — no copy-pasting, no context limits.

Endpoint

https://pqm.guide/api/mcp

JSON-RPC 2.0 over HTTP (POST). Implements the Streamable HTTP transport from the MCP 2024-11-05 spec. Stateless — no sessions required.

Connect Claude Desktop

Add this to your claude_desktop_config.json:

{
  "mcpServers": {
    "pqm-guide": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "https://pqm.guide/api/mcp"
      ]
    }
  }
}

Requires mcp-remote: npm install -g mcp-remote

Connect Cursor / Windsurf / Other Clients

Any client supporting Streamable HTTP transport can connect directly:

MCP Server URL: https://pqm.guide/api/mcp
Transport: Streamable HTTP

Available Tools

11 tools covering functions, concepts, patterns, and sample data.

get_function{ "name": "Table.AddColumn" }

Full documentation for a function — syntax, parameters, remarks, and examples.

search_functions{ "query": "merge tables", "limit": 5 }

Fuzzy-search all functions by keyword.

list_categories{}

All 24 function categories with descriptions and counts.

get_concept{ "slug": "query-folding" }

Full content of a concept guide.

list_concepts{}

All concept guides with slugs and descriptions.

search_concepts{ "query": "null handling" }

Fuzzy-search concept guides by keyword.

get_pattern{ "slug": "dynamic-column-selection" }

Full content of a practical M pattern/recipe.

list_patterns{}

All patterns grouped by difficulty.

search_patterns{ "query": "running total" }

Fuzzy-search patterns by keyword.

get_sample_table{ "name": "Sales" }

Sample data table used in examples (Sales, Customers, Products, Employees, OrderLog).

list_functions_by_category{ "category": "list" }

All functions in a given category. Use list_categories first to get valid category slugs.

Test the Endpoint

Send a raw JSON-RPC request with curl:

curl -X POST https://pqm.guide/api/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","method":"tools/call","params":{"name":"get_function","arguments":{"name":"Table.AddColumn"}},"id":1}'

Open Source

The MCP server is part of the open-source PQM.guide codebase. Contributions welcome — view on GitHub.