ctf-new-session

Update DuckDB SQL CTF session dates, locations, and derived documents.

1|Updated Nov 13, 2025
One-click install
npx skills add https://github.com/Jeremynadal33/duckdb-sql-ctf --skill ctf-new-session
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ctf-new-session
Source: https://github.com/Jeremynadal33/duckdb-sql-ctf/tree/main/.claude/skills/ctf-new-session
Command: npx skills add https://github.com/Jeremynadal33/duckdb-sql-ctf --skill ctf-new-session

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill prevents errors during between-session updates by safely recalculating the CTF date and locations, regenerating all derived artifacts, and redeploying the leaderboard-backed infrastructure in the correct order.

Core Features & Use Cases

  • Minimizes file changes by updating only the session-specific constants and the journal tied to the derived Quackie death date.
  • Keeps frontend and infra consistent by regenerating map location data and updating the hardcoded API gateway URL from Terraform outputs.
  • Runs end-to-end correctness checks by regenerating scenario data, validating the scenario 3 flag, and executing solve-all to detect desynchronization before publishing.

Quick Start

Tell the user the exact CTF date, the precise CTF city address, and whether you want to archive the previous session snapshot before the Skill regenerates, redeploys, and produces the new journal and flags.

Frequently Asked Questions about ctf-new-session

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I update DuckDB SQL CTF session dates and locations without breaking infrastructure?

To update a DuckDB SQL CTF session, modify session-specific constants and the journal, regenerate map assets, run generator and test commands, and coordinate Terraform apply without destroying resources to keep infra and frontend in sync.

How do I regenerate CTF leaderboard and session data for a new event date?

Regenerate CTF leaderboard and session data by updating the CTF date and venue in repository files, running generator commands to rebuild derived artifacts, and redeploying the leaderboard-backed infrastructure with updated S3 snapshots.

What's needed to reconfigure geocoding and frontend deployment for a new CTF venue?

Reconfiguring geocoding and frontend deployment requires the precise CTF city address, updating map location data assets, and modifying the hardcoded agent API gateway URL from Terraform outputs to ensure frontend consistency.

Why does my CTF session redeployment fail with desynchronized flags?

CTF session redeployment fails with desynchronized flags when derived documents are stale; run the solve-all command and validate the scenario 3 flag after regenerating scenario data to detect and prevent synchronization errors.

Can I archive previous CTF session snapshots in S3 before regenerating new ones?

Yes, you can archive previous CTF session snapshots in S3 before regenerating new ones; provide the CTF date, venue, and optionally a decoy override to trigger S3 snapshot and history handling during the redeployment process.