1. Pipeline Design Document Writer
Generates a detailed ETL/ELT pipeline design doc including source systems, transformation logic, scheduling, error handling, and monitoring approach.
Copy-paste prompt
"Write a pipeline design document for the following ETL/ELT pipeline: [describe your pipeline — source systems, data flow, and destination]. Include: Pipeline Overview and Purpose, Source Systems and Extraction Method, Transformation Logic and Business Rules, Scheduling and Orchestration, Error Handling and Retry Strategy, Monitoring and Alerting Approach, and Data Quality Checks. Format it as a technical design doc suitable for code review and team handoff."
2. Data Model Documentation Writer
Produces a data modeling document covering entity relationships, table schemas, primary/foreign keys, data types, and business rules.
Copy-paste prompt
"Write a data model documentation document for the following schema: [paste your table definitions or describe the data model]. Include: Entity Relationship Overview, Table Schemas with column names and data types, Primary and Foreign Key relationships, Business Rules and Constraints, Indexing Strategy, Data Lineage (where each field originates), and Known Limitations or Design Decisions. Format it so both engineers and business analysts can understand the model."
3. Incident Report Writer (Data Pipeline)
Writes a structured incident report for a data pipeline failure: timeline, root cause, blast radius, remediation steps, and prevention measures.
Copy-paste prompt
"Write a data pipeline incident report for the following failure: [describe what happened — e.g. a pipeline failure that caused stale data in dashboards for 6 hours]. Structure it as: Incident Summary, Timeline of Events (detection through resolution), Root Cause Analysis, Blast Radius (which systems, datasets, and stakeholders were impacted), Immediate Remediation Steps Taken, and Long-Term Prevention Plan. Keep the tone professional, factual, and solution-focused."
Nexus Vault
Need more than the free prompts?
Get 200 business prompts, instant download, and no subscription.
4. Data Quality Check Summary Writer
Summarizes data quality validation results: checks run, pass/fail rates, anomalies found, impacted tables, and recommended fixes.
Copy-paste prompt
"Write a data quality check summary report for the following validation run: [describe the checks you ran — e.g. null checks, referential integrity, range validation, duplicate detection]. Include: Summary of All Checks Run, Pass/Fail Rates by check type, Anomalies and Outliers Found with severity, Impacted Tables and Downstream Systems, Root Cause Assessment for each failure, and Recommended Fixes prioritized by business impact. Format as an internal engineering report."
5. Stakeholder Data Briefing Writer
Translates a complex data engineering initiative into a clear, non-technical stakeholder briefing covering what was built, why it matters, and what comes next.
Copy-paste prompt
"Write a stakeholder briefing for the following data engineering initiative: [describe the project — e.g. we migrated our data warehouse to a lakehouse architecture]. The audience is business stakeholders and senior leadership with no deep technical background. Cover: What Was Built and Why, Business Impact and Benefits, What Changed for End Users (dashboards, reports, data access), Current Status and What Comes Next, and Any Decisions or Input Needed from Stakeholders. Keep it concise — one page maximum — and avoid technical jargon."