Skip to content
cccskills
Official · MicrosoftFreePublished on GitHub

analyze-performance

Review a local, non-SPA Power Pages codebase for performance patterns such as unbounded queries, inefficient FetchXML, caching settings, blocking scripts, and large assets. Get severity-ranked findings, code-aware suggestions, an HTML report, and optional fixes that require approval.

OriginalShow the original description

Statically scans the entire local Power Pages codebase for performance anti-patterns — unpaginated Power Pages lists, webpages/web templates used as custom data APIs, FetchXML over-fetching / N+1 / advanced query hints / cache bypassing, unbounded Web API queries, disabled header/footer output caching, sign-in and page tracking, main-thread-blocking JS, CSS @import, frequent Web API polling, and oversized assets — then enriches findings with AI-driven suggestions and mitigations grounded in the affected customer-code snippets, reports them, and offers safe auto-fixes with per-fix approval. Use when the user wants to: "check performance", "perf check", "find performance issues", "why is my site slow", "optimize my Power Pages site", "find anti-patterns", "review FetchXML performance", "is my site over-fetching data", or "audit site performance".

microsoft/power-platform-skills1,078 stars(GitHub 1,078 + cccskills 0)

Run score Not tested

See how to install

Good for

  • Auditing a Power Pages project for performance issues
  • Finding inefficient FetchXML or Web API queries
  • Reviewing caching, scripts, and oversized assets
  • Getting approved fixes and a performance report

Files included (4)

  • SKILL.md20.2 KB
  • references/performance-reference.md22.8 KB
  • scripts/analyze-performance.js67.5 KB
  • scripts/validate-analyze-performance.js2.5 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Plugin check: Run node "${PLUGIN_ROOT}/scripts/check-version.js" — if it outputs a message, show it to the user before proceeding.

analyze-performance

Statically analyzes the entire local Power Pages codebase for known performance anti-patterns, enriches the static findings with AI-driven, code-aware suggestions and mitigations, presents them by severity in an HTML report + plain-language summary, and offers safe auto-fixes with per-fix approval. Never applies a fix without explicit consent.

This skill reads local source only — it does not call the deployed site. For a live security/vulnerability scan use /scan-site.

Initial request: $ARGUMENTS

Prerequisites

  • An existing local non-SPA Power Pages project or PAC CLI site download. .powerpages-site/, root-level .portalconfig/, website.yml, and portal content folders are useful discovery markers, but they are not all required when the user supplies an existing site folder.
  • SPA websites are not supported yet. powerpages.config.json is the authoritative local SPA marker; if it exists at the selected project root, tell the user this skill currently supports non-SPA websites only and stop.
  • Node.js (bundled scripts run under node).

No sign-in, PAC CLI, or Azure CLI is required — the analysis is fully offline.

What it detects

See references/performance-reference.md for the authoritative rule catalog (tags, severities, detection, fixes, thresholds, and Microsoft Learn sources). The scan must cover all of these categories:

  • List pagination — Power Pages list definitions with no positive adx_pagesize / pagesize.
  • Webpages used as APIs — FetchXML/entity-backed web templates or webpage content that emit JSON/XML instead of a normal HTML page.
  • FetchXML anti-patterns — all-attributes, no explicit columns, too many columns, no paging, oversized count/top, N+1 queries inside Liquid loops, unnecessary returntotalrecordcount, leading-wildcard like filters, and related-table ordering.
  • FetchXML query controls — advanced query hints (options, latematerialize, no-lock, useraworderby, filter hint) and request-time values or explicit settings that bypass server-side query caching.
  • Web API anti-patterns — $select=*, missing $select, no page bound ($top safety cap or Prefer: odata.maxpagesize=N cursor paging), too many selected columns, oversized $top, $count=true, $expand without a nested $select, contains/endswith filters, request-time date filters, related-table ordering, request-per-item/N+1 loops, and short-interval polling.
  • Rendering and caching — disabled Header/Footer output caching, render-blocking <head> scripts, runtime CSS @import, synchronous XHR/jQuery, and document.write.
  • Tracking and volume — sign-in/page/file tracking, excessive web-file or web-role counts, and oversized static assets.

Phases

  1. Prerequisites — locate the project, confirm the site exists, detect review mode 1.5. Ground in current performance guidance — optional Microsoft Learn cross-check (capped, offline-safe)
  2. Scan — run the deterministic analyzer over the codebase 2.5. AI mitigation pass — inspect customer-code snippets behind each finding and add code-aware suggestions/mitigations
  3. Present findings — severity table + coverage stats + AI suggestions
  4. Offer auto-fixes — per-finding consent loop for the safely-automatable findings
  5. Verify — re-run the analyzer to confirm fixes resolved their findings
  6. Report & next action — render the HTML report, summarize, and route follow-ups

Task Tracking

Create tasks in three groups. Mark each in_progress when starting, completed when done.

GroupWhen to createTasks
1At startVerify prerequisites and locate project
2After prerequisites passScan codebase for anti-patterns · Add AI-driven suggestions and mitigations · Present findings
3After findings presented (skip all three in review mode)Offer auto-fixes (only if any autoFixAvailable) · Verify fixes · Render report and route follow-ups

Phase 1 — Verify Prerequisites and Locate Project

  1. Detect review mode first: if $ARGUMENTS contains --review <out-dir>, remember <REVIEW_DIR>.
  2. Resolve <PROJECT_ROOT> in this order:
    • If <REVIEW_DIR> itself contains recognizable Power Pages source, use it as both <PROJECT_ROOT> and <REVIEW_DIR>. This supports orchestrated reviews that pass the downloaded site folder directly.
    • Otherwise use an explicitly supplied project directory, then the current working directory. Use Glob to locate **/powerpages.config.json, **/.powerpages-site, **/.portalconfig, or **/website.yml when needed.
  3. Treat any of these as recognizable Power Pages source: .powerpages-site/, root-level .portalconfig/, website.yml, or a characteristic portal export layout containing folders such as web-pages/, web-templates/, or web-files/. Do not reject an explicitly supplied existing site folder merely because it lacks .powerpages-site/.
  4. If <PROJECT_ROOT>/powerpages.config.json exists, tell the user that the selected path is a SPA website and this skill currently supports non-SPA Power Pages websites only, then stop.
  5. If no existing directory with recognizable non-SPA Power Pages source can be located, tell the user and recommend /create-site, then stop.
  6. In review mode Phases 3, 4, and 6-presentation are skipped: Phase 2 runs, Step 6.2 writes JSON only, and the skill stops after writing it.

Report: "Found project: <PROJECT_ROOT>. Scanning for performance anti-patterns."

Phase 1.5 — Ground in current performance guidance

Skip in review mode. Cap this step at ~30 seconds. If MCP search / fetch errors out or is unavailable, log a one-line note and continue — this skill must remain runnable offline.

  1. Run microsoft_docs_search with the query: Power Pages Site Checker performance FetchXML output caching best practices.
  2. Optionally microsoft_docs_fetch https://learn.microsoft.com/en-us/power-pages/admin/site-checker-performance.
  3. Extract a one-paragraph summary of what Microsoft Learn currently says. Compare it against the rule catalog in references/performance-reference.md. If Learn documents a performance pattern not covered by any analyzer rule, surface it to the user in Phase 6 as a manual follow-up — do not silently invent findings the analyzer did not produce.

Phase 2 — Scan the codebase

Run the deterministic analyzer over the whole project:

node "${PLUGIN_ROOT}/skills/analyze-performance/scripts/analyze-performance.js" --projectRoot "<PROJECT_ROOT>"

The analyzer prints a single JSON object { status, findings, details, severityCounts } to stdout. Parse it. Each finding has id, tag, severity, title, location, details, fix, autoFixAvailable, and (when auto-fixable) fixAction. See references/performance-reference.md for the finding envelope and every tag's meaning.

If the only finding is PERF-NONE, the codebase is clean — note this and skip Phase 4/5 (still render the report in Phase 6 so the user has a record).

Phase 2.5 — Add AI-driven suggestions and mitigations

Run this after every deterministic scan result that will be presented or written to analyze-performance.json (including review mode). Skip only PERF-NONE.

For each finding, inspect the relevant customer-code context before writing the final JSON:

  1. Read the file named by finding.location and capture a tight snippet around the line (about 20 lines before/after, capped so the report stays readable). If the file no longer exists or the finding has no location, use the finding's details and fix only.
  2. Add these fields to the finding object:
    • aiSuggestion: one or two sentences explaining the best next change for this specific code path, grounded in the snippet and the rule catalog.
    • mitigation: a concrete mitigation plan that preserves behavior. Name the likely code/config edit, the safer alternative when there are tradeoffs, and anything the user must verify manually.
  3. Keep the deterministic fields (tag, severity, fix, fixAction, autoFixAvailable) unchanged. Do not downgrade, suppress, or invent analyzer findings during this AI pass.
  4. For heuristic findings (for example webpage-as-API, Web API N+1, cache bypassing, related-column ordering), say that the suggestion is conditional and name the observation that would confirm it.
  5. For auto-fixable site-setting/tracking findings, keep mitigation aligned with the existing fixAction and repeat any important caveat, especially the Header/Footer output-cache substitution requirement.

The report renderer displays aiSuggestion and mitigation as separate fields, so write them into the JSON rather than only mentioning them in chat. If the current AI context cannot safely inspect a file because it is restricted or too large, add a conservative mitigation based on details/fix and explicitly say the source snippet was not inspected.

Phase 3 — Present findings

Skip in review mode (go straight to Step 5.1's JSON write).

Present all findings grouped by severity, highest first. Include the AI suggestion and mitigation under each row (or immediately after the table for long items) so the user sees both the static check and the code-aware recommendation:

#SeverityTagIssueLocationAuto-fix?
1highPERF-FETCHXML-ALLATTRFetchXML retrieves all attributes...:2No
2warningPERF-HEADER-OUTPUTCACHEHeader output caching disabled...sitesetting.ymlYes

Then show the coverage stats from details.entries (FetchXML/Liquid, list, Web API/script and CSS files scanned; web-file/web-role counts; total findings). Keep the language plain; explain a tag only when asked. Make clear that AI suggestions are grounded in the local snippet but still require developer judgment for business-specific behavior.

Phase 4 — Offer auto-fixes

Skip in review mode. Skip entirely if no finding has autoFixAvailable: true.

Only the site-setting and tracking findings are safely automatable (PERF-HEADER-OUTPUTCACHE, PERF-FOOTER-OUTPUTCACHE, PERF-SIGNIN-TRACKING, PERF-WEBPAGE-TRACKING, PERF-WEBFILE-TRACKING). List pagination, webpage-as-API, FetchXML, Web API, query-hint, cache-bypass, and asset findings require human judgment — present those as manual fixes only.

For each finding with autoFixAvailable: true, in order:

<!-- gate: analyze-performance:4.auto-fix | category=consent | cancel-leaves=nothing -->

🚦 Gate (consent · analyze-performance:4.auto-fix): Per-finding consent before applying any auto-fix. Loops once per autoFixAvailable finding — each gets its own Yes / No / Skip-all AskUserQuestion naming the finding's tag and the exact change. Never batch fixes — three fixable findings = three separate prompts (unless the user picks "Skip all", which short-circuits the loop). Each fix has its own blast radius (a different site setting or YAML file), so approving one does not approve the next.

Trigger: Phase 4, once per fixable finding. Why we ask: Enabling output caching alone can break header/footer rendering unless the web templates also use {% substitution %} (see caveat below); toggling tracking edits committed YAML. The user must consent to each concrete change. Cancel leaves: Nothing — declining a fix leaves that finding untouched and reported as manual.

For the approved finding, apply its fixAction:

  • create-site-setting (setting is absent from a per-record .powerpages-site layout): create it with the shared helper —
    node "${PLUGIN_ROOT}/scripts/create-site-setting.js" --projectRoot "<PROJECT_ROOT>" --name "<fixAction.name>" --value "<fixAction.value>" --type boolean --description "<short why>"
    
    If it reports the setting already exists, treat it as already handled and switch to the set-site-setting path.
  • set-site-setting (setting exists but is wrong): use Edit on the finding's location file to flip the value: line (false → true, or tracking true → false). Do not call create-site-setting.js — it refuses to overwrite.
  • set-yaml-field: use Edit at the finding's precise location to set <fixAction.field>: <fixAction.value> (e.g., adx_enabletracking: false). For a non-SPA aggregate sitesetting.yml, fixAction.recordName identifies the setting record and the location points at its exact adx_value line. Do not replace another record's matching boolean.

Output-cache caveat (always surface this): enabling Header/Footer/OutputCache/Enabled is not sufficient on its own — the Header, Footer, and Languages-Dropdown web templates must also use the {% substitution %} Liquid tag, or those regions stop rendering. After applying an output-cache fix, tell the user to update those templates and verify the site still renders.

Mark each finding Fixed, Skipped, or Manual required as you go.

Phase 5 — Verify fixes

Skip in review mode. Skip if no auto-fix was applied.

Re-run the analyzer to confirm the applied fixes resolved their findings:

node "${PLUGIN_ROOT}/skills/analyze-performance/scripts/analyze-performance.js" --projectRoot "<PROJECT_ROOT>"

Confirm each fixed finding's tag/location is gone (or downgraded from warning to info for the absent→present caching case). If a fix did not take, report it and offer to retry or hand it to the user. Use this re-scanned result set as the basis for the Phase 6 report so it reflects the post-fix state.

Phase 6 — Report & next action

6.1 Review mode short-circuit

Handled at Step 6.2 below — review mode never reaches the HTML render or the follow-up walk-through.

Step 6.2 — Write the review JSON

Write the enriched { status, findings, details } object (the Phase 5 re-scan result if a re-scan ran, otherwise the Phase 2 result, with Phase 2.5 aiSuggestion/mitigation fields applied) to a JSON file:

  • Review mode: write to <REVIEW_DIR>/analyze-performance.json, then stop. The orchestrating skill (e.g., security-review) handles presentation.
  • Interactive mode: write to <TEMP_DIR>/analyze-performance.json where <TEMP_DIR> is a scratch directory containing only this file.

The filename must be analyze-performance.json — that is the key build-review-data.js maps to the Performance section.

Step 6.3 — Render the HTML report

Skip in review mode. Reuse the shared report pipeline (same template as the security review and site scan):

The final HTML report is a persistent website artifact under <PROJECT_ROOT>/docs/, consistent with the other review reports. Only analyze-performance.json and data.json are temporary scratch files; delete their temporary directory after the HTML render succeeds.

node "${PLUGIN_ROOT}/scripts/build-review-data.js" \
  --reportName "Performance Analysis" \
  --inputDir "<TEMP_DIR>" \
  --siteName "<SITE_NAME>" \
  --goalLabel "Performance" \
  --scopeLabel "Local codebase" \
  --summary "<SUMMARY_TEXT>" \
  --output "<TEMP_DIR>/data.json"

node "${PLUGIN_ROOT}/scripts/render-review.js" \
  --data "<TEMP_DIR>/data.json" \
  --output "<PROJECT_ROOT>/docs/performance-analysis-<YYYY-MM-DD-HHMMSS>.html"

node "${PLUGIN_ROOT}/skills/analyze-performance/scripts/validate-analyze-performance.js" \
  --reportPath "<PROJECT_ROOT>/docs/performance-analysis-<YYYY-MM-DD-HHMMSS>.html"

<SITE_NAME> comes from the site's website.yml; fall back to the folder name. The filename must include the local timestamp (e.g., performance-analysis-2026-05-14-053805.html). Delete <TEMP_DIR> after the render and explicit validation succeed, then open the report in the browser.

Step 6.4 — Summarize and route follow-ups

<!-- gate: analyze-performance:6.next-action | category=plan | cancel-leaves=nothing -->

🚦 Gate (plan · analyze-performance:6.next-action): After the report, recommend the single most useful next step and let the user accept or choose differently via AskUserQuestion — walk through the manual (non-auto-fixable) findings one at a time, re-scan, or finish. Reviewing findings and re-scanning are read-only; nothing is changed without a later Phase 4 consent.

Trigger: Phase 6, after the report is rendered (interactive mode only). Why we ask: The manual list, webpage-as-API, FetchXML, Web API, query-hint, cache-bypass, and asset fixes need edits the user must drive; auto-walking every finding would be noisy if they only wanted the report. Cancel leaves: Nothing — the report is already written; declining ends the skill cleanly.

Give a plain-language summary: total findings, count by severity, and how many were auto-fixed. For manual findings (list pagination, webpage-as-API patterns, FetchXML/Web API anti-patterns, query hints, cache bypassing, volume counts, and large assets), offer to walk through them one at a time with the concrete edit each needs. If nothing meaningful remains, end the skill — do not ask just to ask.

Record Skill Usage

Reference: ${PLUGIN_ROOT}/references/skill-tracking-reference.md

Use --skillName "AnalyzePerformance".

Constraints

  • Read-only until consent. The analyzer never mutates anything. The only writes are the HTML report, the scratch JSON, and auto-fixes the user explicitly approves in Phase 4.
  • High-signal findings. Heuristics (Web API N+1, missing-but-defaultable caching) are intentionally conservative to avoid false positives. When a finding is a heuristic, say so.
  • Plain language. Explain a tag only when asked; lead with the impact, not the internal name.
  • Offline-safe. Phase 1.5 is best-effort; the skill must complete with no network access.

References

  • references/performance-reference.md — authoritative rule catalog: tags, severities, detection logic, fixes, auto-fix actions, thresholds, manual-only checks, key nuances, and Microsoft Learn sources. Read when explaining a finding or deciding whether a fix is safe.

Progress Tracking Table

Task subjectactiveFormDescription
Verify prerequisites and locate projectVerifying prerequisitesLocate an explicit/current code-site or PAC-download folder, confirm recognizable Power Pages source, detect review mode
Scan codebase for anti-patternsScanning codebaseRun analyze-performance.js over the project, parse findings JSON
Present findingsPresenting findingsShow severity table and coverage stats
Offer auto-fixesApplying auto-fixesPer-finding consent loop; apply site-setting/tracking fixes, surface substitution caveat
Verify fixesVerifying fixesRe-run analyzer, confirm fixed findings are gone
Render report and route follow-upsRendering reportBuild review JSON, render HTML, summarize, route manual follow-ups

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

activate-site

Official · MicrosoftFreeSummary

Provision an existing Power Pages site in a Power Platform environment through the Power Platform REST API. The skill checks CLI authentication, gathers the site and subdomain details, asks for approval before activation, and reports the provisioning status and resulting site URL.

  • Provision an existing Power Pages site
  • Choose a subdomain for a new site URL
  • Check the result of site activation
microsoft/power-platform-skills1.1KUpdated Oct 29, 2026

add-ai-webapi

Official · MicrosoftFreeSummary

Add Power Pages preview APIs that generate summaries of Dataverse records, lists, or search results to a custom SPA interface. The skill creates the service code and AI settings needed to show summaries and recommendations on selected pages.

  • Show AI summaries on a record detail page
  • Summarize results in a custom search interface
  • Add key insights for a Dataverse list
microsoft/power-platform-skills1.1KUpdated Oct 29, 2026

add-azuredevops

Official · MicrosoftFreeSummary

Connects Azure DevOps to a Power Apps code app for work item queries, bug creation, pipeline operations, and other REST API calls. It applies a required fix to the generated HttpRequest method and helps locate service methods for the requested operations.

  • Query Azure DevOps work items from an app
  • Create bugs or trigger pipeline operations
  • Make a custom Azure DevOps REST API call
microsoft/power-platform-skills1.1KUpdated Oct 29, 2026

add-camera

Official · MicrosoftFreeSummary

An internal helper for `/add-native` that creates typed camera and gallery wrappers, an optional barcode or QR scanner, and, when explicitly requested, a custom Dataverse Image upload helper. It writes JavaScript files under `src/native/` and checks that required modules already exist.

  • Adding a camera capture wrapper to a Power Apps app
  • Creating a gallery image picker flow
  • Adding barcode or QR scanning
microsoft/power-platform-skills1.1KUpdated Oct 29, 2026

add-cloud-flow

Official · MicrosoftFreeSummary

Connect Power Automate cloud flows to a Power Pages site. Find flows that can run from Power Pages, match them to site needs, plan web roles, create metadata for new registrations, and generate client-side code to call new or already-registered flows from pages.

  • Finding a flow that matches a site feature
  • Registering a new cloud flow with web roles
  • Adding an existing flow to another page
microsoft/power-platform-skills1.1KUpdated Oct 29, 2026

add-connector

Official · MicrosoftFreeSummary

Add a Power Platform connector to an Expo or React Native Power Apps mobile app when no dedicated connector skill covers it. The workflow resolves connection and data choices, generates connector services and schemas, and checks TypeScript integration.

  • Add a connector without a dedicated skill
  • Connect an app to a selected table or dataset
  • Add a SQL stored procedure as a data source
microsoft/power-platform-skills1.1KUpdated Oct 29, 2026

See all skills by microsoft

Report a problem with this skill