Agent skill

Eng Schema Migration

by compozy in compozy/compozy

Change Compozy SQLite tables, columns, indexes, constraints, triggers, or seed data under internal/store or internal/memory using append-only Goose migrations and owning generators.

MITAuto-check passedDatabases

Install Eng Schema Migration

skills CLI
$ npx skills add compozy/compozy --skill eng-schema-migration -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install compozy/compozy eng-schema-migration --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/compozy/compozy.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/eng/eng-schema-migration .claude/skills/eng-schema-migration && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
eng-schema-migration
GitHub stars
2.8k
Token cost
~809 tokens
SKILL.md length
393 words
Files
4 (incl. references)
Skills in repo
47
Repo updated
First seen
Licence
MIT

At a glance

Change Compozy SQLite tables, columns, indexes, constraints, triggers, or seed data under internal/store or internal/memory using append-only Goose migrations and owning generators.

  • Works in 7 steps: Read references/migration-decision.md… → Inspect the owner's declarative schema… → Read references/migration-template.md.… → …
  • Tasks that involve Database migrations
  • SKILL.md covers Procedure and Error Handling
  • Calls make

What it does

Eng Schema Migration is an agent skill from compozy/compozy. Change Compozy SQLite tables, columns, indexes, constraints, triggers, or seed data under internal/store or internal/memory using append-only Goose migrations and owning generators. Excludes in-memory structures, Markdown memory, and non-SQLite caches.

Its SKILL.md is about 810 tokens, which your agent loads only when the skill is triggered. The skill folder holds 4 other files, including reference files (for example `references/migration-decision.md`, `references/migration-template.md` and `references/migration-test-patterns.md`).

It sits in Databases, covering Database migrations and Test data and fixtures. It works with SQLite and SQL. The repository describes itself as: An operating system for AI agents. Plug in the agent CLIs you already use (Claude Code, Codex, Gemini CLI, Cursor) and they become a team: they split the work, hand tasks to each… The licence is MIT.

When your agent uses it

  • Tasks that involve Database migrations
  • Tasks that involve Test data and fixtures

Example prompts

  • “/eng-schema-migration”

Workflow steps

7 steps, taken from the first numbered list in SKILL.md.

  1. Read references/migration-decision.md and classify the changed datum and owning stream: global and memory share compozy.db; session owns…
  2. Inspect the owner's declarative schema source (schema/schema.sql or schema/definitions/*.sql), schema/migrations/…
  3. Read references/migration-template.md. Edit the owning declarative source, then run make codegen. Inspect the newly appended Goose SQL…
  4. Update affected static queries in the owning sqlc catalog. Keep generated sqlcgen types inside the owner package and map them to domain…
  5. Read references/migration-test-patterns.md. Run the canonical suites that own fresh apply, reopen/data preservation, ahead-version…
  6. If recovery or refusal guidance changes, move the whole stopped SQLite family (.db, -wal, -shm, and sibling databases) to cold storage…
  7. Run the owning scoped race-enabled migration checks and make codegen-check. Reuse their current evidence and the affected lint lane; root…

What it can do on your machine

Read from SKILL.md and the folder at commit c46be43. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • make

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Eng Schema Migration loads about 809 tokens when it runs, and up to ~2.3k if it reads all its reference files. Until then it costs about 68 tokens; SKILL.md has 393 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~68
When it runs · the whole SKILL.md, loaded when a task matches
~809
With references · SKILL.md plus every file in references/, read only if the agent opens them
~2.3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from compozy/compozy at commit c46be43, republished under its MIT licence (© compozy). 393 words, ~809 tokens.

Download SKILL.mdSave it as .claude/skills/eng-schema-migration/SKILL.md (or your agent's skills folder). This skill also uses 3 other files; get the full folder from GitHub.
name
eng-schema-migration
description
Change Compozy SQLite tables, columns, indexes, constraints, triggers, or seed data under internal/store or internal/memory using append-only Goose migrations and owning generators. Excludes in-memory structures, Markdown memory, and non-SQLite caches.
trigger
implicit

Compozy Schema Migration

Procedure

  1. Read references/migration-decision.md and classify the changed datum and owning stream: global and memory share compozy.db; session owns each events.db; workspace owns workspace observability databases.
  2. Inspect the owner's declarative schema source (schema/schema.sql or schema/definitions/*.sql), schema/migrations/, schema/migrations/atlas.sum, migration_stream.go, sqlc query catalog, and canonical migration/open tests. Select the next gap-free five-digit version. Never edit, rename, renumber, reorder, or delete an existing migration or its checksum entry.
  3. Read references/migration-template.md. Edit the owning declarative source, then run make codegen. Inspect the newly appended Goose SQL, Atlas sqlcheck result, refreshed atlas.sum, and regenerated sqlc output. If the generated tail is wrong, correct the declarative schema and regenerate; add bounded data transformation SQL only to the unpublished tail, then rerun make codegen.
  4. Update affected static queries in the owning sqlc catalog. Keep generated sqlcgen types inside the owner package and map them to domain types at the repository boundary.
  5. Read references/migration-test-patterns.md. Run the canonical suites that own fresh apply, reopen/data preservation, ahead-version refusal, integrity, sequential history, and schema equivalence. Extend cases only for a new transformation or failure mode not already covered. Global/memory changes also retain shared-file table ownership checks; do not duplicate those invariants for every appended migration.
  6. If recovery or refusal guidance changes, move the whole stopped SQLite family (.db, -wal, -shm, and sibling databases) to cold storage; never move or edit one live file. Prefer a newer compatible binary for schema_ahead when state must be preserved.
  7. Run the owning scoped race-enabled migration checks and make codegen-check. Reuse their current evidence and the affected lint lane; root make gate applies before commit/push and required current-head CI before PR completion.
Show full SKILL.md (118 more words)Show less

Error Handling

  • Stop on any atlas.sum mismatch or edited historical byte. Restore the exact unpublished history or append a new migration; never weaken validation or edit a Goose version table.
  • Resolve destructive Atlas diagnostics in the design. Do not suppress sqlcheck to force generation.
  • User data survives every migration (SD-013): transform rows in the appended SQL instead of dropping them; a migration that drops or truncates user rows needs the user's sign-off recorded in an ADR plus a release-note Migration notes block. Document delete targets in the spec/ADR. Do not ship dual schemas or open-ended repair branches.
  • Treat a pre-Goose marker as legacy_database and a recorded version above the embedded head as schema_ahead; neither condition authorizes in-place mutation.

© compozy, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 3 other files (references) in .agents/skills/eng/eng-schema-migration of compozy/compozy.

  • SKILL.md
  • references/migration-decision.md
  • references/migration-template.md
  • references/migration-test-patterns.md

Open the folder on GitHubat commit c46be43

Compare with similar skills

Eng Schema Migration next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Eng Schema Migration compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Eng Schema Migration this skillcompozy/compozy2.8k—~809Automated safety check: PassMIT
Cursor BYOK Database Schemaleookun/cursor-byok3.2k—~1.3kAutomated safety check: PassMIT
Database MigrationRain-kl/OpenFlare288—~1.3kAutomated safety check: PassApache-2.0
DB Migration Scriptsgolemcloud/golem1.5k—~1.5kAutomated safety check: PassCustom licence
Database MarchatCod-e-Codes/marchat137—~985Automated safety check: PassMIT
Add Store Queryradimsem/remindb129—~2kAutomated safety check: PassMIT

Similar skills

  • Cursor BYOK Database Schema

    leookun/cursor-byok

    Guides SQLite schema changes in the Cursor BYOK server, keeping SQLx migrations, the Rust store, API contracts and fixtures aligned.

    3.2k GitHub stars~1.3k tokensUpdated 9 days ago
    DatabasesAuto-check passed
  • Database Migration

    Rain-kl/OpenFlare

    Wavelet 项目专用:当新增或修改数据库表结构、索引、初始化数据、系统配置 seed、模板 seed、默认管理员、goose SQL 迁移、internal/infra/persistence/migrator、ClickHouse 分析库 DDL 或数据库升级流程时必须使用。本技能指导在 internal/infra/persistence/migrator/goose 下编写…

    288 GitHub stars~1.3k tokensUpdated today
    DatabasesAuto-check passed
  • DB Migration Scripts

    golemcloud/golem

    Writing database migration SQL scripts. An agent skill from golemcloud/golem.

    1.5k GitHub stars~1.5k tokensUpdated today
    DatabasesAuto-check passed
  • Database Marchat

    Cod-e-Codes/marchat

    Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers.

    137 GitHub stars~985 tokensUpdated 4 days ago
    DatabasesAuto-check passed
  • Add Store Query

    radimsem/remindb

    A skill your agent uses when adding or modifying a SQL query against the SQLite store — symptoms include "add a method to Store", "new column on nodes", "expose X via the store", "add an index"…

    129 GitHub stars~2k tokensUpdated 2 mo ago
    DatabasesAuto-check passed
  • Flyway Migrations

    rrezartprebreza/spring-boot-skills

    A skill your agent uses when creating database migrations, schema changes, seed data, or any SQL that modifies database structure.

    296 GitHub stars~1.4k tokensUpdated 16 days ago
    DatabasesAuto-check passed

More from compozy/compozy

All 47 skills in this repo
  • Eng Real Scenario QA

    compozy/compozy

    Dogfoods Compozy through an autonomous startup scenario with live providers, cross-surface observation, and strict evidence audit.

    2.8k GitHub stars~3.4k tokensUpdated today
    Auto-check passed
  • Eng Test Conventions

    compozy/compozy

    Go test-shape discipline for Compozy. An agent skill from compozy/compozy.

    2.8k GitHub stars~467 tokensUpdated today
    Auto-check passed
  • Assistant UI

    compozy/compozy

    Guide for assistant-ui library - AI chat UI components. An agent skill from compozy/compozy.

    2.8k GitHub stars~958 tokensUpdated today
    Auto-check passed
  • Guide for assistant-ui UI primitives - ThreadPrimitive, ComposerPrimitive, MessagePrimitive.

    2.8k GitHub stars~999 tokensUpdated today
    Auto-check passed
  • Assistant UI Runtime

    compozy/compozy

    Guide for assistant-ui runtime system and state management. An agent skill from compozy/compozy.

    2.8k GitHub stars~856 tokensUpdated today
    Auto-check passed
  • Assistant UI Streaming

    compozy/compozy

    Guide for assistant-stream package and streaming protocols. An agent skill from compozy/compozy.

    2.8k GitHub stars~813 tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Eng Schema Migration

What does Eng Schema Migration do?

Change Compozy SQLite tables, columns, indexes, constraints, triggers, or seed data under internal/store or internal/memory using append-only Goose migrations and owning generators. Eng Schema Migration is an agent skill from compozy/compozy. Change Compozy SQLite tables, columns, indexes, constraints, triggers, or seed data under internal/store or internal/memory using append-only Goose migrations and owning generators.

When should I use Eng Schema Migration?

Eng Schema Migration fits situations like: tasks that involve Database migrations; tasks that involve Test data and fixtures.

How do I install Eng Schema Migration in Claude Code?

Run `npx skills add compozy/compozy --skill eng-schema-migration -a claude-code`. Or copy the skill folder (.agents/skills/eng/eng-schema-migration in compozy/compozy) into .claude/skills/eng-schema-migration in your project. Claude Code loads it when a task matches its description.

How do I install Eng Schema Migration in Codex?

Run `npx skills add compozy/compozy --skill eng-schema-migration -a codex`. Or copy the skill folder (.agents/skills/eng/eng-schema-migration in compozy/compozy) into .agents/skills/eng-schema-migration in your project. Codex loads it when a task matches its description.

Can I use Eng Schema Migration in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add compozy/compozy --skill eng-schema-migration -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/eng-schema-migration, .gemini/skills/eng-schema-migration, .github/skills/eng-schema-migration and .opencode/skills/eng-schema-migration in your project.

What does Eng Schema Migration need to run?

Going by SKILL.md and its folder, Eng Schema Migration needs the command-line tools its instructions call (make).

Does Eng Schema Migration access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Eng Schema Migration safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Eng Schema Migration use?

Eng Schema Migration is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Eng Schema Migration use?

About 809 tokens (SKILL.md is roughly 3.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 1.5k tokens, read only when the agent opens those files.

What are the alternatives to Eng Schema Migration?

Skills that share tags, products or a category with Eng Schema Migration: Cursor BYOK Database Schema (leookun/cursor-byok, 3.2k stars), Database Migration (Rain-kl/OpenFlare, 288 stars), DB Migration Scripts (golemcloud/golem, 1.5k stars) and Database Marchat (Cod-e-Codes/marchat, 137 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Eng Schema Migration?

compozy (a GitHub organization) maintains it in compozy/compozy, which has 2,791 GitHub stars. The repository holds 47 skills in this directory. The repository was last updated on October 7, 2026.

Source: compozy/compozy on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.