SQL Data Generator

This tool produces realistic, schema-driven SQL data and the corresponding SQL scripts to seed databases for development, testing, and demonstrations. It targets DBAs, engineers, QA teams, and data scientists who require repeatable datasets with controlled characteristics and proven referential integrity. Conceptually, a schema describes tables, columns, data types, constraints, and relationships; the engine generates rows per configured distributions and outputs CREATE TABLE and INSERT statements in selected dialects (PostgreSQL, MySQL, SQL Server). Core features include deterministic seeding, type-aware generators, constraint enforcement, and dialect-aware script formatting. Optional capabilities add foreign-key aware generation, custom value generators, data masking, locale-aware formatting, bulk inserts, and export options (CSV/JSON). Distinguishing factors include privacy-preserving modes and dialect-optimized syntax. Example usage: create 1,000 users with unique emails and plausible signup dates, then 10,000 orders referencing user IDs to test join performance and analytics pipelines. The tool emphasizes repeatability, privacy, and environment parity, enabling reliable testing and demos across teams and stages. It is designed to handle typical enterprise schemas and can scale with batching to manage memory usage.