Mockaroo
Realistic test data generator that creates up to 1,000 rows per file in CSV, JSON, SQL, and Excel formats, with a mock API endpoint for live testing.
Use Cases
Free Tier
1,000 rows per file, 200 API requests/day, all features included
How to Maximize the Free Tier
Use the web UI to define your schema with 70+ built-in types (names, addresses, dates, etc.) — no signup needed. Download CSV/JSON/SQL directly. For API mocking, sign in with Google to get a REST endpoint that returns your schema on demand (200 requests/day). Use the formula editor to create complex derived fields. Export schemas to share with your team. For larger datasets (100K+ rows), the $60/year Silver plan is worth it.
Getting Started
Go to mockaroo.com → Define fields by clicking 'Add another field' → Choose data types (first name, email, etc.) → Set row count (max 1,000 free) → Select format (CSV/JSON/SQL) → Click 'Download Data' → For API: sign in → copy the REST URL → use it in your app.
Pros
- No signup required: Generate and download data instantly without creating an account — just define schema and download
- Rich data types: 70+ built-in types including addresses, phone numbers, credit cards, and custom formulas with regex support
- Mock API included: Free tier includes 200 API requests/day — enough for local development and prototyping
Cons
- Row limit: Free tier caps at 1,000 rows per download — need Silver ($60/yr) for 100K+ rows
- API rate limit: 200 API requests/day may not be enough for integration tests in CI/CD pipelines
- No offline mode: Requires internet connection — no local CLI tool for air-gapped environments