seed
Generate FK-aware, deterministic sample/seed data from a database schema, ORM model, or migrations — INSERT statements emitted in dependency order (parents first), values derived from row index so output is stable and reviewable. Read-only; never writes to a database. For dev/test fixtures only. Use when the user asks to seed, generate sample/test/fixture/dummy/fake data, populate tables, or create starter rows for Postgres, MySQL, SQLite, and friends.
How do I install this agent skill?
npx skills add https://github.com/hainrixz/claude-db --skill seedIs this agent skill safe to install?
- Gen Agent Trust Hubpass
The skill generates deterministic sample data by parsing database schema files using a bundled Node.js script. While functional, it has a potential indirect prompt injection surface as it processes untrusted local files.
- Socketpass
No alerts
- Snykpass
Risk: LOW · No issues
What does this agent skill do?
/claude-db:seed
Generates FK-aware, deterministic sample/seed INSERTs from a schema. Read-only — it never connects to or writes to a database. The output is dev/test data only: predictable values derived from the row index (no RNG), suitable for fixtures, local development, and CI — never for production.
$ARGUMENTS = <path-to-schema> [flags]. The target is a schema/DDL, ORM model, or migration file. If no path is given, detect one in the working directory (look for *.sql, schema.prisma, models.py, migration dirs). If nothing is found, say so plainly and suggest pointing at a file or running /claude-db:design to create one.
What to do
- Resolve the schema path (from
$ARGUMENTSor detection above). - Run the generator:
node scripts/gen-seed.mjs --file <schema> --rows N [--format sql|json]--rows Ndefaults to 5 (clamped 1–1000).--formatdefaults tosql;jsonreturns the statements as an array plus metadata.- The script topologically sorts tables so each table's FK parents are inserted first, fills FK columns with valid parent ids, and skips auto-increment/identity PKs.
- Present the result:
- The insert order (dependency order, parents → children) and per-table row counts.
- The generated
INSERTstatements, grouped by table in that order. - The parser confidence and any tables skipped or cycles ignored.
- Offer to save to a file (e.g.
seed.sqlorfixtures.json) — only write if the user confirms a path. Otherwise leave it inline.
Notes
- Deterministic by design: re-running with the same
--rowsyields byte-identical output, so seeds are diff-friendly and reproducible. - Values are illustrative placeholders (emails like
user1@example.com, fixed timestamps, sequential ids) — not realistic or privacy-safe production data. - Cyclic FKs are ignored for ordering; deferred-constraint or self-referential cases may need a manual pass after generation.
For dev/test fixtures only. Never run generated seeds against a production database. Respond in the user's language (EN/ES).
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/hainrixz/claude-db/seed">View seed on skillZs</a>