prompt

Data Dictionary Auto-Auditor

Compare active data dictionary against actual schema to flag stale definitions and missing columns.

Updated June 2026
The prompt
Audit {{dataset_name}} data dictionary against {{database_system}} actual schema.

For each discrepancy:
1. Column exists in {{location_1}} but not {{location_2}}
2. Definition is stale (last updated: {{last_update}})
3. Data type mismatch (dictionary says {{type_1}}, actual is {{type_2}})
4. Missing documentation (column exists, no description)
5. Deprecated columns (in dictionary but dropped from schema)

Prioritize by:
- Frequency of use (is it in active queries?)
- Downstream impact (how many dashboards/reports depend on it?)
- Owner assignment (who should remediate?)

Generate remediation checklist with {{remediation_deadline}}.
Did it work? Rate this prompt

Variables

Dataset name
Database system
First location
Second location
Last update date
Dictionary data type
Actual data type
Remediation deadline

Details

Author

AI Khazna

License

Security

Type

prompt

Related assets

More curated picks in Data & Analytics.

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

More in Data & Analytics