One-click install
npx skills add https://github.com/nodatall/primedirective --skill backend-optimizer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: backend-optimizer
Source: https://github.com/nodatall/primedirective/tree/main/skills/backend-optimizer
Command: npx skills add https://github.com/nodatall/primedirective --skill backend-optimizer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill eliminates guesswork in backend performance tuning by replacing speculative changes with measured, evidence-based optimizations for slow backend routes, unoptimized database queries, poor schema/index health, and inefficient runtime work.

Core Features & Use Cases

  • Report-First Audits: Inventory and rank all backend and database performance candidates by impact, with clear evidence and safe fix paths, stopping before changes unless explicitly approved.
  • Bounded Fix Loops: Run structured /goal optimization loops that track state via a candidate ledger and goal-run document, fix only safe high-impact candidates with before/after validation, and resweep until all high-impact surfaces are classified.
  • Full Surface Coverage: Covers application-visible queries, schema/index/constraint health, backend runtime paths, connection/lock/migration/observability hygiene, and gates high-risk changes like schema redesigns for human approval.
  • Use Case: For a web app with slow user profile load times, the skill can inventory all related database queries, identify missing indexes via EXPLAIN plans, apply the smallest safe index fix, validate latency improvements, and reject speculative caching changes without evidence.

Quick Start

Use the backend-optimizer skill to audit your backend and database performance, get a ranked list of bottlenecks with safe fix recommendations, or run a bounded measured fix loop to safely improve high-impact candidates with verified before/after results.

Frequently Asked Questions about backend-optimizer

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

FAQPage Schema
How do I audit slow database queries and identify missing indexes?

To audit slow database queries, you inventory and rank all backend performance candidates by impact using EXPLAIN plans to identify missing indexes and safe fix paths. The process stops before applying changes unless explicitly approved.

What is a measured backend optimization loop?

A measured backend optimization loop tracks state via a candidate ledger and goal-run document, fixing only safe high-impact candidates with before/after validation. It resweeps until all high-impact surfaces are classified to avoid speculative changes.

Can I use this to improve connection lock and migration hygiene?

Yes, you can use this to improve connection, lock, migration, and observability hygiene. It covers full surface areas including backend runtime paths and operational hygiene, while gating high-risk changes like schema redesigns for human approval.

What is the best way to reduce inefficient backend runtime work?

The best way to reduce inefficient backend runtime work is applying evidence-based fixes with safety gates. This approach rejects speculative caching changes without evidence, validating latency improvements through bounded fix loops.

When should I avoid speculative database schema changes?

You should avoid speculative database schema changes when lacking measured evidence. High-risk modifications like schema redesigns are gated for human approval, requiring before/after validation to prevent production risk.