skills.rest
ninyawee
ninyaweeCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

supabase-seeding

Seed Supabase databases with SQL scripts and Faker-generated data.

Updated Aug 27, 2026
Search Tags:#supabase#sql#data generation#python scripts#database seeding#bulk loading
One-click install
npx skills add https://github.com/ninyawee/dotfiles --skill supabase-seeding-ninyawee
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-seeding
Source: https://github.com/ninyawee/dotfiles/tree/main/dot_claude/saved_skills/supabase-seeding
Command: npx skills add https://github.com/ninyawee/dotfiles --skill supabase-seeding-ninyawee

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires faker, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of populating Supabase databases with initial data, ensuring consistency and reducing manual effort during development and deployment.

Core Features & Use Cases

  • Data Generation: Create realistic or placeholder data for testing and development using Faker.
  • Bulk Loading: Efficiently load large datasets using SQL COPY commands from CSV files.
  • Idempotent Seeding: Run seed files multiple times without side effects using ON CONFLICT DO NOTHING.
  • Use Case: Populate your new Supabase project with essential lookup tables (e.g., user roles, product categories) and generate a set of test users and products.

Quick Start

Run all SQL seed files in the 'supabase/seed/' directory using the provided script.

Frequently Asked Questions about supabase-seeding

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I seed a Supabase database with test data?▼

Populate your Supabase database by running SQL seed files that create lookup tables and insert test data. The toolkit automates execution order, monitors progress, and handles errors to ensure consistent database initialization.

Can I use Python scripts to generate data for Supabase seeding?▼

Yes, you can use Python scripts with the Faker library to generate realistic test data for Supabase seeding. This allows you to create placeholder data for development and testing before loading it into your database.

What is the best way to bulk load large datasets into Supabase?▼

Bulk load large datasets into Supabase using SQL COPY commands from CSV files. This approach efficiently imports high volumes of data, and you can manage large datasets using DVC for version control.

How do I make Supabase seed files idempotent?▼

Make Supabase seed files idempotent by using the `ON CONFLICT DO NOTHING` SQL clause in your scripts. This prevents duplicate records and side effects when running seed files multiple times.

Do I need Faker to populate lookup tables in Supabase?▼

You do not need Faker to populate static lookup tables like user roles or product categories, as these use predefined SQL values. Faker is required specifically for generating realistic placeholder test data for development.

Related Skills

Explore More Software Engineering Skills→
Dhavanesh24cs412Dhavanesh24cs412
1

supabase-automation

Automate Supabase database queries, table management, and SQL execution via Rube MCP.

Community
Advanced
Interstellar-codeInterstellar-code
17

sql-cli

Execute SQL queries against MySQL and PostgreSQL databases from the command line.

Community
Advanced
LeandroBenjaminLLeandroBenjaminL

shared-git-data

Automate Git best practices for data science workflows with DVC and nbstripout.

Community
Advanced
SkylerCookSkylerCook

i18n-bdp-trans-seed

Generate multilingual translation term tables and SQL scripts for dictionary storage.

Community
Intermediate