Snowfakery
Snowfakery: A developer-controlled way to generate relational test data from YAML recipes. Ranked #9 of 28 in Test Data Generation Tools by our editors (7.9/10); pricing: Open source; best for developer-controlled relational fixtures.
At a glance
- Editor score7.9 / 10
- PricingOpen source
- Best forDeveloper-controlled relational fixtures
- Paid fromFree
- Generation modesSynthetic
- Facts checked20 Sep 2026
Where it wins
- YAML recipes model relationships across generated records and tables.
- Outputs JSON, CSV, SQL, text, diagrams, and database records.
- Embeds in Python and supports Salesforce through CumulusCI.
Where it doesn't
- Self-hosted delivery requires teams to manage their own environment.
- The workflow is centered on YAML, Python, and command-line use.
- Salesforce output depends on the CumulusCI integration.
Our verdict on Snowfakery
Snowfakery is an open-source command-line and Python tool for generating synthetic test data from YAML recipes. It is aimed at developers, administrators, testers, and teams that need realistic datasets for testing, demonstrations, or development environments. Its central strength is relational fixture generation: recipes can create unique records, preserve relationships across tables and records, and repeat generation by scale or target record counts. That makes Snowfakery a fit for teams that want developer-controlled data rather than a hosted, point-and-click service.
The published feature set covers both data modeling and delivery. Synthetic fake-data providers and localization support help populate generated records, while Python plugins and custom providers extend the generation workflow. Outputs include JSON, CSV, SQL, text, and diagrams, with additional diagram formats supported through its category specifications. Database output is available through SQLAlchemy, covering SQLAlchemy-supported databases such as PostgreSQL and SQLite, and the generate_data API supports Python embedding. Salesforce teams can generate output through CumulusCI, giving the tool a defined path into that ecosystem.
Snowfakery’s breadth is useful when one recipe needs to serve several environments or output formats, but its operating model remains technical and self-hosted. Teams need to work with YAML recipes and may need Python for embedding, plugins, or custom providers. It is therefore a strong choice for developers who value repeatable relational fixtures, flexible outputs, and source-available control. Teams seeking a hosted commercial service or a less code-oriented workflow should consider a different category fit.
Your product? Our editors can test Snowfakery in depth and publish a review, labelled as paid · from $149/mo →
Snowfakery pricing
Snowfakery fact sheet
| Free plan | Not verified |
|---|---|
| Paid from | Free |
| Generation modes | Synthetic |
| Relational data | Yes |
| API data generation | Yes |
| Supported data formats | JSON, TXT, CSV, SQL, DOT, SVG, SVGZ, JPEG, PS, PNG |
| Deployment | Self-hosted |
| Generation limit | Not verified |
| Database connectors | PostgreSQL, SQLite, Salesforce, SQLAlchemy-supported databases |
| Deployment | Self-hosted |
| Support | Docs, Community |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 3 integrations: CumulusCI, Salesforce, SQLAlchemy |
| Pricing | Open source |
| Website | snowfakery.readthedocs.io |
| Facts checked | 20 Sep 2026 |
Snowfakery integrations
Snowfakery lists 3 integrations on its own site.
- CumulusCI
- Salesforce
- SQLAlchemy
Alternatives to Snowfakery
- MOSTLY AIA broad synthetic-data platform for enterprise relational data teams.9.4
- SynthesizedA database-focused platform for schema-faithful synthetic data and protected test environments.9.2
- Tonic FabricateA flexible choice for AI-assisted relational test data with API and export workflows.9.0
See all Snowfakery alternatives →
Used Snowfakery? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Snowfakery for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Snowfakery is listed in our Test Data Generation Tools directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/snowfakery/"><img src="https://www.itechguides.com/best/badge/snowfakery.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update