Prompt file imported from nelsontraintest/Copilot_LnD_sql_app (
.github/prompts/artifacts.prompt.md). Copyright stays with the author.
/artifacts — self-contained HTML
Deliver the answer as a single HTML file the user can open locally — not only as a chat table or markdown dump.
Do this
- Finish the underlying task first using real data from the repo. Do not invent numbers.
- Write one self-contained
.htmlfile (inline CSS; preferworkshop-trace/out/in this workshop repo). - Make it scannable: clear title, short subtitle, main visual, one-line verdict.
- Print the file path and remind the user to open it in a browser.
- Keep chat short — the HTML is the deliverable.
Design
- One composition, not a dashboard of cards.
- No purple gradient themes, no emoji decoration, no floating badges.
- Label mock-up / training data when figures come from workshop CSVs.
Demo 1.5 Prompt 3
If comparing SQL vs pandas Top 5 on the golden CSV:
python workshop-trace/python/run_top5_sql.py
python workshop-trace/python/top5_patterns.py
Write side-by-side tables + PASS/FAIL to workshop-trace/out/demo15_top5_compare.html.
Do not run Path A via bare sqlite3 … < top5_patterns.sql.