Pack 329 · Data · 19 items
SQL Analysis Pack
17 prompts + 2 skills for SQL analysis and data quality — real jobs from the week, with the steps, rules and output an expert would ask for.
€6one-time · 19 prompts & skills · ≈ €0.32 each
- Instant download
- Yours to keep
- Works in ChatGPT, Claude, Gemini
What's inside
Made for SQL analysis and data quality
17 prompts + 2 skills- PromptBuild A Cohort Retention Analysis
Generates SQL and interpretation for a cohort retention matrix from event or subscription data.
- PromptCorrelation And Driver Analysis On A Table
Plans a sound correlation/driver analysis, computes it in SQL or pandas, and guards against spurious conclusions.
- PromptData Quality Audit Query Suite
Generates a battery of SQL checks to surface nulls, duplicates, referential breaks, and anomalies in a table.
- PromptDebug A SQL Query That Returns Wrong Results
Systematically finds the logic error producing incorrect numbers and delivers a corrected, verified query.
- PromptDeduplicate Records With Confidence Rules
Identifies and collapses duplicate or near-duplicate rows using deterministic and fuzzy rules in SQL.
- PromptDesign A Star Schema For Analytics
Produces a dimensional model with fact and dimension tables, grain, keys, and SCD strategy for a reporting need.
- PromptDesign An A/B Test Analysis
Specifies the statistical analysis for an experiment, including SQL for metrics and significance interpretation.
- PromptDesign Indexes For A Query Workload
Recommends a minimal, high-impact index set for a set of queries with column order and covering rationale.
- PromptExplain An Unfamiliar SQL Query In Plain English
Reverse-engineers a complex inherited query into a clear narrative, business meaning, and risk list.
- PromptExploratory Data Analysis Plan And Code
Produces a structured EDA plan plus pandas/SQL code to profile a new dataset before modeling.
- PromptGenerate Realistic Synthetic Test Data
Designs schema-aware synthetic data with realistic distributions and referential integrity for testing analytics.
- PromptOptimize A Slow SQL Query
Diagnoses why a query is slow and rewrites it with targeted, explained optimizations and an index plan.
- PromptRefactor Nested Subqueries Into Clean CTEs
Restructures a tangled query into readable, named CTEs without changing results, and documents each step.
- PromptRFM Customer Segmentation
Scores customers by Recency, Frequency, and Monetary value into actionable segments with SQL.
- PromptSQL Interview Coaching With Worked Solutions
Solves a SQL challenge as a teaching session, showing the thought process, solution, and common traps.
- PromptTranslate Pandas To SQL And Back
Converts a data transformation faithfully between pandas and SQL while preserving exact semantics.
- PromptWrite An Executive Summary From A Dataset
Turns analytical findings into a crisp, decision-oriented executive summary with caveats and next steps.
- SkillData Quality & Observability Auditor
Designs data quality checks and observability across freshness, volume, schema, and distribution.
- SkillSQL Query Optimizer & Cost Reducer
Rewrites slow or expensive SQL into efficient, warehouse-aware queries with explained tradeoffs.
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
sql-analysis/ ├─ 00-GIVE-THIS-TO-YOUR-AI.md ├─ START-HERE.md ├─ TIPS-AND-FOLLOW-UPS.md ├─ AI-CHEAT-SHEET.md ├─ prompts/ │ ├─ 01-build-a-cohort-retention-analysis.md │ ├─ 02-correlation-and-driver-analysis-on-a-table.md │ ├─ 03-data-quality-audit-query-suite.md │ ├─ 04-debug-a-sql-query-that-returns-wrong-results.md │ ├─ 05-deduplicate-records-with-confidence-rules.md │ ├─ 06-design-a-star-schema-for-analytics.md │ ├─ 07-design-an-ab-test-analysis.md │ ├─ 08-design-indexes-for-a-query-workload.md │ ├─ 09-explain-an-unfamiliar-sql-query-in-plain-english.md │ ├─ 10-exploratory-data-analysis-plan-and-code.md │ ├─ 11-generate-realistic-synthetic-test-data.md │ ├─ 12-optimize-a-slow-sql-query.md │ ├─ 13-refactor-nested-subqueries-into-clean-ctes.md │ ├─ 14-rfm-customer-segmentation.md │ ├─ 15-sql-interview-coaching-with-worked-solutions.md │ ├─ 16-translate-pandas-to-sql-and-back.md │ └─ 17-write-an-executive-summary-from-a-dataset.md └─ skills/ ├─ data-quality-observability-auditor/SKILL.md └─ sql-query-optimizer-cost-reducer/SKILL.md
A look inside
ROLE: You are a product analyst who builds retention and cohort analyses. CONTEXT: We want to measure how [COHORT_DEFINITION] (e.g., users who signed up in a given month) …
Questions
What do I get?
A .zip with 17 prompts + 2 skills for SQL analysis and data quality: each prompt as a ready .md file, each skill as 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. €6 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?
Packs are priced by what they hold: €0.50 a prompt and €1 a skill. This one is €6, about €0.32 an item.