db-efficiency-audit

스타4

포크0

업데이트2026년 7월 18일 15:25

Audit database workloads for energy-wasting query and schema patterns — full table scans, missing indexes, SELECT * over-fetching, N+1 query storms, chatty ORMs, oversized instances, missing connection pooling. Use this skill whenever the user shares slow-query logs, EXPLAIN plans, ORM code, schema DDL, or asks why the database is slow/expensive/hot, or wants a database efficiency or sustainability review. Part of Lean Agentic AI Skills; emits lean-findings.json.

설치

Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.

출처

navveenb

navveenb/lean-agentic-ai-skills

GitHub 저장소 열기 Creator 저장소 보기

다운로드

DB Efficiency Audit

Producer skill. Input: slow-query logs, EXPLAIN/EXPLAIN ANALYZE output, schema, application data-access code. Output: lean-findings.json.

Databases convert bad access patterns into heat with perfect reliability, on every request, forever. This is E-reduction at the hottest point of most stacks.

Subject type: emit subject.type: "database" in findings.

Signatures

Full scans on hot paths — Seq Scan / type=ALL in plans for frequent queries. High. Fix: the specific index (name the columns), or query rewrite.
N+1 storms — loops issuing per-row queries (visible in ORM code or repeated-shape log entries). High. Fix: eager loading / JOIN / batched IN.
SELECT * over wire for wide tables when few columns are used. Medium. Reduces E and network.
Missing pagination — unbounded result sets to app or API. Medium-high.
Chatty transactions — many round trips where one statement/procedure would do. Medium.
No connection pooling — connection churn burning CPU on handshakes. Medium.
Index bloat — many near-duplicate or unused indexes (from stats if provided) taxing every write. Medium.
Wrong workload home — analytics scans hammering the OLTP primary → offload to replica/warehouse. Medium-high, also an architecture finding.
Cacheable reads uncached — identical hot queries with no cache layer; route design to caching-strategy-designer, record the finding here.

Honesty rules

Indexes cost writes and storage — say so per recommendation. Never claim a plan improvement without a plan in hand; "likely index candidate — verify with EXPLAIN" is the honest phrasing. Evidence = actual log lines/plan fragments.

Cost signal (countable)

Cost drivers: bytes scanned per query (warehouse pricing) and query-hours / DBUs (compute pricing). Where slow-query logs or profiles show these, quote the counted value in cost_signal.observed and describe direction qualitatively.

Not this skill's job

Instance sizing (right-size-compute), cache design (caching-strategy-designer), storage tiering (storage-lifecycle-audit).

이 저장소의 다른 Skills

같은 저장소

agentic-loop-auditor

navveenb/lean-agentic-ai-skills

Audit agent frameworks and agentic workflows for token-burning loop pathologies — unbounded retries, excessive planning depth, tool-call thrashing, context snowballing, missing loop budgets and kill switches. Use this skill whenever the user shares agent configs or traces (LangChain/LangGraph, CrewAI, AutoGen, custom loops), complains an agent is slow or expensive, or is designing any autonomous/multi-step agent. Part of Lean Agentic AI Skills; emits lean-findings.json.

2026-07-184

ai-eval-efficiency-audit

navveenb/lean-agentic-ai-skills

Audit AI evaluation infrastructure for wasted compute — full benchmark suites re-run on unchanged cases, LLM-as-judge grading without caching, oversized judge models, redundant eval passes per commit, and missing result reuse. Use this skill whenever the user shares eval harness configs or CI eval steps, complains that evals are slow or expensive, mentions LLM-as-judge costs, or runs benchmark suites on every change. Part of Lean Agentic AI Skills; emits lean-findings.json.

2026-07-184

api-efficiency-audit

navveenb/lean-agentic-ai-skills

Audit API design for chattiness and over-fetching — REST endpoints requiring N calls per screen, GraphQL resolvers with N+1 fan-out, default-everything payloads, missing pagination and field selection, provider-side polling where webhooks serve, and uncompressed responses. Use this skill whenever the user shares API schemas (OpenAPI, GraphQL SDL), resolver code, endpoint designs, or asks why clients make too many calls or payloads are heavy. Part of Lean Agentic AI Skills; emits lean-findings.json.

2026-07-184

caching-strategy-designer

navveenb/lean-agentic-ai-skills

Design caching layers so work is done once, not per request — HTTP/CDN caching, application-level caches (Redis/Memcached), computed-result caching, and cache-invalidation strategy. Use this skill whenever the user wants to add caching, asks why the same work is recomputed, designs a read-heavy system, or an audit skill (db-efficiency-audit, web-carbon-audit) flags uncached repeated work. Part of Lean Agentic AI Skills; emits a cache design plus lean-findings.json.

2026-07-184

carbon-aware-scheduler

navveenb/lean-agentic-ai-skills

Design time-shifting of flexible workloads (batch jobs, CI, training, backups, crons) to hours and regions when grid electricity is cleanest, using carbon-intensity signals like Electricity Maps, WattTime, or the Carbon Aware SDK. Use this skill whenever the user mentions carbon-aware computing, scheduling flexible/deferrable jobs, demand shifting, running workloads when energy is clean, or asks how to reduce the carbon intensity (not just amount) of their compute. Part of Lean Agentic AI Skills; emits schedule designs plus lean-findings.json.

2026-07-184

carbon-budget-designer

navveenb/lean-agentic-ai-skills

Design per-feature and per-service efficiency budgets — page-weight budgets, token budgets per AI feature, query budgets per endpoint, GPU-hour budgets per training project — with owners, review checkpoints, and enforcement hooks. Use this skill whenever the user wants sustainability targets for teams, asks how to keep efficiency from regressing organizationally, mentions performance-budget-style governance for carbon/energy, or is setting engineering standards. Part of Lean Agentic AI Skills; an advisor emitting budget definitions plus lean-findings.json.

2026-07-184

name

db-efficiency-audit

description

DB Efficiency Audit

Producer skill. Input: slow-query logs, EXPLAIN/EXPLAIN ANALYZE output, schema, application data-access code. Output: lean-findings.json.

Databases convert bad access patterns into heat with perfect reliability, on every request, forever. This is E-reduction at the hottest point of most stacks.

Subject type: emit subject.type: "database" in findings.

Signatures

Full scans on hot paths — Seq Scan / type=ALL in plans for frequent queries. High. Fix: the specific index (name the columns), or query rewrite.
N+1 storms — loops issuing per-row queries (visible in ORM code or repeated-shape log entries). High. Fix: eager loading / JOIN / batched IN.
SELECT * over wire for wide tables when few columns are used. Medium. Reduces E and network.
Missing pagination — unbounded result sets to app or API. Medium-high.
Chatty transactions — many round trips where one statement/procedure would do. Medium.
No connection pooling — connection churn burning CPU on handshakes. Medium.
Index bloat — many near-duplicate or unused indexes (from stats if provided) taxing every write. Medium.
Wrong workload home — analytics scans hammering the OLTP primary → offload to replica/warehouse. Medium-high, also an architecture finding.
Cacheable reads uncached — identical hot queries with no cache layer; route design to caching-strategy-designer, record the finding here.

Honesty rules

Cost signal (countable)

Not this skill's job

Instance sizing (right-size-compute), cache design (caching-strategy-designer), storage tiering (storage-lifecycle-audit).