Fake Database — Free Online Fake Data Generator

Generate realistic fake data for software testing, prototypes, and demos. Export to CSV, Excel, JSON, SQL, XML, and YAML. No signup required.

What is Fake Database?

Fake Database is a free, browser-based tool that generates realistic fake data for developers, QA engineers, and data analysts. Unlike paid alternatives like Mockaroo ($49/month) or backend-dependent tools like Faker.js, Fake Database runs entirely in your browser — no server, no signup, no data sent anywhere.

With 120+ data fields across 19 categories, 15 quick templates, and 7 export formats, it's the most complete free fake data generator available online.

Key Features

120+ Data Fields

Names, addresses, emails, phones, financial data, health records, vehicles, entertainment, education, and more. All fields generate locale-aware data for US and Brazil.

15 Quick Templates

One-click templates for common use cases: Person, Company, Order, Employee, Product, Customer, Bank Account, Logistics, Patient, Student, E-commerce, SaaS User, Lead, Vehicle, Streaming.

7 Export Formats

Download your data as CSV, Excel (XLSX), JSON, SQL (CREATE TABLE + INSERT), XML, YAML, or view it in an interactive table with pagination.

Smart Correlations

Data is internally consistent: gender determines name, age determines salary, car brand determines model, disease determines medication. 40+ cross-field correlations.

Custom Columns

Add unlimited custom fields with SQL-like types: INT, BIGINT, VARCHAR, CHAR, TEXT, DECIMAL, FLOAT, BOOLEAN, DATE, DATETIME, UUID. Provide a list of possible values for each column.

Null & Error Injection

Configure null rates (0-50%) and error rates (0-50%) to test how your application handles missing and corrupted data.

Data Categories

Identification Names Contact Address Professional Financial Dates Numbers Product Personal Traits Entertainment Technology Vehicle Food & Drink Health Education Pet Fashion Other

Supported Formats

Use Cases

Software Testing & QA

Populate test databases with realistic data. Test form validation, API responses, and edge cases with null and error injection.

Prototyping & Demos

Quickly create mock datasets for UI development. Show stakeholders realistic data without waiting for backend APIs.

Database Practice

Learn SQL with realistic fake data. Generate CREATE TABLE and INSERT statements ready to run on any database.

Machine Learning

Create training datasets with known distributions. Generate large volumes of correlated data for model training.

US and Brazilian Data

Fake Database supports both American English (EN-US) and Brazilian Portuguese (PT-BR) data with locale-aware formatting:

Frequently Asked Questions

Is Fake Database really free?

Yes. Fake Database is 100% free with no limits. Generate up to 5,000 records per request. No signup, no credit card, no ads.

Is my data safe?

Absolutely. Fake Database runs entirely in your browser. No data is sent to any server. All generation happens locally on your device.

How is it different from Mockaroo?

Mockaroo charges $49/month for SQL export, Excel export, and custom columns. Fake Database offers all of that for free. Mockaroo also requires signup; Fake Database doesn't.

How is it different from Faker.js?

Faker.js requires a backend server (Node.js) and generates each field independently. Fake Database runs in the browser with cross-field correlations that make data internally consistent.

Can I generate Brazilian data?

Yes! Fake Database supports both US and Brazilian data, including CPF/CNPJ, Brazilian addresses, phone numbers, license plates, and culturally localized names, foods, and more.

What export formats are supported?

CSV, Excel (XLSX), JSON, SQL (CREATE TABLE + INSERT), XML, YAML, and an interactive table view.

Technology

Built with React 18, TypeScript, and Vite. Uses @dnd-kit for drag-and-drop field reordering, SheetJS for Excel export, and Web Workers for generating large datasets without blocking the UI. Deployed on Netlify. Open source on GitHub.

Ready to generate fake data? Enable JavaScript and the app will load automatically. Visit fakedatabase.com to get started.