スキルを検索.../

Skill ファイル

Create Migration

Scaffold a new Supabase SQL migration file and regenerate TypeScript types. Use when creating database schema changes, adding tables, columns, or modifying RLS policies.

lmarciales0 スター2026/04/18

カテゴリ

データベースツール

スキル内容

Create Supabase Migration

When the user invokes /create-migration, follow these steps:

1. Gather Requirements

Ask the user what database change they need (new table, add column, modify RLS policy, etc.) if not already specified.

2. Create Migration File

Generate a timestamped SQL migration file:

Path: supabase/migrations/<YYYYMMDDHHMMSS>_<descriptive_name>.sql
Use the current UTC timestamp for the prefix
Include clear SQL comments explaining the migration
Always include IF NOT EXISTS / IF EXISTS guards where appropriate
For new tables, always enable RLS and create appropriate policies

3. Regenerate TypeScript Types

After writing the migration SQL, remind the user to:

Apply the migration: (or apply via Supabase dashboard)

関連 Skill

クイックインストール

Create Migration

npx skills add lmarciales/personal-expenses

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

作者: lmarciales
スター: 0
更新日: 2026/04/18

このページの内容

01Create Supabase Migration 021. Gather Requirements

npx supabase db push

Regenerate types: npx supabase gen types typescript --project-id rgawlpqxqypntrknutlc > src/supabase/database.types.ts

4. Verify

Ensure the migration SQL is syntactically valid
Confirm RLS policies are included for any new tables
Remind the user to commit both the migration file and updated database.types.ts together

032. Create Migration File

043. Regenerate TypeScript Types

データベースツール

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.

Create Migration | Skills Pool