Generate realistic mock JSON, CSV & SQL payloads for testing and development. Custom schemas, server-powered, up to 100,000 rows instantly.
Dummy Data Generator is a server-side mock data generator that creates realistic test data in JSON, CSV, and SQL formats. When you need bulk test data for applications, databases, or APIs, this tool saves you from writing data manually. Everything is generated on the PHP server, so your browser never slows down.
Dummy Data Generator can generate up to 100,000 rows in a single request. Thanks to server-side processing, your browser remains completely free of load. If you need more, make multiple requests within your daily rate limit.
27+ built-in types: id, uuid, first_name, last_name, email, phone, address, city, country, company, job_title, date, datetime, boolean, integer (with min/max), float, price, url, ip_address, hex_color, sentence, paragraph, password_hash, credit_card, and custom_list with your own comma-separated values.
Select the Custom List type, then in the Meta field enter comma-separated values, for example: Red,Green,Blue or Pending,Shipped,Delivered. Each row will get a random value from your list.
For the Integer type, enter min,max in the Meta field, e.g. 1,100. If you leave it blank, the default range 0,9999 will be used automatically.
Batch size controls how many rows are included per INSERT statement. Smaller batches (100) keep statements lightweight and easier for databases to ingest. Larger batches (1000) reduce total file size. The default of 500 is recommended for most use cases.
Absolutely not. Data is generated on-the-fly and returned to you immediately. The server stores nothing. The rate limit is tracked only by IP address, not by the content of your requests.
To ensure fair usage of server resources, we allow 20 requests per IP per day. Each request can generate up to 100,000 rows — substantial for any testing scenario. The counter resets at midnight UTC. Your current usage is shown live in the toolbar.
Yes. Templates are just starting points. After loading one, you can add, remove, or edit columns, change names, types, and meta parameters freely. You have full control over the final schema before forging.
We follow RFC 4180: if a value contains a comma, double quote, or newline, the entire value is wrapped in double quotes, and any existing double quotes are escaped by doubling them. Safe import guaranteed for Excel, Google Sheets, or any standard CSV parser.
JSON output is an array of objects. Each object's keys are your column names. Example: [{"id":1,"name":"John"},{"id":2,"name":"Jane"}]. The JSON is pretty-printed with consistent indentation for readability.
Completely free. No signup, no credit card. The only limitation is the daily rate limit to keep the service available for everyone. Use unlimited schemas and templates, and make up to 20 requests per IP per day.