journey-schema

Name: journey-schema
Author: butterbase-ai

533stars40forks

How to install journey-schema?

butterbase-ai/butterbase-skills/journey-schema

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

Installs into the current project.

Summary

Use as the schema build stage of the Butterbase journey, after journey-plan and journey-preflight. Implements the Tables section of 02-plan.md by delegating to schema-design, previewing the diff (manage_schema dry_run) and applying it (manage_schema apply). In hackathon_mode, als

Files · 1

View on GitHub

SKILL.md

1	# Journey: Schema
2
3	Stage 3a of the guided journey. Apply the declarative table definitions from the plan.
4
5	## When to use
6
7	- Dispatched by `journey` when `current_stage: schema`.
8	- Directly via `/butterbase-skills:journey-schema`.
9
10	## Preflight
11
12	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.
13
14	## Inputs
15
16	- `docs/butterbase/02-plan.md` — the Tables section.
17	- `docs/butterbase/00-state.md` — for `app_id`, `hackathon_mode`.
18
19	## Procedure
20
21	0. 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`.
22
23	1. Read the Tables section of `02-plan.md`. Print it back: `"About to apply schema: <N tables>. Proceed?"`. Wait for `yes`.
24	2. Invoke `butterbase-skills:schema-design` via the Skill tool, passing the Tables section and `app_id`. The wrapped skill will build the declarative schema, dry-run it with `manage_schema action: dry_run`, then apply with `action: apply` after user approval of the diff.
25	3. After it returns, optionally run a sanity `manage_schema action: get` and show the user the live shape.
26	4. Hackathon mode only: if `00-state.md` has `hackathon_mode: true`, also invoke `butterbase-skills:journey-rls` inline now. After it returns, mark the rls checkbox as `(folded)` in `00-state.md` rather than leaving it unchecked.
27	5. Append one line to `docs/butterbase/04-build-log.md` (create if absent):
28	`<ISO timestamp> schema manage_schema ok`
29	6. Tick `- [x] schema` in `00-state.md`, set `current_stage:` to the next unchecked stage (typically `rls` outside hackathon mode, otherwise the stage after rls), bump `last_updated`.
30	7. Return to `journey` orchestrator (or, if invoked directly, ask: `"Continue to the next stage? (yes/no)"`).
31
32	## Outputs
33
34	- Live schema in the Butterbase app.
35	- One line in `04-build-log.md`.
36	- Updated `00-state.md`.
37
38	## Anti-patterns
39
40	- ❌ Calling `manage_schema action: apply` without showing the user the dry-run diff.
41	- ❌ Forgetting `_drop:` / `_dropColumns:` are needed for destructive changes — never set them without explicit user confirmation.
42	- ❌ Forgetting the hackathon-mode RLS fold.

People who liked this also viewed

6 picks

Type

journey-schema

533stars40forks

View on GitHub

How to install journey-schema?

butterbase-ai/butterbase-skills/journey-schema

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

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# Journey: Schema
2
3	Stage 3a of the guided journey. Apply the declarative table definitions from the plan.
4
5	## When to use
6
7	- Dispatched by `journey` when `current_stage: schema`.
8	- Directly via `/butterbase-skills:journey-schema`.
9
10	## Preflight
11
12	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.
13
14	## Inputs
15
16	- `docs/butterbase/02-plan.md` — the Tables section.
17	- `docs/butterbase/00-state.md` — for `app_id`, `hackathon_mode`.
18
19	## Procedure
20
21	0. 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`.
22
23	1. Read the Tables section of `02-plan.md`. Print it back: `"About to apply schema: <N tables>. Proceed?"`. Wait for `yes`.
24	2. Invoke `butterbase-skills:schema-design` via the Skill tool, passing the Tables section and `app_id`. The wrapped skill will build the declarative schema, dry-run it with `manage_schema action: dry_run`, then apply with `action: apply` after user approval of the diff.
25	3. After it returns, optionally run a sanity `manage_schema action: get` and show the user the live shape.
26	4. Hackathon mode only: if `00-state.md` has `hackathon_mode: true`, also invoke `butterbase-skills:journey-rls` inline now. After it returns, mark the rls checkbox as `(folded)` in `00-state.md` rather than leaving it unchecked.
27	5. Append one line to `docs/butterbase/04-build-log.md` (create if absent):
28	`<ISO timestamp> schema manage_schema ok`
29	6. Tick `- [x] schema` in `00-state.md`, set `current_stage:` to the next unchecked stage (typically `rls` outside hackathon mode, otherwise the stage after rls), bump `last_updated`.
30	7. Return to `journey` orchestrator (or, if invoked directly, ask: `"Continue to the next stage? (yes/no)"`).
31
32	## Outputs
33
34	- Live schema in the Butterbase app.
35	- One line in `04-build-log.md`.
36	- Updated `00-state.md`.
37
38	## Anti-patterns
39
40	- ❌ Calling `manage_schema action: apply` without showing the user the dry-run diff.
41	- ❌ Forgetting `_drop:` / `_dropColumns:` are needed for destructive changes — never set them without explicit user confirmation.
42	- ❌ Forgetting the hackathon-mode RLS fold.

People who liked this also viewed

6 picks

Type