generating-database-seed-data

Process this skill enables AI assistant to generate realistic test data and database seed scripts for development and testing environments. it uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. u... Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.

インストールへ移動

リポジトリ: jeremylongshore/claude-code-plugins-plus-skills
ソースの最終更新活動: 2026年7月17日 22:18
検出された SKILL.md の言語: 英語
スター: 2,604
フォーク: 378

インストール方法

デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。

npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus-skills --skill generating-database-seed-data

コマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。

ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。

ソースファイルを確認

インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。

ファイルエクスプローラー

4 ファイル

SKILL.md

ソースの指示 · 読み取り専用プレビュー

検索に戻るインストールに戻る

clerk-core-workflow-a

Implement user sign-up and sign-in flows with Clerk. Use when building authentication UI, customizing sign-in experience, or implementing OAuth social login. Trigger with phrases like "clerk sign-in", "clerk sign-up", "clerk login flow", "clerk OAuth", "clerk social login".

2026-07-23

clerk-core-workflow-b

Implement session management and middleware with Clerk. Use when managing user sessions, configuring route protection, or implementing token refresh and custom JWT templates. Trigger with phrases like "clerk session", "clerk middleware", "clerk route protection", "clerk token", "clerk JWT".

2026-07-23

clerk-enterprise-rbac

Configure enterprise SSO, role-based access control, and organization management. Use when implementing SSO integration, configuring role-based permissions, or setting up organization-level controls. Trigger with phrases like "clerk SSO", "clerk RBAC", "clerk enterprise", "clerk roles", "clerk permissions", "clerk organizations".

2026-07-23

このリポジトリのすべてを見る

Data Seeder Generator

Overview

Generate realistic database seed scripts that populate development and testing environments with representative data. This skill creates seed data that respects foreign key relationships, unique constraints, check constraints, and data type validations using Faker libraries (faker.js, Faker for Python, or raw SQL with random functions).

Prerequisites

Database schema definition (SQL DDL, ORM models, or Prisma schema) to understand table structures

Target database connection for schema introspection (optional, can work from DDL files)

Faker library available: @faker-js/faker (Node.js), faker (Python), or Bogus (.NET)

Knowledge of referential integrity constraints (foreign keys, cascades)

Target data volume per table (e.g., 100 users, 1000 orders, 5000 line items)

Instructions

Analyze the database schema to catalog all tables, columns, data types, constraints, and foreign key relationships. Build a dependency graph where parent tables (referenced by foreign keys) must be seeded before child tables.

Determine the seeding order by topologically sorting the dependency graph. Tables with no foreign keys are seeded first (users, categories, products), then tables referencing them (orders, reviews), then junction tables and deeply nested tables last.

Map each column to an appropriate Faker generator based on column name and data type:

first_name, last_name -> faker.person.firstName(), faker.person.lastName()
email -> faker.internet.email() with unique enforcement
phone -> faker.phone.number()
address, city, state, zip -> faker.location.*
created_at, updated_at -> faker.date.between({ from: '2023-01-01', to: '2024-12-31' })
price, amount -> faker.commerce.price({ min: 1, max: 999 })
description, bio -> faker.lorem.paragraph()
status -> Random selection from CHECK constraint values or enum values

Data Seeder Generator

Overview

Prerequisites

Database schema definition (SQL DDL, ORM models, or Prisma schema) to understand table structures

Target database connection for schema introspection (optional, can work from DDL files)

Faker library available: @faker-js/faker (Node.js), faker (Python), or Bogus (.NET)

Knowledge of referential integrity constraints (foreign keys, cascades)

Target data volume per table (e.g., 100 users, 1000 orders, 5000 line items)

Instructions

Map each column to an appropriate Faker generator based on column name and data type:

first_name, last_name -> faker.person.firstName(), faker.person.lastName()
email -> faker.internet.email() with unique enforcement
phone -> faker.phone.number()
address, city, state, zip -> faker.location.*
created_at, updated_at -> faker.date.between({ from: '2023-01-01', to: '2024-12-31' })
price, amount -> faker.commerce.price({ min: 1, max: 999 })
description, bio -> faker.lorem.paragraph()
status -> Random selection from CHECK constraint values or enum values

name	generating-database-seed-data
description	Process this skill enables AI assistant to generate realistic test data and database seed scripts for development and testing environments. it uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. u... Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.
allowed-tools	Read, Write, Edit, Grep, Glob, Bash(cmd:*)
version	1.22.0
author	Jeremy Longshore <jeremy@intentsolutions.io>
license	MIT
tags	["database","testing","database-seed"]
compatibility	Designed for Claude Code, also compatible with Codex and OpenClaw

name	generating-database-seed-data
description	Process this skill enables AI assistant to generate realistic test data and database seed scripts for development and testing environments. it uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. u... Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.
allowed-tools	Read, Write, Edit, Grep, Glob, Bash(cmd:*)
version	1.22.0
author	Jeremy Longshore <jeremy@intentsolutions.io>
license	MIT
tags	["database","testing","database-seed"]
compatibility	Designed for Claude Code, also compatible with Codex and OpenClaw

Error	Cause	Solution
Foreign key constraint violation during seeding	Child records reference parent IDs that do not exist	Verify seeding order follows dependency graph; ensure parent seed completes before child seed starts
Unique constraint violation	Faker generated duplicate values for unique columns	Track generated values in a Set; use `faker.helpers.unique()` wrapper; append sequential suffix for high-volume unique fields
CHECK constraint violation	Generated value outside allowed range or not in enum list	Read CHECK constraints from schema; configure Faker min/max ranges; restrict enum selection to valid values
Seed script too slow for large volumes	Individual INSERT statements instead of batch operations	Use batch inserts (`INSERT INTO ... VALUES (...), (...), (...)`); use COPY command for PostgreSQL; disable indexes during bulk insert
Unrealistic data distribution	All records have uniform random values	Use weighted random selection for status fields; apply Zipf distribution for popularity-based relationships; generate time-series data with realistic patterns

generating-database-seed-data

インストール方法

ソースファイルを確認

Data Seeder Generator

Overview

Prerequisites

Instructions

Data Seeder Generator

Overview

Prerequisites

Instructions

Output

Error Handling

Examples

Resources

generating-database-seed-data

ソース情報

インストール方法

ソースファイルを確認

このリポジトリの他の Skills

このリポジトリの他の Skills

Data Seeder Generator

Overview

Prerequisites

Instructions

Data Seeder Generator

Overview

Prerequisites

Instructions

Output

Error Handling

Examples

Resources