Is it safe to run seeds in a production Supabase environment?

While primarily for local development, this skill covers safe production patterns using the '--include-seed' flag combined with idempotent logic to prevent data duplication or errors.

How do I ensure my seeds don't fail when run multiple times?

This skill emphasizes using the 'ON CONFLICT' clause in SQL, which allows the database to update existing records instead of throwing an error, making your seed scripts idempotent.

Can I seed data that depends on Supabase Auth users?

Yes, the skill provides a deferred seeding pattern using a config table and triggers to apply specific settings to users as soon as they sign up or are created.

Why should I separate schema from seed data in Supabase?

Keeping schema in migrations and data in seed files ensures that your database structure remains version-controlled while allowing data to be populated or reset independently without breaking the table logic.

Supabase Seeding Patterns

Name: Supabase Seeding Patterns
Author: jclfocused

byjclfocused

•

数据库管理

Streamlines Supabase database seeding with idempotent patterns and automated workflows for local and production environments.

This skill provides a comprehensive framework for managing data seeding in Supabase projects, ensuring a clean separation between database schema and data. It guides developers through implementing best practices like idempotent SQL statements using ON CONFLICT, setting up user-dependent seeding via deferred triggers, and managing domain-based configurations. By following these patterns, teams can reliably populate their databases during local development and safely backfill data in production environments without the risk of duplication or schema corruption.

主要功能

01Idempotent SQL patterns using ON CONFLICT for safe script re-runs

022 GitHub stars

03Advanced user-dependent seeding logic using PostgreSQL triggers

04Optimized configuration for supabase/seed.sql and config.toml

05Strict separation of schema migrations from data seeds

06Domain-based auto-configuration for organization-level seeding

使用场景

01Automating the creation of admin profiles and roles upon user signup

02Populating local development databases with realistic test data

03Setting up initial reference data for new project environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jclfocused/claude-agents supabase-seeding

For use in Claude.ai and ChatGPT

Download Skill