Claude Skill MartBrowse skillsQuick linesLearn by videoTerminal guideWhat is a Skill?
 
← Back to list

Database Seed Generator

Reads your project's schema and generates idempotent seed scripts with realistic sample data, correct foreign-key ordering, and Cloudflare D1 limits handled.

Dev & CodingIntermediate★ 1,033⑂ 105AI score 9/10Last updated: Sep 26, 2026

What it does

  • Scans the project for Drizzle schemas, SQL migrations, or prisma/schema.prisma and maps tables, types, constraints, and foreign keys.
  • Builds a dependency graph so parents are inserted before children; circular references are handled with a nullable two-pass insert/update.
  • Generates domain-appropriate data (real-sounding names, example.com emails, sensible prices, ISO 8601 dates) instead of "test123" or Lorem ipsum, with an optional seeded PRNG for reproducible runs.
  • Emits idempotent scripts — delete-then-insert for dev/testing, upsert for demo data — plus logging of row counts and the exact run command.
  • Bakes in D1 gotchas: ~10 rows per INSERT, 100 bound-parameter limit, no native BOOLEAN/DATETIME, JSON stored as TEXT.

Who it's for

  • Backend/fullstack developers on Cloudflare Workers + D1 + Drizzle ORM.
  • Teams that need presentable demo data for screenshots and pitches.
  • QA and developers who need boundary values, unicode, and long-string edge cases in test databases.

Usage examples

  1. "Seed my blog database" → a scripts/seed.ts inserting users → categories → posts → comments → tags → post_tags in dependency order.
  2. "Generate medium-volume demo data for an e-commerce app" → products with believable names/prices and upsert-based seeding that preserves user-created rows.
  3. "Give me a raw SQL seed I can run with wrangler" → seed.sql with 10-row INSERT batches and the run command in a header comment.

· · · Install guide · · ·

Try it now, no install

Paste this into Claude to use the skill without installing anything.

Read the instructions in this file and follow them to help me:
https://raw.githubusercontent.com/jezweb/claude-skills/HEAD/plugins/cloudflare/skills/db-seed/SKILL.md

What I want: (describe your task here)

If Claude can't open the link, open it yourself and paste the contents instead.

↓ If it works for you, download the ZIP below and install it. Then it runs on its own — no pasting each time.

Install in the Claude app (no terminal)
  1. Download the ZIP with the button below.
  2. In Claude, open Settings → Capabilities and turn on 'Code execution and file creation'. (one time)
  3. Go to Customize → Skills → + → 'Upload a skill' and upload the ZIP.
↓ Download ZIP
Install in Claude Code

Let Claude do it — paste this into Claude Code

Install the skill I found on Claude Skill Mart.
Copy the plugins/cloudflare/skills/db-seed folder from the GitHub repo jezweb/claude-skills into my ~/.claude/skills/db-seed/.
When it's done, tell me in one line what this skill can do.

Install with a command instead

git clone https://github.com/jezweb/claude-skills.git /tmp/claude-skills && mkdir -p ~/.claude/skills && cp -r /tmp/claude-skills/plugins/cloudflare/skills/db-seed ~/.claude/skills/

⚠ This is a third-party skill. Check the source repository before installing.

  1. Open a terminal and clone the repo: git clone https://github.com/jezweb/claude-skills.git
  2. Make sure the skills folder exists: mkdir -p ~/.claude/skills
  3. Copy just this skill: cp -r claude-skills/plugins/cloudflare/skills/db-seed ~/.claude/skills/
  4. Verify: ls ~/.claude/skills/db-seed/SKILL.md
  5. Start Claude Code inside your project and say "seed database" or "generate sample data" to trigger the skill.
  6. Run the generated file with npx tsx scripts/seed.ts or npx wrangler d1 execute DB_NAME --local --file=./scripts/seed.sql. The default mode deletes existing rows first — never point it at a production database.
View source on GitHub ↗License: MIT