performances
Installation
SKILL.md
Performances
One entry point for measured, behavior-preserving performance work on any codebase. Every action detects the stack first, adapts to it, says what does not apply, then follows the same loop: measure before, fix, measure after, ship one PR. The first word of the arguments picks the action; everything after it goes to that action unchanged.
| Action | Playbook | What it does |
|---|---|---|
parallel |
references/parallel.md | Finds sequential awaits on hot paths that are independent and runs them concurrently. Keeps authz gates, transactions, ordered writes, and ordered events sequential. Alias parallel-async. |
dbload |
references/dbload.md | Builds a load-test suite for the DB schema: seeds real relationships at 1x/10x/100x/1000x, runs the code's real queries, finds what fails at scale, fixes it, and charts before/after with confidence intervals. Never touches prod. Alias db-load-test. |
otel |
references/otel.md | Adds OpenTelemetry tracing to the vendor already in use, applied at function definitions, enforced by a lint rule, with request context on every span and traceparent in and out. Alias otel-tracing. |
logging |
references/logging.md | Replaces scattered log lines with one wide, context-rich event per request or job, tail-sampled, sharing trace ids with tracing. Alias wide-event-logging. |
select |
references/select.md | Finds whole-row loads that read a few fields and selects only what is needed. Alias select-fields. |
url |
references/url.md | Removes new URL() style parsing that does no validation or normalization of untrusted input. Alias url-parsing. |
regex |
references/regex.md | Hoists regexes out of functions and loops, handling g/y state and dynamic patterns. Alias hoist-regex. |
jsonb |
references/jsonb.md | Promotes a hot-path single key of a large jsonb column to a real column, with migration and backfill that a human approves for prod. Alias jsonb-columns. |
all |
references/all.md | Runs the eight actions in that order as separate workstreams, each with its own branch and PR. |