skills.rest
Hieubkav
HieubkavCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-data-generation

Generate realistic seed data and test fixtures for relational databases.

Updated Oct 26, 2025
Search Tags:#testing#seed data#fixtures#faker#ORM seeds
One-click install
npx skills add https://github.com/Hieubkav/wincellarCloneBackend --skill database-data-generation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-data-generation
Source: https://github.com/Hieubkav/wincellarCloneBackend/tree/main/.claude/skills/database/database-data-generation
Command: npx skills add https://github.com/Hieubkav/wincellarCloneBackend --skill database-data-generation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @faker-js/faker.

What problem does it solve?

Automates generation of realistic seed data and test fixtures using Faker, maintaining relational integrity across schemas.

Core Features & Use Cases

  • Seed data generation and test fixtures
  • Relational integrity across tables
  • Multiple export formats (SQL, JSON, ORM seeds)
  • Customization for volume and format

Quick Start

Run seed scripts to populate dev/testing databases.

Frequently Asked Questions about database-data-generation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate realistic seed data for database testing?▼

Seed data generation automates creation of realistic test fixtures using Faker libraries, populating your database with coherent records across multiple tables while maintaining foreign key relationships. This eliminates manual fixture creation and ensures consistent, repeatable test environments.

Can I generate seed data that maintains relationships between tables?▼

Yes, this Skill analyzes your database schema and generates data with relational integrity preserved across tables. It automatically handles foreign key constraints so dependent records reference valid parent records.

What export formats are supported for seed data?▼

Generated seed data exports in multiple formats: SQL scripts, JSON, JavaScript, Python, and ORM-specific formats. Choose the format matching your development workflow and database tooling.

How do I customize the volume and types of test data generated?▼

The Skill accepts customization parameters to control data volume, field values, and formats before generating executable seed scripts. Configure generation rules to match your specific testing scenarios and requirements.

Does seed data generation work with Faker libraries?▼

Yes, this Skill uses @faker-js/faker to generate realistic, varied data for testing. Faker produces authentic-looking values for names, emails, addresses, and other common fields across generated records.

When should I use seed data instead of manually writing test fixtures?▼

Use seed data generation when you need large volumes of test records, consistent relational structure, repeatable test scenarios, or rapid database population for development and demonstration. Manual fixtures become impractical at scale.

Related Skills

Explore More Data & Analytics Skills→
Nick777-PixelNick777-Pixel

drizzle

Generate TypeScript ORM migrations and models from Drizzle schema definitions for PostgreSQL projects.

Community
Intermediate
AIA-11-HN-MIBAIA-11-HN-MIB
1

db-seeder

Seed PostgreSQL, MySQL, SQLite, and MongoDB databases with Faker-based fake data.

Official
Intermediate
JaiminVadadoriyaJaiminVadadoriya
1

database-testing

Validate database integrity and test forward and backward migrations.

Community
Advanced
pradyumnasagarpradyumnasagar
6

agent-handoff

Automate inter-skill data transfer and provenance capture via JSON Material Passports.

Community
Advanced