# Load Quests

> Load Quest Data

- Skill: `pipecat-ai/load-quests` (Agent Skill)
- Install (CLI): `npx skillmds@latest add pipecat-ai/load-quests`
- Raw SKILL.md: https://api.skillmd.com/api/skills/pipecat-ai/load-quests/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: pipecat-ai (https://skillmd.com/u/pipecat-ai)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/pipecat-ai/load-quests

---

# Load Quest Data

Loads quest definitions from `GRADIENTBANG_QUEST_DATA_DIR` (`data/quests/` by default) into Supabase.

## Parameters

Ask the user for:
- **Mode**: `upsert` (default) or `force` (deletes all existing quest data first)
- **Dry run**: whether to validate only without writing (default: no)

## Steps

### 1. Source environment variables

```bash
set -a && source .env.supabase && set +a
```

### 2. Run the quest loader

Upsert mode (default — updates existing quests, inserts new ones):
```bash
uv run -m gradientbang.scripts.load_quests_to_supabase
```

Force mode (wipes all quest definitions and reloads from scratch):
```bash
uv run -m gradientbang.scripts.load_quests_to_supabase --force
```

Dry run (validate JSON files without writing to database):
```bash
uv run -m gradientbang.scripts.load_quests_to_supabase --dry-run
```

### 3. Verify

Confirm the output shows "Success!" and check the stats summary for expected quest/step/subscription counts.

## Important notes

- Each `.json` file in `GRADIENTBANG_QUEST_DATA_DIR` represents one quest chain. The loader picks up all `*.json` files in the directory.
- The loader upserts by quest `code`, so it's safe to re-run after editing quest data.
- `--force` deletes ALL quest definitions (cascades to steps and subscriptions) before reloading. Player quest progress (`player_quests`, `player_quest_steps`) is NOT affected — but orphaned progress rows will reference deleted step IDs.
- If you get a PostgREST schema cache error, run: `docker exec supabase_db_gb-world-server psql -U postgres -d postgres -c "NOTIFY pgrst, 'reload schema'"` then retry.