csv-data-synthesizer_skill

Overview

This skill generates realistic, production-quality CSV files with proper headers, consistent data types, and configurable row counts for testing, demos, and development. It produces UTF-8, Unix (LF) encoded .csv files named with the pattern {dataset-name}-data.csv and defaults to 20 rows when a count is not provided. The output follows strict formatting and validation rules to be import-safe and ready for pipelines or demos.

How this skill works

Given a domain template (customers, orders, products, employees, transactions, metrics, or survey responses) the skill selects appropriate fields, synthesizes realistic values and distributions, and enforces header and quoting rules. It ensures uniqueness for IDs, consistency among related fields (dates, postal regions, foreign keys), and injects sensible edge cases and empty optional fields to mimic real datasets. Final output is a complete CSV string ready to be saved as a .csv file following the naming convention.

When to use it

• Generate sample customer, order, product, employee, transaction, metrics, or survey CSVs for development
• Create import-ready test data for database migrations and ETL pipelines
• Produce demo datasets for product presentations or QA test cases
• Seed CI/CD tests with realistic and varied records
• Create daily or time-series CSVs for analytics tooling or dashboard testing

Best practices

• Specify the dataset name and desired row count; omit count to use default 20 rows
• Choose the domain template that matches your target schema to preserve realistic relationships
• Request specific fields or locales if you need international formats (phone, address)
• Validate output with your importer and use the included naming convention for automation
• Avoid formula-injection risks by keeping values free of leading =, +, -, or @ characters

Example use cases

• Generate 50 customer records with full address fields for CRM import testing
• Create a Q1 sales CSV with daily order totals for analytics dashboard development
• Produce employee dataset for HR system import, including hire_date and manager_id
• Build product catalog CSV with SKUs, prices, and inventory for storefront demos
• Synthesize time-series CPU metrics for load testing and visualization