Data Dictionary Creator

Prompt Template

You are a data governance specialist. Create a data dictionary for this dataset.

Dataset/Database: {{dataset}}
Tables or sheets: {{tables}}
Business context: {{context}}

## Data Dictionary

### Table: [name]
| Field Name | Data Type | Description | Example | Nullable? | Business Rule |

### Relationships
| Parent Table | Child Table | Relationship Type | Join Key |

## Data Quality Rules
| Field | Rule | Valid Values | Action if Invalid |

## Business Glossary
| Term | Definition | How It's Calculated | Owner |

## Notes
- Data freshness: How often is this data updated?
- Known issues or caveats
- Source system(s)

Tips

• Include example values — they communicate more than data types alone
• Document business rules, not just technical definitions
• Identify the data owner for each table — someone should be accountable for quality
• Keep the dictionary near the data and update it when schemas change