ChaosData

What it is

Generate production-realistic test data mixed with chaotic edge cases for SQL and JSON databases including Postgres, MySQL, and SQLite.

ChaosData: the homepage

Quick answers

1. Will it break my schema constraints?

   No. Declared constraints are always respected including NOT NULL, UNIQUE, primary and foreign keys, VARCHAR lengths, UNSIGNED, enum membership and simple CHECK ranges. Anomalies target the things your schema doesn't say: the assumptions your code makes.

2. Will the generated data actually load?

   Yes. Output is ordered parent-first with valid foreign keys, wrapped in a transaction, and emitted in the syntax your database expects. If a generated row couldn't load, that's a bug.

3. What exactly gets injected?

   Emoji and combining marks, bidi and zero-width characters, long-but-legal strings, boundary and negative numbers where nothing forbids them, extreme timestamps, malformed emails and dates, and XSS/SQL-injection payloads. The JSON response reports how many anomalies were injected.

4. Is it free?

   Yes. The quick-generate endpoint is free to try while we gauge interest. Join the waitlist to hear when we go live with even more features.

5. Can I reproduce a specific dataset?

   Pass a seed and you'll get the exact same bytes every time. The seed is echoed in the metadata and in the SQL header.