Can I specify the amount of data to be generated?

Yes, you can request specific volumes in your prompt, such as 'generate 50 users' or 'populate the posts table with 200 entries.'

Are the generated scripts idempotent?

The skill follows best practices to create scripts that can be run multiple times without causing duplicate entry errors, typically using 'upsert' logic or 'truncate' commands.

What formats are supported for the seed scripts?

The skill can generate scripts in various formats including raw SQL, JavaScript (using TypeORM or Knex), and other common database migration formats.

How does the skill handle relationships between tables?

It analyzes foreign key constraints in your schema and generates data that links records correctly across tables to ensure referential integrity is maintained.

Does it work with existing database schemas?

Yes, the skill uses file analysis tools to read your current schema definitions before generating data that matches your specific table structures.

Database Data Seeder

Name: Database Data Seeder
Author: intent-solutions-io

byintent-solutions-io

0•

Database Management

Generates realistic test data and database seed scripts to populate development and testing environments while maintaining relational integrity.

The Database Data Seeder skill automates the creation of high-quality sample data for development, testing, and demonstration purposes. By analyzing your database schema and leveraging Faker libraries, it produces consistent, realistic records across multiple tables while strictly respecting foreign key constraints and data types. This tool is ideal for developers who need to quickly spin up pre-populated environments or create idempotent seed scripts without manually crafting complex SQL insert statements or JSON files.

Key Features

01Support for multiple output formats including SQL and JavaScript/TypeORM

02Schema-aware data generation using Faker libraries

030 GitHub stars

04Relational integrity maintenance for foreign key constraints

05Configurable data volumes for scalable environment testing

06Automated analysis of existing table structures and data types

Use Cases

01Populating a local development database with hundreds of realistic user profiles.

02Generating consistent test data for automated CI/CD pipeline integration tests.

03Creating complex, linked datasets for blog posts, comments, and authors for UI testing.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla data-seeder-generator

For use in Claude.ai and ChatGPT

Download Skill