generating-database-seed-data

Solid

This skill enables Claude 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. Use this skill when you need to quickly populate a database with sample data for development, testing, or demonstration purposes. The skill is triggered by phrases like "seed database", "generate test data", "create seed script", or "populate database with realistic data".

AI & Automation 2,266 stars 315 forks Updated today MIT

Install

View on GitHub

Quality Score: 93/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

## Overview This skill automates the creation of database seed scripts, populating your database with realistic and consistent test data. It leverages Faker libraries to generate diverse and believable data, ensuring relational integrity and configurable data volumes. ## How It Works 1. **Analyze Schema**: Claude analyzes the database schema to understand table structures and relationships. 2. **Generate Data**: Using Faker libraries, Claude generates realistic data for each table, respecting data types and constraints. 3. **Maintain Relationships**: Claude ensures foreign key relationships are maintained, creating consistent and valid data across tables. 4. **Create Seed Script**: Claude generates a database seed script (e.g., SQL, JavaScript) containing the generated data. ## When to Use This Skill This skill activates when you need to: - Populate a development database with realistic data. - Create a seed script for automated database setup. - Generate test data for application testing. - Demonstrate an application with pre-populated data. ## Examples ### Example 1: Populating a User Database User request: "Create a seed script to populate my users table with 50 realistic users." The skill will: 1. Analyze the 'users' table schema (name, email, password, etc.). 2. Generate 50 sets of realistic user data using Faker libraries. 3. Create a SQL seed script to insert the generated user data into the 'users' table. ### Example 2: Seeding a Blog Database User request:...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
7 months ago
Last Updated
today
Language
Python
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Solid

generating-test-data

This skill enables Claude to generate realistic test data for software development. It uses the test-data-generator plugin to create users, products, orders, and custom schemas for comprehensive testing. Use this skill when you need to populate databases, simulate user behavior, or create fixtures for automated tests. Trigger phrases include "generate test data", "create fake users", "populate database", "generate product data", "create test orders", or "generate data based on schema". This skill is especially useful for populating testing environments or creating sample data for demonstrations.

2,266 Updated today
jeremylongshore
Data & Documents Listed

seed-data-generator

Generate realistic test data for database development, testing, and demos.

335 Updated today
aiskillstore
AI & Automation Solid

managing-database-testing

This skill manages database testing by generating test data, wrapping tests in transactions, and validating database schemas. It is used to create robust and reliable database interactions. Claude uses this skill when the user requests database testing utilities, including test data generation, transaction management, schema validation, or migration testing. Trigger this skill by mentioning "database testing," "test data factories," "transaction rollback," "schema validation," or using the `/db-test` or `/dbt` commands.

2,266 Updated today
jeremylongshore
Testing & QA Solid

test-data-generation

Synthetic test data generation and management using Faker.js and similar tools. Generate realistic test data, create data factories, implement database seeding, and manage test data anonymization.

1,034 Updated today
a5c-ai
AI & Automation Solid

db-seed

Generate database seed scripts with realistic sample data. Reads Drizzle schemas or SQL migrations, respects foreign key ordering, produces idempotent TypeScript or SQL seed files. Handles D1 batch limits, unique constraints, and domain-appropriate data. Use when populating dev/demo/test databases. Triggers: 'seed database', 'seed data', 'sample data', 'populate database', 'db seed', 'test data', 'demo data', 'generate fixtures'.

809 Updated 2 weeks ago
jezweb