Agent skill

Exposed Migration

by GerardPaligot in GerardPaligot/Confily

A skill your agent uses when adding, removing, or modifying columns, indexes, or tables in any Exposed table object (files under infrastructure/exposed/ ending in Table.kt).

Apache-2.0Auto-check passedMobile

Install Exposed Migration

skills CLI
$ npx skills add GerardPaligot/Confily --skill exposed-migration -a claude-code

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

GitHub CLI
$ gh skill install GerardPaligot/Confily exposed-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/GerardPaligot/Confily.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.github/skills/exposed-migration .claude/skills/exposed-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
exposed-migration
GitHub stars
152
Token cost
~1.3k tokens
SKILL.md length
404 words
Files
1
Skills in repo
3
Repo updated
First seen
Licence
Apache-2.0

At a glance

A skill your agent uses when adding, removing, or modifying columns, indexes, or tables in any Exposed table object (files under infrastructure/exposed/ ending in Table.kt).

  • Works in 2 steps: Create the migration class → Register it in MigrationRegistry
  • Modifying columns
  • SKILL.md covers When a Migration Is Required, Project Infrastructure, How to Create a Migration and ID Convention, plus 2 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Exposed Migration is an agent skill from GerardPaligot/Confily. Use this skill when adding, removing, or modifying columns, indexes, or tables in any Exposed table object (files under infrastructure/exposed/ ending in Table.kt). Explains when a migration is required, how to create one following the project convention, and how to register it so it runs automatically at startup.

Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Mobile. It works with Firebase, Google Cloud, Cloud Firestore and Android. The repository describes itself as: Real life Kotlin Multiplatform project with an iOS application developed in Swift with SwiftUI, an Android application developed in Kotlin with Jetpack Compose and a backend in… The licence is Apache-2.0.

When your agent uses it

  • Modifying columns
  • Tables in any Exposed table object (files under infrastructure/exposed/ ending in Table.kt)

Example prompts

  • “/exposed-migration”

Workflow steps

2 steps, taken from the step headings in SKILL.md.

  1. Create the migration class
  2. Register it in MigrationRegistry

What it can do on your machine

Read from SKILL.md and the folder at commit 61ad38f. 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

    No scripts in the folder and no shell commands in SKILL.md (its code samples are kotlin).

    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

Exposed Migration loads about 1.3k tokens when it runs. Until then it costs about 83 tokens; SKILL.md has 404 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~83
When it runs · the whole SKILL.md, loaded when a task matches
~1.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 GerardPaligot/Confily at commit 61ad38f, republished under its Apache-2.0 licence (© GerardPaligot). 404 words, ~1,251 tokens.

Download SKILL.mdSave it as .claude/skills/exposed-migration/SKILL.md (or your agent's skills folder).
name
exposed-migration
description
Use this skill when adding, removing, or modifying columns, indexes, or tables in any Exposed table object (files under infrastructure/exposed/ ending in Table.kt). Explains when a migration is required, how to create one following the project convention, and how to register it so it runs automatically at startup.

Exposed Migration Skill

When a Migration Is Required

A migration must be created whenever you change an Exposed table definition in a way that alters the existing database schema. SchemaUtils.create() only creates tables that do not exist yet — it never modifies existing ones.

ChangeMigration needed?
Add a new Table objectNo — SchemaUtils.create() handles it
Add a column to an existing tableYes
Remove a column from an existing tableYes (manual ALTER TABLE DROP COLUMN)
Change a column type or constraintYes
Add or remove an index on an existing tableYes
Rename a columnYes
Add a new nullable column with a defaultYes

If you skip the migration, the new column/index will exist in code but not in the production database, causing runtime crashes on the next deployment.

Project Infrastructure

The migration system lives at:

backend/src/main/java/com/paligot/confily/backend/internals/infrastructure/exposed/migrations/
  Migration.kt           — interface every migration implements
  MigrationsTable.kt     — schema_migrations table that tracks what has been applied
  MigrationManager.kt    — runs pending migrations at startup, records applied ones
  MigrationRegistry.kt   — ordered list of all migrations
  versions/              — one file per migration

DatabaseFactory.init() calls MigrationManager(MigrationRegistry.allMigrations).migrate(database) after SchemaUtils.create(). Each migration is run exactly once: its id is written to schema_migrations on success and skipped on all subsequent startups.

How to Create a Migration

1. Create the migration class

Add a new file in versions/ named after what the migration does:

kotlin
// backend/.../migrations/versions/AddMyNewColumnMigration.kt
package com.paligot.confily.backend.internals.infrastructure.exposed.migrations.versions

import com.paligot.confily.backend.some.infrastructure.exposed.SomeTable
import com.paligot.confily.backend.internals.infrastructure.exposed.migrations.Migration
import org.jetbrains.exposed.sql.SchemaUtils

object AddMyNewColumnMigration : Migration {
    override val id = "YYYYMMDD_add_my_new_column"
    override val description = "Add <column_name> to <table_name> for <reason>"

    override fun up() {
        SchemaUtils.createMissingTablesAndColumns(SomeTable)
    }
}
2. Register it in MigrationRegistry

Open MigrationRegistry.kt and append the new migration at the end of allMigrations:

kotlin
val allMigrations: List<Migration> = listOf(
    // ... existing migrations ...
    AddMyNewColumnMigration
)

Do not reorder existing entries — migrations are applied in list order and each runs only once.

ID Convention

Use YYYYMMDD_short_snake_case_description, e.g.:

  • 20260326_add_activities_external_provider
  • 20260401_add_partner_video_url

The id must be unique across all migrations and sortable chronologically. The MigrationManager sorts by id before applying, so the date prefix guarantees correct ordering.

Show full SKILL.md (154 more words)Show less

Patterns for Common Changes

Add nullable columns to an existing table

Just add the column to the table object and call SchemaUtils.createMissingTablesAndColumns:

kotlin
override fun up() {
    SchemaUtils.createMissingTablesAndColumns(TargetTable)
}
Execute raw SQL (e.g. drop a column, add a partial index)

Use exec() inside a Transaction:

kotlin
override fun up() {
    exec("ALTER TABLE my_table DROP COLUMN IF EXISTS old_column")
}

up() is always called inside an active transaction (from MigrationManager), so exec() is available directly.

Data migration

Perform data manipulation with Exposed DSL inside up():

kotlin
override fun up() {
    SchemaUtils.createMissingTablesAndColumns(TargetTable)
    TargetTable.update {
        it[newColumn] = "default_value"
    }
}

Rules

  1. Never modify an already-applied migration. Once an id is in schema_migrations, that migration will never run again. Fix mistakes with a new migration.
  2. Never reorder MigrationRegistry.allMigrations. The list order controls application order for new databases.
  3. Keep up() idempotent where possible. Use IF NOT EXISTS, IF EXISTS, and createMissingTablesAndColumns so re-runs on a partially migrated database are safe.
  4. One logical change per migration. Small, focused migrations are easier to debug and roll forward.
  5. Always provide a meaningful description. It appears in logs and schema_migrations for auditability.

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

Files

Just SKILL.md in .github/skills/exposed-migration of GerardPaligot/Confily.

Open the folder on GitHubat commit 61ad38f

Compare with similar skills

Exposed 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.

Exposed Migration compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Exposed Migration this skillGerardPaligot/Confily152—~1.3kAutomated safety check: PassApache-2.0
Developer Device Platform Basicsgoogle/skills21k—~2.5kAutomated safety check: PassApache-2.0
Firebase Messagingevanca/flutter-ai-rules650—~3.2kAutomated safety check: PassMIT
Maui Push Notificationsdavidortinau/maui-skills175—~1.2kAutomated safety check: PassMIT
Cometchat Flutter V6 Pushcometchat/cometchat-skills131—~1.4kAutomated safety check: PassMIT
Cometchat React Native Pushcometchat/cometchat-skills131—~1.3kAutomated safety check: PassMIT

Similar skills

  • Official

    Provides guidance and instructions on managing remote devices on Developer Device Platform (DDP).

    21k GitHub stars~2.5k tokensUpdated today
    MobileAuto-check passed
  • Firebase Messaging

    evanca/flutter-ai-rules

    A skill your agent uses when setting up Firebase Cloud Messaging, managing permissions and tokens, handling background/foreground notification taps, or dispatching messages server-side (HTTP v1).

    650 GitHub stars~3.2k tokensUpdated 25 days ago
    MobileAuto-check passed
  • Maui Push Notifications

    davidortinau/maui-skills

    End-to-end guide for adding push notifications to .NET MAUI apps.

    175 GitHub stars~1.2k tokensUpdated 3 mo ago
    MobileAuto-check passed
  • Cometchat Flutter V6 Push

    cometchat/cometchat-skills

    Add push notifications to a Flutter app with CometChat — FCM on Android, FCM/APNs on iOS, registered through CometChatNotifications with the Dashboard provider as the sender.

    131 GitHub stars~1.4k tokensUpdated 4 days ago
    MobileAuto-check passed
  • Cometchat React Native Push

    cometchat/cometchat-skills

    Push notifications for CometChat in React Native — FCM on Android, APNs on iOS, registering the device token with CometChatNotifications, and why none of it can be verified without a real device.

    131 GitHub stars~1.3k tokensUpdated 4 days ago
    MobileAuto-check passed
  • Push Notification Setup

    secondsky/claude-skills

    Implements push notifications across iOS, Android, and web using Firebase Cloud Messaging and native services.

    227 GitHub stars~760 tokensUpdated 11 days ago
    MobileAuto-check passed

More from GerardPaligot/Confily

  • Kotlin Linting

    GerardPaligot/Confily

    A skill your agent uses whenever you write or modify Kotlin files in this project.

    152 GitHub stars~708 tokensUpdated 12 days ago
    Auto-check passed
  • Post Edit Verification

    GerardPaligot/Confily

    Use this skill after every working session where Kotlin or Android code was created or modified, and ALWAYS before committing, opening a PR, or reporting work as done.

    152 GitHub stars~1.1k tokensUpdated 12 days ago
    Auto-check passed

Categories

Questions about Exposed Migration

What does Exposed Migration do?

A skill your agent uses when adding, removing, or modifying columns, indexes, or tables in any Exposed table object (files under infrastructure/exposed/ ending in Table.kt). Exposed Migration is an agent skill from GerardPaligot/Confily.kt).

When should I use Exposed Migration?

Exposed Migration fits situations like: modifying columns; tables in any Exposed table object (files under infrastructure/exposed/ ending in Table.kt).

How do I install Exposed Migration in Claude Code?

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

How do I install Exposed Migration in Codex?

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

Can I use Exposed 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 GerardPaligot/Confily --skill exposed-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/exposed-migration, .gemini/skills/exposed-migration, .github/skills/exposed-migration and .opencode/skills/exposed-migration in your project.

What does Exposed Migration need to run?

SKILL.md names no scripts, command-line tools or credentials: Exposed Migration is instructions for the agent only.

Does Exposed 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 Exposed 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 Exposed Migration use?

Exposed Migration is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Exposed Migration use?

About 1.3k tokens (SKILL.md is roughly 5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Exposed Migration?

Skills that share tags, products or a category with Exposed Migration: Developer Device Platform Basics (google/skills, 21k stars), Firebase Messaging (evanca/flutter-ai-rules, 650 stars), Maui Push Notifications (davidortinau/maui-skills, 175 stars) and Cometchat Flutter V6 Push (cometchat/cometchat-skills, 131 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Exposed Migration?

GerardPaligot (a GitHub user) maintains it in GerardPaligot/Confily, which has 152 GitHub stars. The repository holds 3 skills in this directory. The repository was last updated on September 27, 2026.

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