スキルを検索.../

Convex Migration Helper | Skills Pool

Skill ファイル

Convex Migration Helper

Plans and executes safe Convex schema/data migrations for this repo using a widen-migrate-narrow rollout. Use when schema deploy fails, existing documents need backfills, or fields must be added/removed/reshaped without downtime.

ndelangen0 スター2026/03/24

職業
カテゴリ: データベースツール

スキル内容

Use this skill for breaking Convex schema changes in this repository.

When to Use

Adding a required field to an existing table
Renaming/removing fields that already exist in data
Changing a field shape or type
Splitting data into new tables while preserving production behavior
Any deploy where Convex schema validation fails due to old documents

When Not to Use

Greenfield schema/table work with no existing rows
Optional-field additions that do not require backfill
Pure index changes that do not affect correctness

Breaking Changes: The Deployment Workflow

Widen: update convex/schema.ts so old + new documents are valid.
Dual-read/write: update handlers so new writes use new shape while reads tolerate both shapes.
Migrate existing rows: run a bounded internal migration and backfill old rows.

関連 Skill

クイックインストール

Convex Migration Helper

npx skills add ndelangen/tanstack-start

Skill をダウンロードリポジトリを開く

作者: ndelangen
スター: 0
更新日: 2026/03/24
職業

このページの内容

Verify: add a query to detect unmigrated rows; confirm zero remaining.

Narrow: remove old shape from schema and cleanup fallback code.

Common Migration Patterns

Use references/migration-patterns.md for concise examples:

required-field rollout
old-field removal
type-shape transitions through a new field
split-table extraction
orphan cleanup
migration completion checks

Common Pitfalls

Narrowing schema before data is migrated.
Using unbounded .collect() on large tables.
Not handling both old/new shapes during the migration window.
Changing reads in one path but forgetting sibling readers/writers.
Forgetting to remove temporary compatibility code after narrowing.

Repo-specific Notes

This repo currently does not include @convex-dev/migrations.
Prefer internalMutation + bounded batches (.take(n)) + ctx.scheduler.runAfter for large jobs.
Keep validation consistent with project conventions:
- Convex v for boundary shape/type.
- Shared Zod safeParse for semantic rules in handlers.

Migration Checklist

Planned widen -> migrate -> narrow rollout
Widened schema and deployed compatibility reads/writes
Backfilled existing data with bounded migration batches
Verified zero unmigrated rows remain
Narrowed schema and removed fallback logic
Re-ran affected tests and key mutation/query paths

02

When Not to Use

03Breaking Changes: The Deployment Workflow

04Common Migration Patterns

05Common Pitfalls

06Repo-specific Notes

07Migration Checklist

データベースアーキテクト

データベースツール

Database Migrations

数据库迁移最佳实践，涵盖模式变更、数据迁移、回滚以及零停机部署，适用于PostgreSQL、MySQL及常用ORM（Prisma、Drizzle、Django、TypeORM、golang-migrate）。

データベースツール

Database Migrations

Şema değişiklikleri, veri migration'ları, rollback'ler ve PostgreSQL, MySQL ve yaygın ORM'ler (Prisma, Drizzle, Django, TypeORM, golang-migrate) arasında sıfır kesinti deployment'ları için veritabanı migration en iyi uygulamaları.

データエンジニアリング

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

データベースツール

Frontend Query & Mutation

Guide for implementing Dify frontend query and mutation patterns with TanStack Query and oRPC. Trigger when creating or updating contracts in web/contract, wiring router composition, consuming consoleQuery or marketplaceQuery in components or services, deciding whether to call queryOptions() directly or extract a helper or use-* hook, handling conditional queries, cache invalidation, mutation error handling, or migrating legacy service calls to contract-first query and mutation helpers.

langgenius138.3k

データベースツール

Db Migrations

Use when generating or regenerating Drizzle migration files, changing database schema tables or columns, resolving migration sequence conflicts after rebase, reviewing migration SQL for idempotent patterns, or renaming migration files.

CMS・プラットフォーム

Drizzle

Drizzle ORM schema and database guide. Use when working with database schemas (src/database/schemas/*), defining tables, creating migrations, or database model code. Triggers on Drizzle schema definition, database migrations, or ORM usage questions.

データベースアーキテクト