Skip to content

VidyFoo/antigravity-skill-engine / .agent/skills/2-audit/code-auditing

code-auditing

Verified

系统化审计与代码优化 - Code Review / Simplifier / Council / Performance。

resources/resources/backend-checklist.md

View on GitHub
# Backend Performance Checklist

## 🗄️ Database (PostgreSQL/Prisma)
- [ ] **Indexing**: Are foreign keys and frequently searched columns indexed?
- [ ] **N+1 Problem**: Are you fetching related data in a loop? Use `include` (Prisma) or `Dataloader`.
- [ ] **Select Fields**: Are you selecting `*` (or default all fields) when you only need `id` and `name`?
- [ ] **Connection Pooling**: Are you exhausting DB connections? Use a pooler (e.g., PgBouncer/Supabase Transaction Mode).

## ⚡ API & HTTP
- [ ] **Compression**: Is Gzip/Brotli enabled? (Express: `app.use(compression())`)
- [ ] **Caching**:
  - **Browser**: Are you setting `Cache-Control` headers for static/public data?
  - **Server**: Are you using Redis/Memory to cache expensive query results?
- [ ] **Validation**: Are you validating input *before* processing logic? (Fail fast).

## 🟢 Node.js Runtime
- [ ] **Event Loop**: Are you blocking the event loop with synchronous crypto or fs calls?
- [ ] **Async/Await**: Are you using `Promise.all` for parallel tasks instead of serial `await`?
- [ ] **Logging**: ensuring logging levels (Info/Debug) don't flood stdout in production.
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 469kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 469kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 469kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall