Comparison · target: json schema faker vs mockaroo
json-schema-faker vs Mockaroo for Claims fixture for schema-vs-host comparison
User compares the free local library with the online SaaS.
Direct answer
For the Claims fixture for schema-vs-host comparison fixture, json-schema-faker and Mockaroo are built for generating values for one document, not for 7 constraints that decide whether the output loads.
The comparison holds for a schema of this size — 1 tables — and does not claim anything about runtime, community size or pricing.
A compatibility table below scores json-schema-faker and Mockaroo against the same Claims fixture for schema-vs-host comparison fixture; the foreign key row is decisive, because a document carries a dangling reference without any tool objecting until load time.
Data as of 2026-11-18 · source: 0 Stack Overflow questions, json-schema-faker at 4,376,957 monthly downloads · negative-case messages reproduced by executing the fixture against a local SQL engine (Node.js v24.22.0, engine 3.53.4) at 2026-11-18T11:53:54.233Z
The scorecard — Claims fixture
The scorecard is scored against one shared fixture: Claims fixture for schema-vs-host comparison, 1 tables and 5 columns. Each row states what a tool has to do for the output to load, and the note column says which property of the fixture decided the row. Rows are not weighted by preference; a row is decided by whether the output would load.
Where json-schema-faker wins
json-schema-faker is the better choice when the output is a single document: it reads the schema properties and generates a value for each one, which is what a unit test needs when the data carries no relationships. The Claims fixture for schema-vs-host comparison fixture is the shared reference for every row in the table above.
Where Mockaroo wins
Mockaroo is the better choice when the output is a single document: it reads the schema properties and generates a value for each one, which is what a unit test needs when the data carries no relationships. Neither of the two reads 7 constraints of this fixture as a database contract, which is the part a seed has to satisfy before a single row can be inserted.
How the rows were decided
Every row in the scorecard is decided by a property of the fixture, not by reading documentation. For Claims fixture for schema-vs-host comparison, the deciding fixture properties were the claims.amount_cents range declaration, the NOT NULL columns. A tool that misses any one of those produces output that a database will refuse.
A note on what this comparison does not cover
This comparison measures output correctness on one fixture. It does not measure runtime, community size, documentation quality or long-term maintenance, and it does not claim that either tool is wrong for your project. It also does not compare pricing, because every row is decided by the schema rather than by a price list: what a tool charges says nothing about whether its output loads.
| Criterion | SchemaSeed | Document generation | What decided it |
|---|---|---|---|
| Reads a multi-file OpenAPI document | yes | partial | both resolve local $ref chains |
| Honours NOT NULL | yes | partial | both read the required array |
| Honours enum, range and length declarations | yes | partial | the fixture declares claims.amount_cents with "amount_cents" > 0; the declaration is read out of the schema, the DDL carries it as a CHECK constraint and the value that breaks it ships as a negative case |
| Honours enum members | yes | partial | the enum array is copied verbatim |
| Produces SQL, not just JSON | yes | no | output format is the difference |
| Resolves foreign keys across schemas | yes | no | a single-schema faker has no second schema to read |
| Emits deliberately invalid instances | yes | no | negative cases are a separate output |
| Same seed produces the same bytes | yes | yes | both are seedable |
| Check | Result on this fixture | Consequence |
|---|---|---|
| More than one table references another | no | a per-schema faker is sufficient |
| Output has to be SQL, not JSON | yes — the target is PostgreSQL | a document generator produces the wrong artefact |
| Tests must assert the API rejects bad input | yes — a negative case for every declaration in the schema | negative instances have to be generated separately |
| Same seed must reproduce the same bytes | yes — seed 42 is fixed | fixtures can be committed and diffed |
npx --yes @wenlu8848/schemaseed generate --input ./cmp_claims.openapi.yaml --out ./seed --formats csv --count 10 --seed 42
Download cmp_claims.openapi.yaml
id,policy_ref,amount_cents,category,filed_at
ab6dacc6-28ec-4543-86ca-91597212dafb,vertex cedar,164,travel,2020-06-03T04:31:00.000Z
56c053af-8245-42aa-b16e-9bb51198ee4f,vertex umbra,146,travel,2025-05-22T03:02:43.000Z
2ce3c837-50e5-40c4-933b-0af796faba9e,Bao Holt,207,travel,2026-05-21T14:36:43.000Z
e34695f0-9531-4ddf-8424-25e1dd33f057,Chen Novak,353,home,2026-11-25T00:33:54.000Z
be65a388-8bba-4ff0-8aff-388101f7ac61,river-kelp-270,789,auto,2022-05-08T05:13:26.000Z
2d110d2c-e8d6-4c5f-b456-3c0b615e659a,quartz meadow,515,travel,2026-03-06T04:12:39.000Z
0083dc0f-cdcf-47ec-a1f3-c01b6d8f35e2,"Auckland, Harbor Road 111",634,home,2024-08-04T20:12:52.000Z
7d86102b-6f46-4534-a13c-64ae3e4825a6,"Nairobi, Harbor Road 5",543,home,2022-06-11T04:59:38.000Z
aa22e529-b183-452f-b40a-2cd1c603164a,omar.jansen@example.org,826,home,2026-08-25T11:34:04.000Z
9132ef9f-0c37-4f16-99bf-0747595a1523,"Osaka, Harbor Road 226",252,home,2023-05-16T16:43:03.000Z
Frequently asked questions
- Which one should I pick?
- If the output has to load into a database and the schema has relationships, take the schema-to-SQL tool. On Claims fixture for schema-vs-host comparison the deciding constraint was claims.amount_cents.
- How many criteria were compared?
- Eight, each decided by a property of the Claims fixture for schema-vs-host comparison fixture: 1 tables and 5 columns.
- Was this a benchmark?
- No. It is one 1-table fixture of 5 columns measured on whether the produced rows satisfy the schema, not on speed, memory or price.
- Do both tools produce deterministic output?
- Both are seedable, which is why the Claims fixture for schema-vs-host comparison rows can be committed and diffed; on this fixture that is the one property the two share.
Run it against your own schema
SchemaSeed is MIT licensed and free: unlimited local generation, no account, no telemetry and no usage limit. It reads your schema file on your own machine, so nothing is uploaded anywhere. If it saves you time, you can support the project.
Get SchemaSeed — free Support the project
Questions: support@schemaseed.drz8848.win