Mockaroo Alternatives: Free Test Data Up to 100,000 Rows
An honest look at Mockaroo's free tier limits and when a free alternative fits better. Row caps, API quotas, schema control and what each tool is actually for.
By VincentPublished July 25, 2026Last updated September 6, 20264 min read
A Mockaroo alternative needs to solve the part of your workflow that no longer fits. If you need more fixed-schema person rows, try the bulk exporter. If you need custom generation inside tests, use a library. If you need a visual schema designer with formulas and mock endpoints, compare those capabilities before switching.
Check which limit you actually hit
| Plan | Published price | Rows per file | API quota |
|---|---|---|---|
| Free | $0 | 1,000 | 200 requests/day |
| Silver | $60/year | 100,000 | 1 million records/day |
| Gold | $500/year | 10 million | 10 million records/day |
The free plan has no daily limit on browser file downloads [pricing]. A 1,000-row file ceiling is therefore different from a daily data allowance. Multiple downloads may solve a one-off need, but independently generated files still need unique keys and consistent relationships if you combine them.
Match the alternative to the missing capability
| Need | Candidate | Trade-off |
|---|---|---|
| A large CSV of person records | Fakenamely /bulk | Up to 100,000 rows, but only its existing fields |
| Custom orders, sensors or derived columns in code | Faker.js or a language-specific library | You write the rules and exporter |
| A visual schema and formulas | Mockaroo | Check the plan for the required file size |
| A configurable mock backend | Mockaroo Mock APIs | Generation API and mock endpoint behavior are different features |
| User-list demo records with photos | randomuser.me | Predefined user structure and a hosted dependency |
Mockaroo documents a Generate API and separate Mock APIs for chosen URLs, parameters and error simulation [docs]. Its schema designer and formulas address a task that Fakenamely does not implement [home]. A free library can still model custom schemas; the trade-off is writing code, not an absolute lack of free alternatives.
What Fakenamely provides
The browser exporter produces CSV, JSON or SQL from a fixed person schema, with selectable fields and a seed. It supports 38 country configurations and caps an export at 100,000 rows. Actual export time and memory use depend on the device and selected fields; this page does not claim a measured speed advantage.
The API needs no account or key. It has no daily cap, but does apply a best-effort rate limit around 120 requests per minute per IP, and identity/address/name requests are capped at 100 rows. Check the endpoint documentation for other limits. Cache a downloaded fixture when your suite must run offline.
Check address and reproducibility requirements
Fakenamely uses verified postal tuples for US locality selection, while some other country paths use curated prefixes or format fallbacks. A generated street is not a verified delivery point, and accidental resemblance to a real address is possible. For shipping-success tests, use the provider’s approved fixtures instead of treating any generator output as deliverable.
A seed repeats values under the same generation version, options and clock inputs. Saving a schema repeats its shape. Neither promise is an archive of a hosted service’s future output. Keep exact exported records for long-lived regression cases; see the seeding guide.
Try the migration on a small file
- Export the required columns and list any formulas or mock-response behavior you rely on.
- Generate a small candidate file before requesting the full row count.
- Check types, nulls, key uniqueness and parent-child joins after import.
- Confirm dates, Unicode and leading-zero identifiers survive the target parser.
- Keep the tool that covers the requirements with an acceptable amount of custom code.
For a broader shortlist, see six generators compared. For building the missing constraints yourself, use the test data generation workflow.
References & sources
- Mockaroo pricing and limits — Mockaroo
- Mockaroo Generate API and Mock APIs — Mockaroo
- Mockaroo schema designer and features — Mockaroo
Frequently asked questions
What is the Mockaroo free limit?+
Its pricing page lists 1,000 rows per file, no daily limit on browser file downloads and 200 API requests per day. Limits were checked on 6 September 2026.
What is a free Mockaroo alternative for 100,000 rows?+
Fakenamely exports up to 100,000 rows from its fixed person schema. If you need custom entities or joins, a library such as Faker.js lets you generate them in code, with volume limited by your implementation and machine.
Can Fakenamely replace Mockaroo formulas and mock APIs?+
No. Fakenamely has a fixed export schema and a data-generation API. It does not provide Mockaroo’s custom formula editor or configurable mock endpoints.
Is the Fakenamely API unlimited?+
No. It is keyless and has no daily quota, but uses a best-effort limit of roughly 120 requests per minute per IP and per-request row caps. Follow the current API documentation.
Does saving a schema reproduce the same data?+
It preserves the structure, not necessarily the generated values. Check the tool’s documented seed and version behavior. For an exact long-term fixture, save the output file.