skills.rest
toobutta
toobuttaCOMMUNITY
Explore all skills by this author →
GitHub

performance

Audit cache TTLs, Redis health, PostgreSQL indexing, N+1 queries, bundle size, and Celery tasks.

Updated Dec 14, 2025
Search Tags:#performance#monitoring#postgresql#redis#audit#cache#celery
One-click install
npx skills add https://github.com/toobutta/maptelli --skill performance-toobutta
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: performance
Source: https://github.com/toobutta/maptelli/tree/main/.claude/skills/performance
Command: npx skills add https://github.com/toobutta/maptelli --skill performance-toobutta

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Identify and prevent performance regressions in the Maptelli platform by auditing cache TTLs, Redis health, database indexing, N+1 queries, bundle size, and Celery task monitoring.

Core Features & Use Cases

  • Cache TTL verification across property search, detail, and analysis data; TTL mismatches trigger alerts.
  • Database health: index verification, N+1 query risk detection, and slow query diagnostics.
  • Frontend and Celery observability: bundle size analysis, React query timing, and Flower-based task monitoring for production readiness.
  • Quick remediation guidance and ready-to-run verification for release validation.
  • Example use: before a production release, run a full audit to ensure no performance regressions.

Quick Start

Run a full performance audit across all sections to generate the production readiness report.

Frequently Asked Questions about performance

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

FAQPage Schema
How do I audit PostgreSQL indexing and N+1 query risks before a production release?▼

To audit PostgreSQL indexing and N+1 queries before release, inspect backend code paths to verify index presence and detect N+1 query patterns. This database health check ensures slow query risks are caught during development.

What is cache TTL verification and how does it prevent performance regressions?▼

Cache TTL verification checks Redis settings across search and analysis data to detect TTL mismatches. It triggers alerts when configurations deviate from defined standards, preventing performance regressions before release.

Can I use Celery task monitoring and bundle size analysis for pre-release validation?▼

Yes, you can validate production readiness by analyzing Celery task monitoring via Flower and frontend bundle size. Inspecting React query timing ensures observability gaps are resolved pre-release.

What's the best way to run a full performance audit across backend, database, frontend, and task-queue layers?▼

The best way to run a full performance audit is to inspect code paths and configurations in backend and frontend modules simultaneously. This cross-layer audit generates a production readiness report.

Does Redis health checking require specific configuration inspection in the backend app?▼

Yes, Redis health checking requires inspecting configuration in the backend app to ensure results align with defined TTLs and monitoring settings. This verifies cache health and detects misconfigurations.

Related Skills

Explore More Software Engineering Skills→
civitaicivitai
7.2k

redis-inspect

Inspect Redis cache keys, TTLs, types, and values with JSON output.

Official
Intermediate
dr-codedr-code

release-check

Run pre-release verification checks and write a versioned release assessment report.

Community
Advanced
ConnectiveTCSConnectiveTCS

celery-expert

Optimize Celery task processing with retries, idempotency, and beat scheduling.

Community
Advanced
kevinnguyen271090kevinnguyen271090
15

databases

Design and optimize MongoDB and PostgreSQL databases for schema, queries, and performance.

Community
Intermediate