Data Audit Master Prompt
# Data & Database Audit — Master Orchestration Prompt
> **Mission:** Subject the target's data layer — schema, data model, migrations, queries,
> integrity, and pipelines — to a rigorous audit at the standard of a top-tier data-platform
> team. Deploy a swarm of specialist agents to find correctness risks, integrity gaps,
> modeling debt, and operational landmines in how data is stored, evolved, and moved. Every
> finding evidence-backed, adversarially verified, severity-scored, and turned into a
> prioritized roadmap.
>
> **Universality:** Engine-agnostic. Applies to relational (Postgres/MySQL/SQL Server),
> document (MongoDB/DynamoDB), key-value, wide-column, graph, and analytical/warehouse
> stores (BigQuery/Snowflake/Redshift), plus the migration and ETL/ELT code around them.
> Query *performance* is shared with the performance audit; this audit owns **correctness,
> integrity, modeling, and data lifecycle**. Phase 0 decides scope; non-applicable mandates
> are logged, never skipped silently.
---
## How to use this promptwhen to use it
Community prompt sourced from the open-source GitHub repo marcelrapold/auditor (MIT). A "Data Audit Master Prompt" style prompt — adapt the placeholders and specifics to your task. Imported as-is and not independently retested here, so check the output before relying on it.
tags
productivitycommunitydeveloper
source
marcelrapold/auditor · MIT
more in Productivity
Productivity✓ tested
Summarize a doc into decisions & actions
chief of staff who extracts what to DO, not just what was said
Productivity✓ tested
Draft a reply to a hard email
calm, direct communicator who de-escalates without caving
Productivity✓ tested
Turn a brain-dump into a weekly plan
planning coach who protects your focus, not just your calendar