← Index7 entries · By Vocation
Section II · For the Data Engineer
Prompts for the Data Engineer
AI prompts for data engineers: SQL, schema design, pipeline docs, and data quality checks.
№ 019data
Write a SQL Query From a Business Question
Translate a business question into a clean, commented SQL query against your schema.
For
chatgpt·claude
№ 025coding
Build and Explain a Regular Expression
Get a working regex with a plain-English breakdown and a set of passing/failing test cases.
For
claude·chatgpt
№ 029coding
Design a Normalized Database Schema
Design a fully normalized relational database schema with DDL, indexes, and design rationale.
For
claude·chatgpt
№ 064data
Analyze a Dataset With Pandas Step-by-Step
Generate step-by-step Pandas EDA code covering nulls, outliers, and a business question.
For
claude·chatgpt
№ 066data
Write a Data Cleaning Script for Messy Data
Generate a step-by-step Pandas data cleaning script with issue detection and before/after summaries.
For
claude·chatgpt
№ 078data
Use SQL Window Functions for Advanced Analytics
Generate advanced SQL window function queries with explanations and performance notes.
For
claude·chatgpt
№ 096coding
Generate a Production-Ready Dockerfile and Explain Each Line
Generate a hardened, multi-stage Dockerfile with line-by-line comments and matching .dockerignore.
For
claude·chatgpt