# Db Seed Generator

> Generate realistic database seed data from a Prisma schema. Use when asked to generate seed data, create test data, populate the database, seed the DB, or create fixtures.

- **Type:** Skill
- **Install:** `agentstack add skill-nembie-claude-code-skills-db-seed-generator`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [Nembie](https://agentstack.voostack.com/s/nembie)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [Nembie](https://github.com/Nembie)
- **Source:** https://github.com/Nembie/claude-code-skills/tree/main/skills/db-seed-generator

## Install

```sh
agentstack add skill-nembie-claude-code-skills-db-seed-generator
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# DB Seed Generator

Before generating any output, read `config/defaults.md` and adapt all patterns, imports, and code examples to the user's configured stack.

## Process

1. Read `schema.prisma` and extract all models, fields, types, constraints, relations, and enums.
2. Determine dependency order: models with no required relations first, then models that depend on them.
3. Generate a `prisma/seed.ts` file with realistic fake data that respects all constraints.
4. Output a ready-to-run seed file.

## Dependency Ordering

Build a directed graph of model dependencies from `@relation` fields. Topologically sort so parent records are created before children.

```
User (no deps)           → create first
Organization (no deps)   → create first
Post (depends on User)   → create second
Comment (depends on User, Post) → create third
```

If circular dependencies exist, use a two-pass approach: create records with required fields first, then update with optional relation fields.

## Data Generation Rules

### Field Name Conventions

Generate realistic values based on field names:

| Pattern | Generated value |
|---|---|
| `firstName` | `"Elena"`, `"Marcus"`, `"Priya"` |
| `lastName` | `"Rodriguez"`, `"Chen"`, `"Okafor"` |
| `name` (on User) | `"Elena Rodriguez"` |
| `email` | `"elena.rodriguez@example.com"` |
| `phone` | `"555-0101"`, `"555-0102"` |
| `avatarUrl`, `imageUrl` | `"https://example.com/avatars/1.jpg"` |
| `url`, `website` | `"https://example.com"` |
| `title` (on Post/Article) | Realistic short sentences |
| `content`, `body`, `description` | 1-3 realistic sentences |
| `slug` | Derived from title: `"realistic-short-sentence"` |
| `price`, `amount` | Realistic numbers like `29.99`, `149.00` |
| `quantity`, `count` | Small integers: `1`-`100` |
| `createdAt`, `updatedAt` | Dates spread over the last 90 days |
| `publishedAt` | Either `null` or a date after `createdAt` |
| `isActive`, `isPublished` | Mix of `true`/`false` |
| `role` (enum) | Distribute across valid enum values |
| `password` | Pre-hashed placeholder: `"$2b$10$..."` — never plaintext |

### Constraints

- **`@unique`**: Ensure every value is unique. Use index suffixes: `"user1@example.com"`, `"user2@example.com"`.
- **`@id @default(cuid())`**: Omit from create calls — let the database generate them.
- **`@default(now())`**: Omit or set explicit dates for predictable ordering.
- **`@default(value)`**: Omit to use the default, or set explicitly for variety.
- **Enums**: Only use values defined in the enum.
- **`Int`, `Float`**: Respect `@db.SmallInt`, `@db.Decimal(10,2)` etc.

### Relations

- **One-to-many**: Create the "one" side first, reference its ID on the "many" side.
- **Many-to-many** (implicit): Use `connect` syntax after both sides exist.
- **Self-referencing**: Create root records first (no parent), then children pointing to them.
- **Required relations**: Always satisfy — never leave a required FK null.
- **Optional relations**: Mix of connected and null.

## Output Template

```typescript
import { PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

async function main() {
  // Clear existing data (reverse dependency order)
  await prisma.comment.deleteMany();
  await prisma.post.deleteMany();
  await prisma.user.deleteMany();

  // Seed in dependency order
  const users = await Promise.all([
    prisma.user.upsert({
      where: { email: "elena.rodriguez@example.com" },
      update: {},
      create: {
        email: "elena.rodriguez@example.com",
        name: "Elena Rodriguez",
        // ... fields
      },
    }),
    // ... more users
  ]);

  // Use createMany for bulk inserts where relations allow
  await prisma.post.createMany({
    data: [
      { title: "...", authorId: users[0].id },
      // ...
    ],
  });

  console.log("Seeded: X users, Y posts, Z comments");
}

main()
  .catch((e) => {
    console.error(e);
    process.exit(1);
  })
  .finally(() => prisma.$disconnect());
```

## Scale Parameter

When the user specifies a count (e.g., "seed 50 users"), generate that many records. Default to 5-10 records per model. Use `createMany` for bulk inserts where possible. Wrap large seeds in a `prisma.$transaction()`.

## Upsert Pattern

Use `upsert` on a unique field to make the seed idempotent — safe to run multiple times.

## Reference

See [references/seed-patterns.md](references/seed-patterns.md) for dependency ordering details, realistic data patterns, and performance tips.

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [Nembie](https://github.com/Nembie)
- **Source:** [Nembie/claude-code-skills](https://github.com/Nembie/claude-code-skills)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-nembie-claude-code-skills-db-seed-generator
- Seller: https://agentstack.voostack.com/s/nembie
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.