Mockaroo
mockaroo.com
- Free plan
- Web
- API
- Self-hosted
What Mockaroo is
Mockaroo generates synthetic test data and can create mock back-end APIs for UI development. Users can select from more than 100 built-in data types, upload reference data, or build types using the formula API. Generate API output includes JSON, CSV, tab-separated text, custom-delimited text, SQL, and XML. Mock APIs can map request parameters to schemas and return dynamic or static data, or simulate errors. Both APIs require an API key, passed as a query parameter or an X-API-Key header. The Free plan is free and allows 1,000 rows per file and 200 API requests per day. Silver costs $60 a year, while Gold costs $500 a year. Synchronous API responses are capped at 5,000 records on every plan, and background generation requires a paid plan. Enterprise costs $7,500 a year and is distributed as a Docker image for private cloud or datacenter deployment. The service is aimed at developers and testers, including front-end developers working before a back end is ready.
Who it suits
Mockaroo suits developers and testers who need realistic test datasets or mock API responses. Front-end developers can use it while the back end is still being built.
Good to know, and what to watch
- Supports JSON, CSV, SQL, XML, and other output formats.
- Offers more than 100 built-in data types.
- Mock APIs can simulate errors or return static data.
- Enterprise supports private-cloud or datacenter deployment.
- Free plan allows 1,000 rows per file.
- Both APIs require an API key.
- Synchronous API responses are limited to 5,000 records.
- Background generation requires a paid plan.
- Free API access is limited to 200 requests per day.
Plans
Every plan and priceFree
Silver
Gold
Enterprise
Free plan
Getting started
- Open https://mockaroo.com/
- Choose web, API, or self-hosted use
- Select a Free, Silver, Gold, or Enterprise plan
- Define fields with built-in types, reference data, or the formula API
- Use an API key as a query parameter or X-API-Key header
- For Enterprise, deploy the Docker image in a private cloud or datacenter
Limits to check
The Free plan provides 1,000 rows per file and 200 API requests per day. Synchronous Generate API responses are limited to 5,000 records on every plan, and background generation is paid-only.
The Club's review
Overview
Mockaroo generates synthetic test data and provides mock back-end APIs for development work. It suits developers and testers who need configurable datasets or front-end developers working before a back end is ready. Its range of formats and API behaviors is useful, but daily quotas and a 5,000-record synchronous response ceiling make plan choice consequential.
Key features
Mockaroo can generate synthetic and relational data in CSV, JSON, SQL, Excel, TXT, custom-delimited text, and XML; the Generate API also supports tab-separated text. More than 100 built-in data types, uploaded reference data, and types built with the formula API provide room to shape records beyond generic placeholders. This breadth serves varied test workflows, though the Generate API cannot return more than 5,000 records in one synchronous response on any plan. Larger background generations require a paid plan.
Mock APIs can map request parameters to schemas, generate dynamic data, simulate errors, or return static data. That makes them useful when a front end needs to respond to changing requests or error cases rather than rely on fixed fixtures. Both Mockaroo APIs require an API key, passed as a query parameter or an X-API-Key header, so teams must account for key handling in their integrations. The supported client ecosystem includes an officially supported Node.js client and C# libraries mockaroo.api and NMockaroo.
Enterprise is distributed as a Docker image for a private cloud or datacenter, an option for organizations that need private deployment. Sensitive information submitted through the site is encrypted in transit, and access to personal information is limited to employees who need it for their jobs. Questions go to the Community Forum, where answers can benefit other users.
Pricing
The Free plan costs nothing and includes 1,000 rows per file, unlimited browser downloads, 200 API requests per day, 1x speed, all features, and hosting on mockaroo.com. It is a practical starting point for small browser-generated files and occasional API use, but the 200-request daily quota is a firm constraint for automated workflows.
Silver costs $60 a year, billed $60/year. It raises the file limit to 100,000 rows, keeps unlimited browser downloads and all features, increases the API allowance to 1 million records per day, and runs at 8x speed on mockaroo.com. This is the step up for regular generation that outgrows Free, although each synchronous Generate API response still tops out at 5,000 records.
Gold costs $500 a year, billed $500/year. It provides 10 million rows per file, 10 million API records per day, unlimited browser downloads, all features, and 8x speed, hosted on mockaroo.com. It suits high-volume work within those quotas, but it does not lift the synchronous response cap.
Enterprise costs $7,500 a year, billed $7500/year. It includes unlimited data and users, unlimited API calls, an 8x speed or higher, and a Docker image for private cloud or datacenter deployment. This is the plan for organizations whose scale or deployment requirements exceed hosted plans; its price is a substantial commitment compared with Silver and Gold.
Platforms
Mockaroo is available through the web and APIs, with self-hosted deployment offered through the Enterprise Docker image. That combination covers browser-based generation, integration into development workflows, and private infrastructure needs.
Who it's for
Mockaroo is a strong fit for developers and testers building realistic synthetic datasets, especially when they need multiple export formats or relational data. Front-end developers can use its mock APIs to develop against dynamic responses before production services are ready. It is less suitable when an API workflow depends on single synchronous responses above 5,000 records, or when a project needs more than the free daily request allowance but cannot justify a paid plan.
Pros and cons
- Pros: Broad file and API formats, relational generation, and more than 100 data types give teams flexibility in shaping test data.
- Pros: Mock APIs cover request-driven schemas, dynamic data, errors, and static responses, supporting front-end work beyond fixed fixtures.
- Pros: Enterprise combines unlimited data and users with private deployment, Docker delivery, and unlimited API calls.
- Cons: The 5,000-record synchronous response cap applies on every plan, including Gold and Enterprise; larger background generations require a paid plan.
- Cons: Free is capped at 200 API requests per day, while higher daily allowances require annual paid plans.
- Cons: Enterprise's $7,500 a year price puts private deployment and unlimited usage in a different budget category from hosted plans.
Alternatives
For a broader shortlist, browse Test Data Generation Tools or Test Data Management Software.
- dbForge Studio for PostgreSQL may suit PostgreSQL-focused work that calls for a visual data editor, SQL query history, and import and export alongside query tools.
- Benerator is an open-source option for Linux, macOS, Windows, API, or self-hosted use; its Community Edition is single-threaded and has no full graph support.
- JSON Schema Faker is a free MIT-licensed choice for teams comfortable installing it through npm or Bun.
- YData SDK is an alternative for teams seeking 20+ connectors and a free monthly credit, with pay-as-you-go also offered.
- Bogus is a free open-source .NET package for teams working with supported .NET Standard or .NET Framework versions.
- MOSTLY AI is another freemium option for API, web, Linux, or self-hosted use.
- Tonic Fabricate offers a free tier with $5 monthly credits, basic data exports, Discord support, and Tonic Cloud.
- DummyJSON is a free fake REST API available through API and web platforms.
Verdict
Choose Mockaroo if you need configurable synthetic datasets and mock API behavior in one service, with a clear path from browser downloads to higher-volume plans or private deployment. Its strongest reason to choose it is the combination of varied data generation and request-aware API mocks. Look elsewhere if the 5,000-record synchronous ceiling blocks your workflow or annual paid plans do not fit your budget.
The verdict
Mockaroo covers both generated datasets and mock API behavior, with formats and plan limits suited to different workloads. The synchronous response cap applies on every plan, and background generation requires a paid plan.
Questions people ask
Is Mockaroo free?
Yes. The Free plan costs nothing and includes 1,000 rows per file, unlimited browser downloads, and 200 API requests per day.
What do paid plans cost?
Silver costs $60 a year, Gold costs $500 a year, and Enterprise costs $7,500 a year.
Which platforms does Mockaroo support?
It is available through web, API, and self-hosted platforms. Enterprise is distributed as a Docker image for private-cloud or datacenter deployment.
Which output formats are available?
Generation supports CSV, JSON, SQL, Excel, TXT, custom-delimited text, tab-separated text, and XML.
Does Mockaroo provide API clients?
The documentation identifies an officially supported Node.js client and the C# libraries mockaroo.api and NMockaroo.
How is API access authenticated?
Both Mockaroo APIs require an API key passed as a query parameter or through an X-API-Key request header.
What the maker publishes
- API authentication
- Both Mockaroo APIs require an API key passed as a query parameter or an X-API-Key request header. source
- API limits
- The documentation lists daily API limits of 200 requests for Free, 1 million records for Silver, and 10 million records for Gold. source
- API mocking
- Mock APIs can map request parameters to schemas, generate dynamic data, simulate errors, or return static data. source
- Data types
- The Mock APIs page says users can choose from more than 100 built-in data types, upload reference data, or build data types with the formula API. source
- Deployment
- Mockaroo Enterprise is distributed as a Docker image for deployment in a private cloud or datacenter. source
- Integrations
- The API documentation identifies an officially supported Node.js client and lists C# client libraries mockaroo.api and NMockaroo. source
- Intended users
- Mockaroo describes its use for developers and testers who need realistic test data, and for front-end developers working before a back end is ready. source
- Notable limit
- The Generate API documentation says synchronous responses are limited to 5,000 records regardless of plan; background generation requires a paid plan. source
- Output formats
- The Generate API supports JSON, CSV, tab-separated text, custom-delimited text, SQL, and XML output. source
- Purpose
- Mockaroo generates realistic test data and can create mock back-end APIs for UI development. source
- Security
- Mockaroo's privacy policy says sensitive information submitted through the site is encrypted in transit and that access to personal information is limited to employees who need it for their jobs. source
- Support
- Mockaroo directs users with questions to its Community Forum so answers can benefit everyone. source
Checked against the maker's pages on 2 Oct 2026.