Journey Schema

Third stage of the Butterbase journey that takes your table definitions from the plan doc and pushes them live. It calls schema-design to build the declarative schema, shows you a dry-run diff via manage_schema, then applies it after you approve. If you're in hackathon mode it also folds in the RLS step inline so you can move faster. Logs everything to build-log.md and updates state.md with checkboxes. The main guardrail here is that you always see the diff before anything destructive happens, which matters because drops require explicit confirmation. Use this when journey orchestrates to the schema stage or call it directly if you know your preflight is fresh.

GitHub stars: 532
last updated: Jun 11, 2026

View on GitHub

Install

$ npx -y skills add butterbase-ai/butterbase-skills --skill journey-schema --agent claude-code

Installs into .claude/skills of the current project.

Files

Journey: Schema

Stage 3a of the guided journey. Apply the declarative table definitions from the plan.

When to use

Dispatched by journey when current_stage: schema.
Directly via /butterbase-skills:journey-schema.

Preflight

If docs/butterbase/03-preflight.md is missing, older than 24 hours, or 00-state.md has app_id: null, invoke butterbase-skills:journey-preflight first. Wait for it to return successfully before proceeding.

Inputs

docs/butterbase/02-plan.md — the Tables section.
docs/butterbase/00-state.md — for app_id, hackathon_mode.

Procedure

Refresh docs. Call butterbase_docs with topic: "schema". If the plan calls for advanced schema features (vectors, partial indexes, generated columns), also WebFetch https://docs.butterbase.ai/schema. Skip this step if docs/butterbase/03b-docs-cache.md was written less than 30 minutes ago and already covers schema.

SKILL.md on GitHub