agents
Use when designing, deploying, or debugging a Butterbase Agent (declarative LLM/tool graph), registering an MCP server for tool…
@butterbase-aiInstall SkillDevelopment
Skill
/journey-schema
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,
Claude Code
$ npx -y skills add butterbase-ai/butterbase-skills --skill journey-schema --agent claude-code
Codex
$ npx skills add butterbase-ai/butterbase-skills --skill journey-schema -a codex -y
Cursor
$ npx skills add butterbase-ai/butterbase-skills --skill journey-schema -a cursor -y
Gemini CLI
$ npx skills add butterbase-ai/butterbase-skills --skill journey-schema -a gemini-cli -y
GitHub Copilot
$ npx skills add butterbase-ai/butterbase-skills --skill journey-schema -a github-copilot -y
OpenCode
$ npx skills add butterbase-ai/butterbase-skills --skill journey-schema -a opencode -y
Windsurf
$ npx skills add butterbase-ai/butterbase-skills --skill journey-schema -a windsurf -y
SKILL.md
journey-schema.SKILL.mdname: journey-schema
description: 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, also folds in the RLS stage by invoking journey-rls inline before returning.
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
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`.
1. Read the Tables section of `02-plan.md`. Print it back: `"About to apply schema: <N tables>. Proceed?"`. Wait for `yes`. 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. 3. After it returns, optionally run a sanity `manage_schema action: get` and show the user the live shape. 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. 5. Append one line to `docs/butterbase/04-build-log.md` (create if absent): `<ISO timestamp> schema manage_schema ok` 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`. 7. Return to `journey` orchestrator (or, if invoked directly, ask: `"Continue to the next stage? (yes/no)"`).
Outputs
- Live schema in the Butterbase app.
- One line in `04-build-log.md`.
- Updated `00-state.md`.
Anti-patterns
- ❌ Calling `manage_schema action: apply` without showing the user the dry-run diff.
- ❌ Forgetting `_drop:` / `_dropColumns:` are needed for destructive changes — never set them without explicit user confirmation.
- ❌ Forgetting the hackathon-mode RLS fold.
Read more
name: journey-schema description: 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, also folds in the RLS stage by invoking journey-rls inline before returning.
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
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`.
1. Read the Tables section of `02-plan.md`. Print it back: `"About to apply schema: <N tables>. Proceed?"`. Wait for `yes`. 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. 3. After it returns, optionally run a sanity `manage_schema action: get` and show the user the live shape. 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. 5. Append one line to `docs/butterbase/04-build-log.md` (create if absent): `<ISO timestamp> schema manage_schema ok` 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`. 7. Return to `journey` orchestrator (or, if invoked directly, ask: `"Continue to the next stage? (yes/no)"`).
Outputs
- Live schema in the Butterbase app.
- One line in `04-build-log.md`.
- Updated `00-state.md`.
Anti-patterns
- ❌ Calling `manage_schema action: apply` without showing the user the dry-run diff.
- ❌ Forgetting `_drop:` / `_dropColumns:` are needed for destructive changes — never set them without explicit user confirmation.
- ❌ Forgetting the hackathon-mode RLS fold.
Stats
536
Stars
42
Forks
Active
Maintenance
MIT
License
Last commit
Created
Ships withbutterbase-skills
Claude Code plugin for Butterbase — the AI-Native Backend-as-a-Service. This plugin gives Claude deep knowledge of Butterbase's nearly 40 MCP tools, guides you through common workflows, and auto-configures the MCP server connection.
53639 skills1 MCP
Stars on GitHub
Momentum
- stars in total
- 536
Other skills on butterbase-skills.
@butterbase-aiInstall Skillai
Use when calling the app's AI gateway from agent tools — chat completions, embeddings, listing models, configuring defaults or…
@butterbase-aiInstall Skillauth-setup
Use when configuring OAuth providers (Google/GitHub/Apple/X/etc.), setting up post-login auth hooks, tuning JWT lifetimes, or…
@butterbase-aiInstall Skillbuild-app
Use when building a new Butterbase app from scratch, creating a full-stack application, or when the user asks to set up a…
@butterbase-aiInstall Skillcontributing
Use when contributing to the Butterbase codebase, adding new MCP tools, creating API routes, writing migrations, or understanding…
@butterbase-aiInstall Skilldebug-rls
Use when users report access denied errors, see wrong data, RLS policies are not working, or when troubleshooting Row-Level…
@butterbase-aiInstall SkillMore skills from other plugins.
Auto-invoked
brainstorming
You MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or…
@obraInstall Skillask-matt
Ask which skill or flow fits your situation. A router over the skills in this repo.
@mattpocockInstall SkillAuto-invoked
Questions about journey-schema.
- Which coding agents can use journey-schema?
- journey-schema installs in Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, OpenCode and Windsurf with the skills CLI, using each agent's flag shown on this page. Flowy's auto-invocation, which fires a skill when your prompt matches, runs in Claude Code only.