Skip to content
cccskills
FreePublished on GitHub

performance-review

Review code for performance bottlenecks across database queries, memory use, frontend rendering, network requests, and algorithms. Use a structured checklist to identify optimization opportunities and classify their severity according to expected load and scale.

OriginalShow the original description

Performance-focused code review for identifying bottlenecks and optimization opportunities

mastra-ai/mastra
See how to install

Good for

  • Reviewing database queries for avoidable overhead
  • Checking memory leaks and unbounded resource growth
  • Reviewing React rendering and long-list performance
  • Finding redundant API calls and costly computations

Files included (2)

  • SKILL.md1.9 KB
  • references/performance-checklist.md1.1 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Performance Review

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

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

agent-prompt-quality-bar

FreeSummary

Design and audit an agent's system prompt, the instructions that guide its work. Define a concrete outcome, starting input, available tools, completion checks, fallback behavior, and final report so the prompt describes a complete run.

  • Designing the core instructions for a new agent
  • Auditing a prompt before saving it
  • Defining behavior when tools or permissions are missing
mastra-ai/mastra29KUpdated Oct 22, 2026

builder-smoke-test

FreeSummary

Create a dedicated test project linked to the current worktree and check Agent Builder through APIs and browser interactions. It covers agent and skill management, permissions, defaults, and related features, with selectable test sections.

  • Validate an Agent Builder feature branch before review
  • Check role-based permissions and authentication
  • Test agent and skill management through APIs and the UI
mastra-ai/mastra29KUpdated Oct 22, 2026

code-standards

FreeSummary

Reviews pull requests for bugs, error handling, code quality, and style consistency. Organizes feedback into an overview, must-fix issues with file locations, improvement suggestions, and positive notes so reviewers can distinguish urgent problems from refinements.

  • Finding bugs that must be fixed before merging
  • Reviewing TypeScript types and asynchronous code
  • Checking naming, imports, and leftover debug statements
mastra-ai/mastra29KUpdated Oct 22, 2026

coding-agent

FreeSummary

Design instructions for agents that write, fix, review, or refactor code. Define behavior based on file access, select suitable tools, and set clear verification and completion rules for repository changes or copyable code output.

  • Designing an agent for repository bug fixes
  • Defining a pull request review agent
  • Creating a code generator without workspace access
mastra-ai/mastra29KUpdated Oct 22, 2026

configure-factory-rules

FreeSummary

Configure Factory board behavior and GitHub or Linear event handlers in deployment code. Adjust stage transitions, phase meanings, and tool-result handling, then check the changes with focused tests and versioned audit records.

  • Add approval requirements to board transitions
  • Change GitHub or Linear event handling
  • Define custom board phases and tool-result rules
mastra-ai/mastra29KUpdated Oct 22, 2026

content-writer-agent

FreeSummary

Design agents that draft blog posts, social posts, newsletters, and marketing copy. Define the audience, brand voice, length, and required output so each agent delivers a complete draft with a headline and supporting notes.

  • Build a blog writing agent with a consistent brand voice
  • Design an agent for LinkedIn product posts
  • Define delivery rules for newsletter drafts
mastra-ai/mastra29KUpdated Oct 22, 2026

See all skills by mastra-ai

Report a problem with this skill