Pack 324 · Developer stacks · 14 items
Data Engineering & dbt Pack
12 prompts + 2 skills for data and analytics engineers (dbt, Airflow, warehouses) — real jobs from the week, with the steps, rules and output an expert would ask for. 7 written for this work, 7 more from the library.
€4one-time · 14 prompts & skills · ≈ €0.29 each
- Instant download
- Yours to keep
- Works in ChatGPT, Claude, Gemini
What's inside
Made for data and analytics engineers (dbt, Airflow, warehouses)
6 prompts + 1 skill- Promptdbt Project Layering and Naming Standards
Sets up or cleans up a dbt project: staging, intermediate and mart layers, naming, sources, tests, documentation and ownership — so models stay understandable as the team grows.
- PromptAirflow (or Orchestrator) DAG Reliability Review
Reviews orchestration pipelines for idempotency, retries, backfills, dependencies, timeouts and alerting — and rewrites the riskiest DAG so reruns are safe.
- Promptdbt Incremental Model Design With Late-Arriving Data
Designs an incremental model that stays correct when data arrives late or is updated — unique keys, lookback windows, merge strategy, deletes and full-refresh safety.
- PromptData Quality Contracts and Monitoring for Key Tables
Defines data contracts between producers and the warehouse — schemas, freshness, volume and value checks — with alerts and owners, so broken data is caught before dashboards show it.
- PromptData Warehouse Cost Optimisation Review
Finds where warehouse spend goes — expensive queries, oversized compute, full scans, unused tables, runaway schedules — and ranks savings by effort and risk.
- PromptDimensional Model for a Business Process — Facts, Dimensions and Grain
Designs a star schema for one business process (orders, subscriptions, support tickets) — grain, fact tables, dimensions, slowly changing attributes and the metrics it must answer.
- SkillAnalytics Engineering Lead
A standing analytics engineering lead: dbt structure, incremental models, orchestration, data quality, dimensional design and warehouse cost — correct first, documented, tested and owned.
Bonus prompts & skills
6 prompts + 1 skill · free with the packFrom the wider PromptCorrectly library, picked for the same work. They come in the same .zip and the start file tells your AI when to use each one.
- SkillExploratory Data Analysis Strategist
Produces a structured EDA plan and narrative findings for any new dataset before modeling.
Library · Free account - PromptData-Pipeline Orchestration Agent Runbook
Operates an agent that runs a multi-stage data pipeline with validation gates, idempotency, and quarantine for bad records.
Library · In a pack - PromptData Quality Monitoring Dashboard Spec
Specifies a data-quality dashboard tracking freshness, completeness, validity, and anomaly checks per pipeline.
Library · In a pack - PromptTranslate Business Questions Into SQL
Turns a plain-English stakeholder question into a correct, well-commented SQL query against a known schema.
Library · Free - PromptRoot-Cause A Metric Spike Or Drop
Drives a systematic decomposition to explain why a metric moved, with SQL to test each hypothesis.
Library · In a pack - PromptSQL → English Explainer
Translate any SQL query into bullets that an analyst can act on.
Library · Free - PromptKPI Dashboard Design & Metric Tree
Designs a focused KPI framework with a metric tree linking a north-star goal to leading and operational drivers.
Library · Free
What you download
Everything comes in one pack (.zip) you keep. Start with 00-GIVE-THIS-TO-YOUR-AI.md: paste it into your AI and it knows which file to use for which job, and what to ask you first.
More for Data Analysis & Excel · Developers
data-engineering-dbt-airflow/ ├─ 00-GIVE-THIS-TO-YOUR-AI.md ├─ START-HERE.md ├─ TIPS-AND-FOLLOW-UPS.md ├─ AI-CHEAT-SHEET.md ├─ prompts/ │ ├─ 01-dbt-project-layering-and-naming-standards.md │ ├─ 02-airflow-dag-reliability-review.md │ ├─ 03-dbt-incremental-model-design-and-late-data.md │ ├─ 04-data-quality-contracts-and-monitoring.md │ ├─ 05-warehouse-cost-optimisation-review.md │ ├─ 06-dimensional-model-for-a-business-process.md │ ├─ 07-data-pipeline-orchestration-agent-runbook.md │ ├─ 08-data-quality-monitoring-dashboard-spec.md │ ├─ 09-translate-business-questions-into-sql.md │ ├─ 10-root-cause-a-metric-spike-or-drop.md │ ├─ 11-flagship-sql-to-english.md │ └─ 12-kpi-dashboard-design-metric-tree.md └─ skills/ ├─ analytics-engineering-lead/SKILL.md └─ exploratory-data-analysis-strategist/SKILL.md
A look inside
ROLE: You are an analytics engineering lead who has inherited messy dbt projects with hundreds of models nobody can explain. You fix them with clear layers, strict naming, sources declared once, and tests on every primary key. CONTEXT: The warehouse and dbt version: …
Questions
What do I get?
A .zip with 12 prompts + 2 skills: 6 prompts + 1 skill written for data and analytics engineers (dbt, Airflow, warehouses), plus 6 prompts + 1 skill from the wider library that fit the same work. Each prompt is a ready .md file, each skill a SKILL.md folder, plus 00-GIVE-THIS-TO-YOUR-AI.md (a start file your AI reads first), START-HERE.md, TIPS-AND-FOLLOW-UPS.md (tips and the follow-up questions for every file) and the free AI cheat sheet.
How do I use it?
Open ChatGPT, Claude or Gemini and paste 00-GIVE-THIS-TO-YOUR-AI.md, or attach the folder. It asks a few questions about your work once, then picks the right file for each job and fills in the blanks.
Is it a subscription?
No. €4 once, and the files are yours to keep. Nothing renews.
How do I download it?
Right after checkout, on the confirmation page. Sign in later with the email you paid with and the download button waits for you on this page.
Why this price?
A pack is priced by the items written for its trade: €0.50 a prompt and €1 a skill. The 7 bonus items come free on top. This one is €4 for 14 prompts and skills, about €0.29 an item.