Run any Skill in Manus with one click

performance-auditor

Stars0

Forks0

UpdatedJune 22, 2026 at 13:26

Expert assistant for monitoring and optimizing performance in the KR92 Bible Voice project. Use when analyzing query performance, optimizing database indexes, reviewing React Query caching, monitoring AI call costs, or identifying N+1 queries. Helps diagnose slow operations across database, frontend, and AI systems.

Installation

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

Run Skill in Manus

Source

Spectaculous-Code

Spectaculous-Code/raamattu-nyt

View GitHub Repository View Creator Repositories

Download

Run Skill in Manus

Related occupationsSOC

Based on SOC occupation classification

Software DevelopersComputer and Mathematical Occupations·SOC 15-1252

File Explorer

9 files

SKILL.md

readonly

name	performance-auditor
description	Expert assistant for monitoring and optimizing performance in the KR92 Bible Voice project. Use when analyzing query performance, optimizing database indexes, reviewing React Query caching, monitoring AI call costs, or identifying N+1 queries. Helps diagnose slow operations across database, frontend, and AI systems.

Performance Auditor

Expert performance optimization for the Raamattu Nyt application across database, frontend, and AI systems.

Quick Start

Choose your performance concern:

Database performance: Slow queries, missing indexes, sequential scans → See references/sql-queries.md
React Query optimization: Caching strategy, stale times, unnecessary refetches → See references/react-query-patterns.md
AI performance: Latency, costs, cache effectiveness → See references/ai-monitoring.md
N+1 query detection: Finding and fixing N+1 patterns → See references/n+1-detection.md
Optimization checklist: Complete performance audit → See references/checklist.md
Common gotchas: Known issues and pitfalls → See references/learnings.md

Performance Targets

Reference targets for healthy performance:

Operation	Target
Single verse lookup	<20ms
Chapter load	<50ms
Text search	<100ms
AI translation	<500ms
Page load (FCP)	<1.5s
API response	<200ms

How to Use This Skill

Identify your performance issue (database, frontend, AI, or N+1)
Read the appropriate reference file above
Run SQL scripts or code patterns from scripts/ if needed
Check references/learnings.md if results seem unexpected

Key Tools

Database analysis: Read references/sql-queries.md then run scripts/analyze-queries.sql
N+1 detection: See references/n+1-detection.md and scripts/detect-n+1.js
Cache optimization: See references/react-query-patterns.md for staleTime/gcTime strategy
AI monitoring: See references/ai-monitoring.md for latency and cost tracking

Context Files

For codebase structure reference:

Docs/context/db-schema-short.md - Database tables and indexes
Docs/context/supabase-map.md - Edge functions to monitor

More from this repository

same repository

error-fixer

Spectaculous-Code/raamattu-nyt

Fix JavaScript and HTTP errors flagged for AI in the admin dashboard. Queries the database for errors with ai_status='flagged_for_ai', analyzes them, and attempts to fix them. Use for: "fix errors"/"fix flagged errors", "check error queue", AI error-queue / AI-flagged errors, or after flagging errors in the admin dashboard. Triggers: "fix errors", "error queue", "ai errors", "flagged errors", "fix ai errors", "/fix-errors"

2026-06-240

security-auditor

Spectaculous-Code/raamattu-nyt

Comprehensive Supabase security auditor for RLS policies, table privileges (GRANTs), and access control validation. Use for: auditing DB security (RLS + GRANTs), generating an access matrix (who can SELECT/INSERT/UPDATE/DELETE which tables), finding gaps (missing RLS, over-permissive GRANTs), validating PostgREST access patterns, writing security docs for Docs/context/, creating RLS policies, validating user data protection, checking admin access, identifying vulnerabilities, and triaging security scanner output (Supabase database linter / advisors and the Lovable agentic security scanner — RLS-disabled, SECURITY DEFINER executable by anon/authenticated, mutable search_path, public bucket listing, extension in public, exposed sensitive columns). Also use for designing ROLE-PERMISSION TESTS: building the per-role permissions matrix (anon / authenticated / admin + the plan ladder free/pro/premium), and obtaining a session per role to run the tests (pgTAP `request.jwt.claims` or `signInWithPassword`). Knows th

2026-06-240

lovable-setup

Spectaculous-Code/raamattu-nyt

Debug and fix Lovable preview/build issues including white screens, module import failures, and monorepo configuration. Use when: (1) Lovable preview shows white/blank screen, (2) "Failed to fetch dynamically imported module" errors, (3) Missing script errors, (4) PostCSS/Tailwind resolution failures, (5) Workspace package resolution errors, (6) 504 Gateway Timeout on dependencies, (7) Setting up monorepo for Lovable deployment. Triggers: "lovable broken", "white screen", "preview not loading", "lovable build failed", "dynamic import error", "module not found lovable".

2026-06-230

topic-manager

Spectaculous-Code/raamattu-nyt

Expert assistant for managing biblical topics in the KR92 Bible Voice project. Use when (1) creating/editing topics and their Finnish translations, (2) managing topic relations (related, opposite, broader, narrower), (3) validating Finnish translations and pronunciations with Voikko/Omorfi, (4) reviewing topics marked with qa_status='unchecked', (5) bulk updating topic translations, (6) managing topic aliases and synonyms, (7) fixing incorrectly translated Finnish topic names, or (8) structuring the topic taxonomy — building/auditing the parent_id tree (hierarchy, broader/narrower, roots, orphans, cycles, depth), assigning a coherent root backbone, re-parenting after merges, and linking related/opposite topics. Trigger words — aihe, topic, teema, taksonomia, rakenne, puurakenne, hierarkia, parent, root, liitos, yhdistäminen/merge, relation, alias.

2026-06-230

bible-lookup-helper

Spectaculous-Code/raamattu-nyt

Bible reference lookups, full-text/topic/Strong's/Q&A search, and AI semantic search in Raamattu Nyt. Use for fetching verses by reference (Joh 3:16), building/modifying the SearchPage (7 tabs: jakeet/aiheet/Strong's/kysymykset/videot/muut/comparison), calling search RPCs (search_text, search_topics_with_aliases, search_verses_by_strongs, get_approved_ai_summary), classifying queries (verse vs topic vs Strong's vs free-text), anchor questions/AI summaries/topic synonyms, validating OSIS references, and choosing the right lookup pattern.

2026-06-220

edge-function-generator

Spectaculous-Code/raamattu-nyt

Expert assistant for creating and maintaining Supabase Edge Functions for the KR92 Bible Voice project. Use when (1) creating new Edge Functions, (2) setting up CORS and error handling, (3) integrating shared modules from _shared/, (4) adding JWT validation, (5) configuring environment variables, (6) auditing or updating dependency versions across functions. Triggers include "edge function", "create function", "serverless", "deno function", "update edge imports", "version drift".

2026-06-220

name	performance-auditor
description	Expert assistant for monitoring and optimizing performance in the KR92 Bible Voice project. Use when analyzing query performance, optimizing database indexes, reviewing React Query caching, monitoring AI call costs, or identifying N+1 queries. Helps diagnose slow operations across database, frontend, and AI systems.

Performance Auditor

Expert performance optimization for the Raamattu Nyt application across database, frontend, and AI systems.

Quick Start

Choose your performance concern:

Database performance: Slow queries, missing indexes, sequential scans → See references/sql-queries.md
React Query optimization: Caching strategy, stale times, unnecessary refetches → See references/react-query-patterns.md
AI performance: Latency, costs, cache effectiveness → See references/ai-monitoring.md
N+1 query detection: Finding and fixing N+1 patterns → See references/n+1-detection.md
Optimization checklist: Complete performance audit → See references/checklist.md
Common gotchas: Known issues and pitfalls → See references/learnings.md

Performance Targets

Reference targets for healthy performance:

Operation	Target
Single verse lookup	<20ms
Chapter load	<50ms
Text search	<100ms
AI translation	<500ms
Page load (FCP)	<1.5s
API response	<200ms

How to Use This Skill

Identify your performance issue (database, frontend, AI, or N+1)
Read the appropriate reference file above
Run SQL scripts or code patterns from scripts/ if needed
Check references/learnings.md if results seem unexpected

Key Tools

Database analysis: Read references/sql-queries.md then run scripts/analyze-queries.sql
N+1 detection: See references/n+1-detection.md and scripts/detect-n+1.js
Cache optimization: See references/react-query-patterns.md for staleTime/gcTime strategy
AI monitoring: See references/ai-monitoring.md for latency and cost tracking

Context Files

For codebase structure reference:

Docs/context/db-schema-short.md - Database tables and indexes
Docs/context/supabase-map.md - Edge functions to monitor