Db Seed

Generates seed scripts that actually populate your database with realistic data instead of "test123" and "foo@bar.com". Reads Drizzle schemas or SQL migrations, figures out foreign key dependencies, and outputs TypeScript or SQL files with domain-appropriate sample data. Handles D1's quirks like the 10-row batch limit and TEXT-based JSON fields. The quality rules are solid: it varies the data, matches your domain context, and includes edge cases for testing seeds. You pick small/medium/large volume and dev/demo/testing purpose, and it adjusts the data style accordingly. Nice touch that it makes seeds idempotent so you can re-run them safely. Beats manually writing INSERT statements or copying production data.

skills.sh installs: 981
GitHub stars: 1.1K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add jezweb/claude-skills --skill db-seed --agent claude-code

Installs into .claude/skills of the current project.

Files

Database Seed Generator

Generate seed scripts that populate databases with realistic, domain-appropriate sample data. Reads your schema and produces ready-to-run seed files.

Workflow

1. Find the Schema

Scan the project for schema definitions:

Source	Location pattern
Drizzle schema	`src/db/schema.ts`, `src/schema/*.ts`, `db/schema.ts`
D1 migrations	`drizzle/.sql`, `migrations/.sql`
Raw SQL	`schema.sql`, `db/*.sql`
Prisma	`prisma/schema.prisma`

Read all schema files. Build a mental model of:

Tables and their columns
Data types and constraints (NOT NULL, UNIQUE, DEFAULT)
Foreign key relationships (which tables reference which)
JSON fields stored as TEXT (common in D1/SQLite)

2. Determine Seed Parameters

Ask the user:

Parameter	Options	Default
Purpose	dev, demo, testing	dev
Volume	small (5-10 rows/table), medium (20-50), large (100+)	small
Domain context	"e-commerce store", "SaaS app", "blog", etc.	Infer from schema
Output format	TypeScript (Drizzle), raw SQL, or both	Match project's ORM