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
Studio 3T Community Edition
robomongo.org
Studio 3T Community Edition (formerly Robomongo and Studio 3T Free) is the free, lightweight, MongoDB GUI with an embedded mongo shell, real auto-completion
Singlebase | Singlebase is an AI-native backend platform and Firebase alternative, combining document and vector databases, authentication, storage, and built-in AI services to power modern applications at scale.
singlebase.cloud
Singlebase is an AI-native backend platform and Firebase alternative, combining document and vector databases, authentication, storage, and built-in AI services to power modern applications at scale. Build and scale backend + AI services. Singlebase.cloud - Singlebase.ai - Singlebasecloud - Singlebasecloud.com
Diff Text - Compare Text Online
difftext.com
A simple diff checker tool to quickly find the difference between two blocks of text. Works with plain text, code, and more.
HeyForm: Open source form builder, built for small business success
heyform.net
Create surveys, quizzes, and polls with HeyForm's free form builder. Sign up now to craft beautiful, interactive online forms easily and quickly for FREE.