skills.rest
Spectaculous-Code
Spectaculous-CodeOFFICIAL
Explore all skills by this author →
GitHub

performance_auditor

Analyze and optimize application performance across database, frontend, and AI components.

Updated Dec 19, 2025
Search Tags:#performance#database#optimization#ai#sql#react query
One-click install
npx skills add https://github.com/Spectaculous-Code/raamattu-nyt --skill performance-auditor-spectaculous-code
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: performance_auditor
Source: https://github.com/Spectaculous-Code/raamattu-nyt/tree/main/.claude/skills/performance-auditor
Command: npx skills add https://github.com/Spectaculous-Code/raamattu-nyt --skill performance-auditor-spectaculous-code

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps identify and resolve performance bottlenecks across your application's database, frontend, and AI systems, ensuring a faster and more efficient user experience.

Core Features & Use Cases

  • Database Query Analysis: Detect slow queries, missing indexes, and N+1 query patterns.
  • Frontend Performance: Optimize React Query caching, component rendering, and network requests.
  • AI Performance: Monitor AI call latency, costs, and cache effectiveness.
  • Use Case: If your application's chapter loading time has increased significantly, use this Skill to pinpoint whether the issue lies in slow database queries, inefficient React Query caching, or excessive AI calls for translations.

Quick Start

Use the performance auditor skill to analyze slow database queries and suggest index optimizations.

Frequently Asked Questions about performance_auditor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find slow SQL queries and fix missing indexes in my application?▼

To find slow SQL queries and fix missing indexes, you can run database diagnostics using SQL scripts to detect N+1 query patterns and suggest index improvements for optimized performance.

What is the best way to optimize React Query caching for slow loading pages?▼

Optimizing React Query caching involves reviewing your caching strategies and component rendering to reduce network requests and improve frontend performance during page loading.

How can I monitor AI call latency and reduce translation costs?▼

You can monitor AI call latency and reduce translation costs by analyzing AI component performance to evaluate cache effectiveness and identify areas to minimize excessive API calls.

Can I use this to diagnose performance bottlenecks across database, frontend, and AI components?▼

Yes, you can diagnose performance bottlenecks across database, frontend, and AI components to pinpoint whether slow loading is caused by SQL queries, React Query caching, or AI calls.

How do I resolve N+1 query patterns affecting my database performance?▼

Resolving N+1 query patterns requires analyzing your database queries through SQL scripts to detect the inefficient fetching behavior and applying the suggested index optimizations.

Related Skills

Explore More Software Engineering Skills→
cornmanwtfcornmanwtf

sql-query-optimizer

Analyze SQL query execution plans and identify performance bottlenecks.

Community
Intermediate
cosmixcosmix
53

caching

Implement caching strategies with TTL management and Redis or Memcached.

Community
Advanced
doanchienthangdevdoanchienthangdev
4

testing/performance-testing

Run load, stress, and benchmark tests with k6 and Node.js profilers.

Community
Advanced
avvaleavvale

postgresql

Optimize PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies.

Official
Advanced