Guides

SchemaSeed reads a schema in the browser and fills it with realistic rows. These pages explain the cases people usually need.

• Random data generator
  Generate test rows from a schema and download JSON, CSV, or SQL.
• Fake data generator
  Names, emails, cities, and sentences that look real.
• Test data generator
  Foreign keys, row limits, and messy values for QA.
• SchemaSeed and Mockaroo
  When to paste a schema here, and what Mockaroo still does.
• Mock data from a CREATE TABLE statement
  How column names and SQL types become rows.
• Generate SQL INSERT statements
  What changes between PostgreSQL, MySQL, SQL Server, and Oracle.
• Fake data from a CSV header
  Start from column names when you do not have DDL yet.
• PostgreSQL mock inserts
  Double quotes, true/false, and parent rows first.
• MySQL mock inserts
  Backticks and 1/0 booleans.
• SQL Server mock inserts
  Brackets, N'' strings, and 1/0 booleans.
• SQLite mock inserts
  A small file-friendly dialect for local apps.
• ClickHouse mock inserts
  Backticks, LowCardinality, and Nullable columns.
• Fake data in other languages
  Spanish, French, German, Portuguese, and the Pro languages.

Open SchemaSeed