JSON Schema Faker vs Redgate SQL Prompt
JSON Schema Faker
json-schema-faker.js.orgRedgate SQL Prompt
red-gate.comSide by side
| Figure | JSON Schema Faker | Redgate SQL Prompt |
|---|---|---|
| Price from | Free | $17.50/mo |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Web | Yes | — |
| Windows | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | — |
| Self-hosted | Yes | — |
| Plans published | 1 | 3 |
| Spec score · Test Data Generation Tools | 7.9 (#6) | 7.5 (#18) |
| Integrations | Optional extensions support faker.js and chance.js, and YAML output requires the YAML package through an extension. | SQL Toolbelt Essentials adds integrations with SQL Dependency Tracker and SQL Compare. |
| Purpose | JSON Schema Faker generates valid JSON data from JSON Schema definitions. | SQL Prompt is an add-in for SQL Server Management Studio and Visual Studio that completes, formats, analyzes, fixes, and refactors SQL code. |
Plans
Redgate SQL Prompt
- SQL PromptPriced on request
- SQL Prompt$210 a year
- SQL Toolbelt Essentials$1,410 a year
In their own words
JSON Schema Faker
JSON Schema Faker generates synthetic JSON data from JSON Schema definitions. It supports JSON Schema 2019-09 and 2020-12, and a numeric seed can make results repeatable. The `jsf` command can read schema files, save generated JSON to a file, and produce multiple items as an array. Reference support includes `$ref` resolution with cycle detection, adjustable recursion depth, and remote reference resolution. Built-in generators cover formats such as email, date-time, URI, IP addresses, and UUID; regex patterns are supported through an AST-based string generator. Users can register custom formats and keyword generators, with optional extensions for faker.js and chance.js. YAML output requires the YAML package through an extension. The project runs in Node.js and browsers and is built for Bun and Node.js. It is self-hosted and open source under the MIT License, with zero production dependencies. The listed plan costs nothing. One constraint: synchronous generation works only when schemas resolve without I/O; asynchronous resolvers or extensions cause it to throw.
Redgate SQL Prompt
Redgate SQL Prompt has no write-up on Specifiction yet; its figures are above.