How does this skill handle large datasets?

It provides specific patterns for using the PostgreSQL COPY command for efficiency and integrates with DVC (Data Version Control) to manage files larger than 1MB outside of the main Git repository.

Does this replace the Supabase CLI?

No, it complements the Supabase CLI by providing more granular control, such as progress monitoring for large files and advanced data generation scripts that the standard CLI doesn't offer natively.

Are the seeding scripts idempotent?

Yes, the recommended templates use 'ON CONFLICT DO NOTHING' clauses to ensure that running the seeds multiple times won't result in duplicate errors or corrupted data.

Can I generate mock data automatically?

Yes, the skill includes helper scripts that use the Faker library to generate realistic test data (users, transactions, etc.) based on your specific database schema.

Supabase Database Seeding Toolkit

Name: Supabase Database Seeding Toolkit
Author: ninyawee

byninyawee

0•

Gestión de Bases de Datos

Streamlines the population of Supabase databases with automated seed data generation, bulk loading, and lookup table management.

This skill provides a comprehensive toolkit for managing database seeds within Supabase projects, offering automated scripts for generating mock data via Faker and executing seed files with progress monitoring. It establishes clear patterns for different data types—ranging from small lookup tables with idempotency logic to massive datasets requiring COPY commands and DVC (Data Version Control) tracking—ensuring consistent, reproducible development environments and robust testing workflows for engineering teams.

Características Principales

01Automated seed generation using schema-aware Python scripts and Faker data.

02Standardized directory structure with numbered execution ordering for data integrity.

03Idempotent seed templates utilizing INSERT ... ON CONFLICT logic for safe reruns.

04DVC integration for tracking and versioning massive seed files outside of Git.

05Efficient bulk loading patterns for large datasets using PostgreSQL COPY commands.

060 GitHub stars

Casos de Uso

01Managing static reference data and lookup tables consistently across staging and production.

02Populating local development environments with realistic mock data for UI/UX testing.

03Version controlling large-scale datasets that exceed standard Git file size recommendations.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ninyawee/armed-claude supabase-seeding

For use in Claude.ai and ChatGPT

Download Skill