Snowfakery review
A developer-controlled way to generate relational test data from YAML recipes.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
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.
Snowfakery pros and cons
- 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.
Snowfakery fact sheet, pricing and score →
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