Developer Tools
pqm.guide
Provides documentation and search for Power Query M functions and concepts.
ENDPOINT 1
https://pqm.guide/api/mcp
Known tools 13
get_functionGet complete documentation for a Power Query M function, including syntax, parameters, remarks, and examples.
search_functionsFuzzy-search Power Query M functions by name, description, or common synonyms (including Excel, SQL, and DAX equivalents).
list_categoriesList all Power Query M function categories with their descriptions and function counts.
get_conceptGet a Power Query M concept guide by slug.
list_conceptsList all available Power Query M concept guides.
get_patternGet a practical Power Query M pattern or recipe by slug.
list_patternsList all available Power Query M patterns and recipes, grouped by difficulty.
search_conceptsFuzzy-search Power Query M concept guides by keyword.
search_patternsFuzzy-search Power Query M patterns and recipes by keyword.
get_sample_tableGet sample data used in Power Query M examples on pqm.guide.
format_m_codeFormat Power Query M code using Microsoft's official formatter.
validate_m_codeValidate Power Query M code by parsing it.
list_functions_by_categoryList all Power Query M functions in a specific category.