Mockaroo vs Redgate SQL Prompt
Mockaroo
mockaroo.comRedgate SQL Prompt
red-gate.comSide by side
| Figure | Mockaroo | Redgate SQL Prompt |
|---|---|---|
| Price from | $5/mo | $17.50/mo |
| Free plan | Yes | — |
| Free trial | Yes | Yes |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| API | Yes | — |
| Self-hosted | Yes | — |
| Plans published | 4 | 3 |
| Spec score · Test Data Generation Tools | 7.9 (#7) | 7.5 (#18) |
| Integrations | The API documentation identifies an officially supported Node.js client and lists C# client libraries mockaroo.api and NMockaroo. | SQL Toolbelt Essentials adds integrations with SQL Dependency Tracker and SQL Compare. |
| Intended users | Mockaroo describes its use for developers and testers who need realistic test data, and for front-end developers working before a back end is ready. | Redgate describes SQL Prompt as a productivity add-in for SQL Server developers working in SSMS or Visual Studio. |
| Purpose | Mockaroo generates realistic test data and can create mock back-end APIs for UI development. | SQL Prompt is an add-in for SQL Server Management Studio and Visual Studio that completes, formats, analyzes, fixes, and refactors SQL code. |
| Support | Mockaroo directs users with questions to its Community Forum so answers can benefit everyone. | Product support is available to customers with a subscription or a support and upgrades package; Redgate also links documentation, help articles, forums, and training. |
Plans
Redgate SQL Prompt
- SQL PromptPriced on request
- SQL Prompt$210 a year
- SQL Toolbelt Essentials$1,410 a year
In their own words
Mockaroo
Mockaroo is a web-based synthetic data generator for developers and testers who need realistic test records or a mock back end while building a user interface. It offers more than 100 built-in data types; users can also upload reference data or define types with the formula API. The Generate API produces JSON, CSV, tab-separated or custom-delimited text, SQL, and XML. Mock APIs can connect request parameters to schemas and return dynamic or static data, or simulate errors. Both APIs require an API key, sent as a query parameter or an X-API-Key header. Free includes 1,000 rows per file and 200 API requests per day. Silver is $60 a year and allows 100,000 rows per file and 1 million API records per day; Gold is $500 a year and allows 10 million rows per file and 10 million API records per day. Synchronous API responses are limited to 5,000 records on every plan; background generation requires a paid plan. Enterprise is $7,500 a year, with unlimited data and users and Docker deployment in a private cloud or datacenter.
Redgate SQL Prompt
Redgate SQL Prompt has no write-up on Specifiction yet; its figures are above.