About

Imported from mastra-ai/mastra (templates/template-github-review-agent/workspace/skills/performance-review/SKILL.md). Install upstream with npx skills add mastra-ai/mastra --skill performance-review. Copyright stays with the author.

Performance Review

Name: performance-review
Author: mastra-ai

When reviewing code for performance issues, check each category below. Reference the detailed checklist in references/performance-checklist.md.

Database & Queries

N+1 query patterns (queries inside loops)
Missing database indexes for frequently queried fields
Unbounded queries without LIMIT/pagination
SELECT * instead of selecting only needed columns
Missing connection pooling

Memory & Resources

Memory leaks: event listeners not removed, intervals not cleared, growing caches without bounds
Large objects held in memory unnecessarily
Unbounded arrays or maps that grow with usage
Missing cleanup in component unmount/destroy lifecycle

Rendering (Frontend)

Unnecessary re-renders (missing React.memo, useMemo, useCallback where appropriate)
Large component trees re-rendering for small state changes
Missing virtualization for long lists
Synchronous heavy computation blocking the main thread
Large bundle sizes from unnecessary imports

API & Network

Missing caching for frequently accessed, rarely changing data
Sequential API calls that could be parallelized
Missing pagination for large data sets
Over-fetching data (requesting more than needed)
Missing request deduplication

Algorithmic Complexity

O(n²) or worse operations on potentially large datasets
Repeated computation that could be memoized
String concatenation in loops (use array join or template literals)
Unnecessary sorting or filtering passes

Severity Levels

🔴 CRITICAL: Will cause performance degradation under normal load
🟠 HIGH: Will cause issues at scale
🟡 MEDIUM: Optimization opportunity with measurable impact
🔵 LOW: Minor optimization suggestion

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/mastra-ai-mastra-performance-review/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

mastra-ai-mastra-performance-review.ocm.jsonjson

{
  "ocm": "1",
  "id": "mastra-ai-mastra-performance-review",
  "kind": "skill",
  "name": "performance-review",
  "description": "Performance-focused code review for identifying bottlenecks and optimization opportunities",
  "publisher": "mastra-ai",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "coding",
      "hr"
    ],
    "tags": [
      "skill-md",
      "code-review",
      "performance",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Performance-focused code review for identifying bottlenecks and optimization opportunities"
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/mastra-ai/mastra",
      "path": "templates/template-github-review-agent/workspace/skills/performance-review/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/mastra-ai/mastra/blob/HEAD/templates/template-github-review-agent/workspace/skills/performance-review/SKILL.md",
      "key": "mastra-ai/mastra/templates/template-github-review-agent/workspace/skills/performance-review/SKILL.md"
    }
  },
  "instructions": "# Performance Review\n\nWhen reviewing code for performance issues, check each category below. Reference the detailed checklist in `references/performance-checklist.md`.\n\n## Database & Queries\n\n- N+1 query patterns (queries inside loops)\n- Missing database indexes for frequently queried fields\n- Unbounded queries without LIMIT/pagination\n- SELECT \\* instead of selecting only needed columns\n- Missing connection pooling\n\n## Memory & Resources\n\n- Memory leaks: event listeners not removed, intervals not cleared, growing caches without bounds\n- Large objects held in memory unnecessarily\n- Unbounded a",
  "cost": {
    "context_tokens": 437
  }
}

Fetch it by URL: GET /api/v1/registry/mastra-ai-mastra-performance-review/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.