Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel
A free test data generator and API mocking tool - Mockaroo lets you create custom CSV, JSON, SQL, and Excel datasets to test and demo your software.
Categories:
Mockaroo is a realistic random data generator and mock API tool designed for developers, testers, and teams needing quick test datasets in CSV, JSON, SQL, Excel, and more.
🚀 Overview
Mockaroo is a web-based tool that generates large volumes of realistic, customizable test data to simulate production environments, avoiding the time-consuming and biased process of manual data entry. It supports formats like CSV, JSON, SQL, and Excel, and includes AI-powered field generation. Additionally, it allows designing mock APIs for prototyping UIs without waiting for backend development, enabling parallel workstreams.
It solves key pain points in software development and testing: lack of diverse, edge-case data for stress testing, demos, and QA; and delays in API availability.
Built for developers, testers, QA engineers, and even non-technical users who need fake but realistic data quickly. The creator aimed to make high-quality test data generation accessible without programming expertise.
✨ Key Features
- Generate up to 1,000 rows of realistic test data for free in CSV, JSON, SQL, Excel; unlimited via paid API.
- Over 100 data types (names, emails, IPs, etc.) plus AI-generated custom fields on any topic.
- Mock API builder: design endpoints, responses, delays, errors without code.
- RESTful API for automation, schema import from CSV/JSON/XML, formulas/functions.
- Enterprise self-hosting; Docker image, read-only sharing, advanced features like bcrypt hashing.
🛠 Tech Stack
- Backend: Ruby on Rails
- Database: PostgreSQL, Redis
- Containerization: Docker (Enterprise)
- Storage: Amazon S3 or Google Cloud Storage
- Auth: Google sign-in / OIDC
- Client: Node.js library (https://github.com/mockaroo/mockaroo-node)
- Email: Amazon SES / SendGrid
👥 Who Is This For?
This project is useful for:
- Developers who want to quickly prototype with mock data and APIs
- Teams looking for realistic test datasets to simulate production
- Testers and QA building comprehensive, varied test cases without manual effort
📸 Screenshots / Demo
- Live demo: https://www.mockaroo.com
- GitHub: https://github.com/mockaroo
🔥 Project Status
- 🟢 Actively building
Last updated: 2026-03-24
❓ FAQ
Is this project free?
Freemium (Up to 1,000 rows free; paid plans from $60/year for more rows, API calls, enterprise features).
Is the source code available?
No — main SaaS application is proprietary. Partial open source: Enterprise Docker setup at https://github.com/mockaroo/mockaroo-enterprise and Node.js client at https://github.com/mockaroo/mockaroo-node.
Can I contribute?
Yes, for public repos: open issues or submit PRs on GitHub (e.g., mockaroo-enterprise, mockaroo-node). Feature requests via forum.
📬 Contact & Links
- Website: https://www.mockaroo.com
- GitHub: https://github.com/mockaroo
- Twitter/X: https://x.com/mockaroodev
- Email: Via contact form on website or forum https://forum.mockaroo.com
Built with ❤️ and kept warm on WarmIndex.
Similar apps
Fess - Enterprise Search Server
fess.codelibs.org
Fess is a full-text search server that can be easily set up in just 5 minutes.
The Open Source Qualtrics Alternative
formbricks.com
Own your data, build better experiences.
Free Website Uptime Monitoring - Pulsetic
pulsetic.com
Monitor your webpage's status with our free website uptime monitoring service. Check live availability and receive real-time alerts, never miss any downtime.
Knock | Customer engagement infrastructure
knock.app
Knock is customer engagement infrastructure for your product, marketing, and transactional messaging. Activate your data, ship cross-channel messaging, and accelerate growth.