Create a Data Dictionary
Generate a comprehensive data dictionary for any database schema or dataset.
The Prompt
Create a data dictionary for the following database schema. For each table and column, document: 1. Table: name, purpose, row count estimate, update frequency, primary key 2. Column: name, data type, nullable, description, valid values or range, source, sample values 3. Relationships: foreign key relationships and what they represent 4. Business rules: any constraints or logic applied to this data 5. Known data quality issues 6. Ownership: which team/system is responsible Output as a markdown table for easy documentation. Schema: ```sql [PASTE YOUR TABLE DEFINITIONS] ``` Context: [ANY BUSINESS CONTEXT ABOUT HOW THIS DATA IS USED]
Example Output
Data dictionary with 6 tables (users, organizations, api_keys, usage_events, billing, subscriptions): each table has a 1-sentence purpose description, estimated row scale, and per-column documentation including business rules (e.g., 'deleted_at uses soft-delete pattern — never physically deleted').
FAQ
Which AI model is best for Create a Data Dictionary?
Claude Sonnet 4 — thorough and structured documentation.
How do I use the Create a Data Dictionary prompt?
Copy the prompt, replace the [BRACKETED] placeholders with your specific information, and paste into your preferred AI assistant (ChatGPT, Claude, Gemini, etc.). Data dictionary with 6 tables (users, organizations, api_keys, usage_events, billing, subscriptions): each table has a 1-sentence purpose description, estimated row scale, and per-column documentation including business rules (e.g., 'deleted_at uses soft-delete pattern — never physically deleted').
Model Recommendation
Claude Sonnet 4 — thorough and structured documentation.