🗺️ Backend Engineering · Journey Playbooks

Playbook: Fix database performance under load

Cut p95 query times on a growing table set before the next traffic spike.

journey~70 minBackend EngineersAPI DevelopersPlatform Engineers

Journey Steps

1Step 1 — Optimize the slow queries actually hurting you: start with "Pull top-10 queries by total time from pg_stat_statements or slow log"
2Step 2 — Layer caching with explicit invalidation: start with "Classify data: immutable (cache forever), mutable-TTL, never-cache (money)"
3How it fits together: Measure → index → cache, in that order. Caching a bad query hides it until invalidation day.

Commands

Install all referenced skills

$ npx skills add aniruddhaadak80/skills --skill databases-query-optimization && npx skills add aniruddhaadak80/skills --skill caching-queues-cache-strategy-layers

Tags

#playbook#journey#backend-engineering

Install this skill

$ npx skills add aniruddhaadak80/skills --skill playbook-backend-engineering-db-perf -a opencode

SKILL.md

# Playbook: Fix database performance under load

> Cut p95 query times on a growing table set before the next traffic spike.

## When to Use This Skill

Cut p95 query times on a growing table set before the next traffic spike.

## Steps

1. Step 1 — Optimize the slow queries actually hurting you: start with "Pull top-10 queries by total time from pg_stat_statements or slow log"
2. Step 2 — Layer caching with explicit invalidation: start with "Classify data: immutable (cache forever), mutable-TTL, never-cache (money)"
3. How it fits together: Measure → index → cache, in that order. Caching a bad query hides it until invalidation day.

View source on GitHub ↗

Take retrieval-augmented answers from empty repo to evaluated production feature.

🗺️ AI Engineering·~135m

Open →

🗺️Playbook: Harden an agent before giving it toolsjourney

Ship an autonomous agent whose failure modes are cheap, visible, and reversible.

🗺️ AI Engineering·~125m

Open →

🗺️Playbook: Cut LLM costs without quality collapsejourney

Reduce monthly inference spend measurably while keeping answer quality within tolerance.

🗺️ AI Engineering·~95m

Open →