db-audit

Solid

Database performance and safety audit. 70+ checks across 13 dimensions (DB1-DB13): query patterns, indexes, schema design, connections, transactions, migrations, caching, query optimization, ORM anti-patterns, observability, data lifecycle, DB security, and migration deployment safety. Code-level checks for all ORMs. Optional live analysis via PostgreSQL or MySQL connection. Switches: zuvo:db-audit full | [path] | [file] | --schema | --queries | --connections | --live <conn>

API & Backend 6 stars 0 forks Updated today MIT

Install

View on GitHub

Quality Score: 81/100

Stars 20%
28
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
80
License 10%
100
Description 5%
100

Skill Content

# zuvo:db-audit Audit database interactions from code patterns through schema design to live query plans. Produces a scored report with specific, actionable fixes ranked by impact and effort. **When to use:** Before releases, after adding models or queries, when latency increases, after scaling incidents, periodic health check. **When NOT to use:** Code quality (`zuvo:review`), full-stack performance (`zuvo:performance-audit`), security-only (`/security-audit`). ## Mandatory File Loading Read every file below before starting. Print the checklist. ``` CORE FILES LOADED: 1. ../../shared/includes/codesift-setup.md -- [READ | MISSING -> STOP] 2. ../../shared/includes/env-compat.md -- [READ | MISSING -> STOP] 3. ../../shared/includes/run-logger.md -- [READ | MISSING -> STOP] ``` **Deferred (lazy load):** ``` DEFERRED FILES (read only when needed): - ../../shared/includes/retrospective.md -- read right before Phase 6 (saves ~3K tokens during audit) ``` Note: `cq-patterns.md` is NOT loaded — this is a read-only audit, not a code quality review. Loading it wastes ~7K tokens per turn. If any CORE file is MISSING, STOP. Do not proceed from memory. --- ## MANDATORY TOOL CALLS — Audit Validity Gate **This audit is INVALID if any of the tools below are skipped when their trigger condition holds.** "DEFERRED", "N/A", "no diff vs prior audit" are NOT valid reasons. The presence of trigger artifacts (migrations directory, .sql files, ORM schema, ...

Details

Author
greglas75
Repository
greglas75/zuvo
Created
4 months ago
Last Updated
today
Language
Shell
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category