mockaroo.comMockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel

mockaroo Schemas Datasets Mock Apis Scenarios Projects Functions Upgrade Now Generate Data Preview Save As... Derive from Example... More Looking to generate fake data based on your production data ? Mimic your databases with a trial account from Need some mock data to test your app? Mockaroo lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats. Need more data? Plans start at just $60/year. Mockaroo is also available as a docker image that you can deploy in your own private cloud. Field Name Type Options ​ Row Number blank: % ​ ​ First Name blank: % ​ ​ Last Name blank: % ​ ​ Email Address blank: % ​ ​ Gender blank: % ​ ​ IP Address v4 blank: % ​ Add another field Generate fields using AI... # Rows: ​ Format: CSV ​ Line Ending: Unix (LF) ​ Include: header BOM Mock your back-end API and start coding your UI today. It’s hard to put together a meaningful UI prototype without making real requests to an API. By making real requests, you’ll uncover problems with application flow, timing, and API design early, improving the quality of both the user experience and API. With Mockaroo, you can design your own mock APIs , You control the URLs, responses, and error conditions. Paralellize UI and API development and start delivering better applications faster today! Why is test data important? If you’re developing an application, you’ll want to make sure you’re testing it under conditions that closely simulate a production environment. In production, you’ll have an army of users banging away at your app and filling your database with data, which puts stress on your code. If you’re hand-entering data into a test environment one record at a time using the UI, you’re never going to build up the volume and variety of data that your app will accumulate in a few days in production. Worse, the data you enter will be biased towards your own usage patterns and won’t match real-world usage, leaving important bugs undiscovered. Why is realistic data important? When your test database is filled with realistic looking data, you’ll be more engaged as a tester. When you demonstrate new features to others, they’ll understand them faster. Real data is varied and will contain characters that may not play nice with your code, such as apostrophes, or unicode characters from other languages. Testing with realistic data will make your app more robust because you’ll catch errors that are likely to occur in production before release day. Why Mockaroo? There are plenty of great data mocking libraries available for almost every language and platform. But not everyone is a programmer or has time to learn a new framework. Mockaroo allows you to quickly and easily to download large amounts of randomly generated test data based on your own specs which you can then load directly into your test environment using SQL or CSV formats. No programming is required. Want to automate test data generation? If you sign in using your Google account, you can download random data programmatically by saving your schemas and using curl to download data in a shell script via a RESTful url. What’s new in Mockaroo? 3/12/2024 Added mobile device data types. 11/23/2023 Added a Medical Beneficiary ID data type for the US Medicare system. 11/1/2023 You can now use the generate(datatype) function in Formulas to generate data with any of Mockaroo’s built-in data types. 10/11/2023 You can now return records from a dataset in a Mock API using the from_dataset function. 7/2/2023 Added search boxes to each page. 7/1/2023 Added the ability to create reusable functions. 6/24/2023 Fixed a long standing bug in Sequence where the repeat parameter is not used correctly. 6/10/2023 The Password data type now allows you to customize the requirements. Added a new Password Hash type that returns the bcrypt hash of a random password. Added a new bcrypt(str) function to formulas. 5/7/2023 You can now generate more than 5000 records per file using the API with the new ?background=true parameter. 4/15/2023 You can now derive a schema from example CSV, JSON, or XML data. 4/15/2023 You can now generate your own custom data types using AI. 4/12/2023 You can now generate fields on any topic using AI 4/2/2023 Added support for XML attributes by naming fields starting with "@" 2/3/2023 Added the ability to generate v5 UUIDs via a new uuid_v5(namespace, name) function in formulas 1/22/2023 Added the ability to force the quote character on custom file formats. 1/4/2023 Added Address Line 2 type. 12/22/2022 Added a ULID data type. © 2024 Mockaroo, LLC. | Terms of Use | EULA |...