MotionQL
Test data generator

Realistic test data in seconds

Describe a document template, or start from a collection's live schema, preview the rows, and insert up to a million documents or export them as JSON or CSV.

Capabilities

What you can do with it

Start from the schema

Build the template from a collection's live schema, or write your own.

Many generators

Names, emails, phones, addresses, companies, URLs, IPs, lorem text, numbers with uniform, normal or exponential distributions, dates, ObjectIds, UUIDs, patterns, enums with weights, sequences and geo points.

Nested documents and arrays

Objects, arrays and tuples to any depth.

References

Sample real _id values from another collection to keep relationships intact.

Presence and nulls

Control how often a field appears and how often it is null.

Repeatable

The same seed, template and locale give the same documents. Locales: English (US), German, French and Spanish.

Safe fake contacts

Emails and URLs use reserved example domains, and US phone numbers use the range reserved for fiction.

Insert or export

Preview, then insert up to 1,000,000 documents in batches, or export JSON, JSON Lines or CSV.

Related features

Your next query deserves a better IDE.

Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.