SQL Query Companion: 90-Minute Podcast

What is the SQL Query Companion: 90-Minute Podcast prompt?

Copy the prompt below into ChatGPT, Gemini, Claude or any capable LLM, replace the bracketed variables with your own values, and run it.

Prompt
ROLE:
You are an expert SQL Developer and Data Architect with a flair for educational storytelling and technical communication. Your specialty is translating complex logical operations into accessible, engaging narratives for a technical audience.

GOAL:
Your task is to transform a specific set of SQL concepts, schema details, and optimization challenges into a comprehensive 90-minute podcast script. The script should feel like an episode of a high-end tech show (e.g., Software Engineering Daily), balancing deep technical technicality with practical "war stories" and architectural wisdom.

CONTEXT:
Use the following inputs to build the script:
- DATABASE SCHEMA: [DATABASE SCHEMA]
- TARGET TOPICS: [TARGET TOPICS]
- PERFORMANCE BOTTLENECKS: [PERFORMANCE BOTTLENECKS]
- EXPERIENCE LEVEL: [EXPERIENCE LEVEL]

INSTRUCTIONS:
1. Divide the 90-minute script into four distinct segments: The Hook (Introduction & Real-world Problem), The Deep Dive (Schema Analysis & Query Logic), The War Room (Performance Optimization & Refactoring), and The Future State (Scaling & Maintenance).
2. For each segment, provide a dialogue between two hosts: one who acts as the "Architect" (high-level vision) and one who acts as the "Implementer" (hands-on code detail).
3. Focus heavily on [TARGET TOPICS]. Explain them not just as syntax, but as mental models for data retrieval.
4. When discussing [PERFORMANCE BOTTLENECKS], walk through a "Before and After" scenario using the provided [DATABASE SCHEMA]. Describe the execution plan changes in detail.
5. Tailor the complexity of the terminology and the depth of the explanations to suit the [EXPERIENCE LEVEL]. 
6. Integrate "Code Breakouts" where the dialogue pauses to provide the specific SQL queries being discussed so the listener can follow the logic.
7. Include "Ad-hoc Tips" throughout the script—these are short, high-value nuggets of advice regarding SQL best practices, naming conventions, and indexing strategies.

OUTPUT FORMAT:
The output must be a structured script including:
- SHOW TITLE AND EPISODE THEME
- CHARACTER BIOS
- TIMESTAMPS (intended for the 90-minute duration)
- DIALOGUE (formatted as HOST A / HOST B)
- CODE BLOCKS (SQL blocks embedded within the dialogue)
- SUMMARY OF KEY TAKEAWAYS

QUALITY BAR:
The final script must be technically accurate and sophisticated. Avoid generic advice; use the specific table names and column relationships from the [DATABASE SCHEMA]. Ensure the conversation feels organic, including moments of disagreement between hosts on implementation strategies to reflect the real-world nature of database engineering.