VibeRPGSimulator

Why did sign-ups drop?

Quest: Find out why sign-ups fell last week using PostHog and a local data export

Proposed, not tested

Equipment

Alchemist Claude Code
Quest
Find out why sign-ups fell last week using PostHog and a local data export
Hero
Claude CodeThe agent that runs the quest
Class
Alchemist · Data analysis
Weapon
Claude Sonnet 5.5Longsword: Balanced speed and depthMana rate 10 per 1k tokens Mana per run without spells: 1,049 mana (293 runs, 22 quests).
Charge
MediumReasoning effort
Author
The curator

PostHog shows the funnel and recent errors, DuckDB loads the exported file and queries it locally, and the Data plugin charts the answer and runs its validation pass before you share it.

Can't be appraised: Proving Grounds can't equip orbs (MCP servers).

Skill tree

  1. ScoutGather context

  2. CraftMake the thing

  3. TestCheck the work

    Nothing equipped here

  4. ShipDeliver it

    Nothing equipped here

Quest replay

Quest: "Find out why sign-ups fell last week using PostHog and a local data export". Four waves, then the Backlog Dragon.

Foes

  • Fog Wraith

Party · Context

  • Claude CodeAlchemist100/100

  1. Wave 1 of 4 · Scout

    The Fog Wraith steps up.

    What really happensGather context

    Claude Code: Context 100/100.

  2. Explore

    Claude Code sends Explore, a fox scout, into the fog.

    What really happensClaude Code can hand a codebase search to its built-in Explore subagent, which works in its own context window.

    Explore: Context 40/40.

  3. Explore

    Explore sniffs out the right files.

    What really happensThe subagent reads and searches. None of that output lands in the main context.

    Fog Wraith takes 21.

  4. PostHog

    A watchtower that answers product questions from PostHog.

    What really happensThe agent queries insights in plain words, such as sign-ups this week or the checkout funnel conversion rate.

    Fog Wraith takes 38.

  5. Haze

    The Fog Wraith breathes haze. Swings start to miss.

    What really happensWithout current docs, the agent guesses at APIs that may have changed.

    Explore takes 3. Explore: Context 37/40. Explore: Haze.

  6. Explore

    Explore sniffs out the right files.

    Fog Wraith takes 0.

  7. DuckDB / MotherDuck MCP

    A pocket duck engine that runs SQL on your local data.

    What really happenslist_databases, list_tables and list_columns show what is attached before any query runs.

    Fog Wraith takes 1. Fog Wraith falls.

  8. Haze cleared

    Fresh pages burn the haze away.

    What really happensCurrent docs replace guesses with facts.

  9. Explore

    Explore returns with a short report.

    What really happensOnly the subagent's final summary comes back to the main agent.

    Claude Code takes 2. Claude Code: Context 98/100. Claude Code: Insight. Explore returns.

  10. Wave 2 of 4 · Craft

    The Riddle Sphinx steps up.

    What really happensMake the thing

  11. Anthropic Data

    A satchel of analyst scrolls for questions your tables can answer.

    What really happensexplore-data profiles a table: row counts, nulls, cardinality and odd values worth a closer look.

    Riddle Sphinx takes 55 (critical hit).

  12. Riddle

    The sphinx asks a riddle. A wrong guess costs dearly.

    What really happensAn answer guessed from a hunch instead of a query sends the work the wrong way.

    Claude Code takes 6. Claude Code: Context 92/100.

  13. Longsword

    Claude Code swings the Longsword.

    Riddle Sphinx takes 45 (critical hit). Riddle Sphinx falls.

  14. Wave 3 of 4 · Test

    The Bug Slime and the Flaky Wisp step up.

    What really happensCheck the work

    Flaky Wisp: Flicker.

  15. Longsword

    The wisp flickers out of reach.

    What really happensA flaky test passes on one run and fails on the next.

    Flaky Wisp avoids the hit.

  16. Flicker

    The Flaky Wisp uses Flicker.

    Claude Code takes 3. Claude Code: Context 89/100.

  17. Regress

    The Bug Slime uses Regress.

    Claude Code takes 3. Claude Code: Context 86/100.

  18. Longsword

    Claude Code swings the Longsword.

    Flaky Wisp takes 40. Flaky Wisp falls.

  19. Regress

    The Bug Slime uses Regress.

    Claude Code takes 3. Claude Code: Context 83/100.

  20. Longsword

    Claude Code swings the Longsword.

    Bug Slime takes 40.

  21. Regress

    The slime splits. A squashed bug crawls back.

    What really happensA fix in one place breaks something that used to work.

  22. Longsword

    Claude Code swings the Longsword.

    Bug Slime takes 5. Bug Slime falls.

  23. Regress

    The Bug Slime uses Regress.

    Claude Code takes 3. Claude Code: Context 80/100.

  24. Longsword

    Claude Code swings the Longsword.

    Bug Slime takes 18. Bug Slime falls.

  25. Wave 4 of 4 · Ship

    The Gate Warden steps up.

    What really happensDeliver it

    Gate Warden: Barrier.

  26. Boss · Backlog Dragon

    The Backlog Dragon guards the quest: "Find out why sign-ups fell last week using PostHog and a local data export".

    What really happensIt stands for the whole quest, every task on the list.

  27. Longsword

    Claude Code swings the Longsword.

    Gate Warden is behind a barrier.

  28. Scope creep

    The dragon breathes scope creep across the party.

    What really happensNew asks pile onto a task while it is underway.

    Claude Code takes 5. Claude Code: Context 75/100.

  29. Bar the gate

    The warden raises the gate. Nothing passes until the checks are green.

    What really happensA release waits until tests, builds and reviews pass.

  30. Longsword

    Claude Code swings the Longsword.

    Gate Warden is behind a barrier.

  31. Claw

    The Backlog Dragon uses Claw.

    Claude Code takes 6. Claude Code: Context 69/100.

  32. Longsword

    Claude Code swings the Longsword.

    Gate Warden takes 40.

  33. Gate open

    The checks turn green and the gate opens.

    What really happensTests, build and review pass, so the release can go.

  34. Bar the gate

    The Gate Warden swings the gate shut.

    Claude Code takes 5. Claude Code: Context 64/100.

  35. Scope creep

    The Backlog Dragon uses Scope creep.

    Claude Code takes 5. Claude Code: Context 59/100.

  36. Longsword

    Claude Code swings the Longsword.

    Gate Warden takes 20. Gate Warden falls.

  37. Longsword

    Claude Code swings the Longsword.

    Backlog Dragon takes 36.

  38. Claw

    The Backlog Dragon uses Claw.

    Claude Code takes 6. Claude Code: Context 53/100.

  39. Longsword

    Claude Code swings the Longsword.

    Backlog Dragon takes 41.

  40. Scope creep

    The Backlog Dragon uses Scope creep.

    Claude Code takes 5. Claude Code: Context 48/100.

  41. Longsword

    Claude Code swings the Longsword.

    Backlog Dragon takes 40.

  42. Call the backlog

    The dragon roars, and another task crawls out of the backlog.

    What really happensFinishing one task often surfaces the next one on the list.

  43. Longsword

    Claude Code swings the Longsword.

    Bug Slime takes 25. Bug Slime falls.

  44. Scope creep

    The Backlog Dragon uses Scope creep.

    Claude Code takes 5. Claude Code: Context 43/100.

  45. Longsword

    Claude Code swings the Longsword.

    Backlog Dragon takes 38.

  46. Enraged

    Wounded, the dragon rages.

    What really happensThe last stretch of a big job is often the hardest.

    Backlog Dragon: Enraged.

  47. Longsword

    Claude Code swings the Longsword.

    Backlog Dragon takes 42.

  48. Claw

    The Backlog Dragon uses Claw.

    Claude Code takes 8. Claude Code: Context 35/100.

  49. Longsword

    Claude Code swings the Longsword.

    Backlog Dragon takes 23. Backlog Dragon falls.

  50. Quest clear

    The Backlog Dragon falls. Quest complete.

    What really happensEvery equipped spell did its part of "Find out why sign-ups fell last week using PostHog and a local data export".

After the battle

  • Claude Code took 20 turns to clear four waves.
  • Context ended at 35 of 100.
  • No Ship spell, so that wave ran on basic attacks.
  • No Test spell, so a regression slipped back in.
  • Summons took 3 damage in their own context and brought back 1 report.

Copy this loadout

Prompt for Claude Code

Paste this into Claude Code. It installs each spell, leaves API keys and sign-ins to you, and ends with the command that restarts it with this weapon and charge.

Set up these tools for me in Claude Code.
Loadout: https://vibe-rpg-simulator.vercel.app/loadouts/signup-drop-analysis/

1. PostHog
   Source: https://github.com/PostHog/ai-plugin
   Run:
     claude plugin install posthog

2. DuckDB / MotherDuck MCP
   Source: https://github.com/motherduckdb/mcp-server-motherduck
   Run:
     claude mcp add --scope user duckdb --transport stdio -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases

3. Anthropic Data
   Source: https://github.com/anthropics/knowledge-work-plugins/tree/main/data
   Run:
     claude plugin marketplace add anthropics/knowledge-work-plugins
     claude plugin install data@knowledge-work-plugins

How to do it:
- Skip anything that is already installed. Run the rest in order and check that each step worked.
- Never ask me to paste an API key or token into this chat. When a command needs one, such as YOUR_API_KEY, give me the full command to run in my own terminal.
- Ask me for any other value you can't work out, such as a project path.
- If a command asks a question or needs a browser sign-in or an open app, tell me what to do and wait.
- If a command fails, follow the install steps in the tool's source for Claude Code instead. Show me any command that is not on this list before you run it, and install nothing else.

When you're done, tell me what is ready and what still needs me. New tools load in a new session, so finish by telling me to restart Claude Code with Claude Sonnet 5.5 and reasoning effort medium:
claude --model sonnet --effort medium

Terminal commands

Or paste these lines into a terminal. The first part installs every spell for Claude Code; the last line starts it with the same weapon and charge. Lines starting with # are notes or commands you type inside the agent.

# Loadout: Why did sign-ups drop?
# Quest: Find out why sign-ups fell last week using PostHog and a local data export
# Hero: Claude Code · Weapon: Claude Sonnet 5.5 · Charge: Medium
# From https://vibe-rpg-simulator.vercel.app/loadouts/signup-drop-analysis/

# 1. Learn the spells
# Scout: PostHog
claude plugin install posthog
# Scout: DuckDB / MotherDuck MCP
claude mcp add --scope user duckdb --transport stdio -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases
# Craft: Anthropic Data
claude plugin marketplace add anthropics/knowledge-work-plugins
claude plugin install data@knowledge-work-plugins

# 2. Start the hero with this weapon and charge
claude --model sonnet --effort medium

Edit a copy