ln-25-persistence-auditor
starsforks
How to install ln-25-persistence-auditor?
levnikolaevich/claude-code-skills/ln-25-persistence-auditor
$npx -y skills add levnikolaevich/claude-code-skills --skill ln-25-persistence-auditorAudits queries, transactions, data-path performance, and persistence resource lifecycle. Use when data correctness or scalability is at risk; not for general performance tuning.
SKILL.md
| 1 | # Persistence Auditor |
| 2 | |
| 3 | **Goal:** Perform a read-only audit of persistence and data-heavy runtime paths. Connect static candidates to real query, transaction, resource, or consistency mechanisms and avoid claiming performance impact without evidence. |
| 4 | |
| 5 | **Execution contract:** Treat the ordered checkbox workflow below as this skill's Definition of Done. Work through every item in order, and mark it complete only when its action and required evidence are complete. `N/A`, skipped, unavailable, or delegated items remain incomplete. |
| 6 | Before returning, apply this skill's verdict, decision, and approval rules to every incomplete item and prepend **Checklist: X/Y complete**<br>**Incomplete: None | section/item — reason; outcome impact; exact next action**; list every incomplete item. |
| 7 | |
| 8 | ## Tool Routing |
| 9 | |
| 10 | | Need | Preferred tool | Use it when | Fallback | |
| 11 | |---|---|---|---| |
| 12 | | Data-layer map | Native file search over manifests, models, mappings, repositories, migrations, queries, cache, queue, and pool configuration | Establishing stores, frameworks, ownership, and scope | Trace from known request, job, or command entrypoints | |
| 13 | | Call paths and resource ownership | Language server or host-native code intelligence | Following service calls, transaction boundaries, async flow, session scopes, and cleanup | Targeted search plus direct inspection of definitions and callers | |
| 14 | | Query behavior | Existing query logs, tracing, ORM diagnostics, and application metrics | Establishing frequency, duplication, timing, rows, and cache behavior | Static query-in-loop and fetch-shape analysis with explicit limits | |
| 15 | | Query plans | Database-native explain tooling on an approved non-production target | A safe read query and representative schema/data are available | Inspect indexes, predicates, joins, statistics assumptions, and generated SQL statically | |
| 16 | | Runtime performance | Existing profiler, benchmark, or repository diagnostic command | Allocation, blocking, loop amplification, or I/O cost needs measurement | Complete static cost path marked as unmeasured | |
| 17 | | Correctness verification | Repository-defined tests, integration environment, and migration checks | Reproducing transaction, retry, consistency, or lifecycle behavior safely | Static failure trace and required verification plan | |
| 18 | | External semantics | Official database, driver, framework, and runtime documentation matching installed versions | Isolation, pooling, cancellation, caching, trigger, or async semantics affect a finding | Primary-source web research; otherwise mark `UNVERIFIED` | |
| 19 | |
| 20 | Never connect to production or run mutating diagnostics. `EXPLAIN ANALYZE` executes the statement: use it only for confirmed read-only queries on an approved disposable or non-production target. Do not create indexes, migrate, vacuum, rewrite data, or change pool settings during the audit. |
| 21 | |
| 22 | ## Evidence Rules |
| 23 | |
| 24 | - Query count, duration, rows, plan, lock, or profile evidence is stronger than a static performance suspicion. |
| 25 | - Static evidence can prove correctness and lifecycle defects when the full path is visible, but performance impact must be labeled unmeasured. |
| 26 | - ORM conventions, bounded administrative paths, startup-only work, and intentionally small datasets require context before becoming findings. |
| 27 | - Transaction advice must match the actual database, isolation level, driver, framework, and retry model. |
| 28 | - Recommendations must preserve data integrity and failure semantics, not only reduce latency. |
| 29 | |
| 30 | ## Checklist |
| 31 | |
| 32 | ### 1. Establish the Data and Runtime Context |
| 33 | |
| 34 | - [ ] Detect databases, ORMs, drivers, caches, queues, schemas, migrations, pools, dependency-injection scopes, and runtime entrypoints in scope. |
| 35 | - [ ] Resolve installed versions, database capabilities, deployment topology, consistency requirements, and expected workload from repository evidence. |
| 36 | - [ ] Identify critical data paths, high-volume paths, streaming paths, scheduled work, and operations that hold transactions or resources across external calls. |
| 37 | - [ ] Read repository instructions and inspect Git state before running diagnostics or interpreting current work. |
| 38 | - [ ] Establish available query logs, metrics, traces, profiles, representative data, test environments, and safe diagnostic permissions. |
| 39 | - [ ] Keep the audit read-only and document every executed query, command, target, and artifact created. |
| 40 | |
| 41 | ### 2. Audit Query and Cache Efficiency |
| 42 | |
| 43 | - [ ] Trace representative paths from entrypoint through business logic to generated query and materialization. |
| 44 | - [ ] Find N+1 behavior, repeated identical fetches, query-in-loop patterns, sequential independent reads, and redundant existence or count queries. |
| 45 | - [ ] Check over-fetching, broad entity loading, unbounded reads, premature materialization, missing paginat |
People who liked this also viewed
6 picksType
- azure-storageAzure Storage Services including Blob Storage, File Shares, Queue Storage, Table Storage, and Data Lake. Answers questions about storage access tiers (hot, cool, cold, archive), when to use each tier,SkillsJul 2026
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.SkillsJul 2026
- supabaseUse when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge Functions, Realtime, Storage, Vectors, Cron, Queues); client libraries and SSR integrations (supabase-js, SkillsJul 2026
- convex-quickstartCreates or adds Convex to an app. Use for new Convex projects, npm create convex@latest, frontend setup, env vars, or the first npx convex dev run.SkillsJul 2026
- convex-performance-auditAudits Convex performance for reads, subscriptions, write contention, and function limits. Use for slow features, insights findings, OCC conflicts, or read amplification.SkillsJul 2026
- convex-setup-authSets up Convex auth, identity mapping, and access control. Use for login, auth providers, users tables, protected functions, or roles in a Convex app.SkillsJul 2026
