Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Snowfakery

snowfakery.readthedocs.io

  • Free plan
  • Linux
  • API
  • Self-hosted

What Snowfakery is

Snowfakery creates synthetic records from YAML recipe files, including records linked across tables. Recipes can generate names, addresses, text, URLs, numbers and other values, then control how many related records each entry produces. The tool can write files in JSON, TXT, CSV, SQL, DOT, SVG, SVGZ, JPEG and PostScript formats; some diagram formats require Graphviz. It can also send output to SQLAlchemy-accessible databases or, through CumulusCI, to a Salesforce org.

Python applications can embed Snowfakery using its generate_data function, and Python plugins and providers can extend its functions. Strict mode checks a recipe before generation, while validate-only mode checks without creating data. Snowfakery is free, open source and self-hosted. Its documentation advises against running untrusted recipes where they could access secure resources. For database output, it creates new tables rather than loading existing ones, and generated columns are text. The project repository is archived and read-only.

Who it suits

Snowfakery suits developers and Salesforce users who need synthetic records, including relational data, from recipes. It can also fit Python applications that need to generate data or teams working with supported database connections.

Good to know, and what to watch

  • Generates related records from YAML recipes
  • Writes JSON, CSV, SQL and other formats
  • Can send records to Salesforce through CumulusCI
  • Embeds in Python applications
  • Offers recipe validation modes
  • Database output creates new tables only
  • Generated database columns are text
  • Only SQLite is included in the SQL URL test suite
  • Untrusted recipes may access secure resources

Snowfakery

Free

Open source

Getting started

  1. Open the Snowfakery documentation website
  2. Install Snowfakery with pipx for non-Salesforce use
  3. Install CumulusCI when generating Salesforce records
  4. Create a YAML recipe
  5. Validate the recipe in strict or validate-only mode
  6. Generate data to files, standard output, databases, or Salesforce

Limits to check

Database generation creates new tables rather than importing into existing tables, and generated columns are text. Snowfakery always creates an ID for each record, so target models must accept an ID field.

The verdict

Snowfakery offers flexible recipe-based generation for files, databases and Salesforce, with validation and Python extension options. Check the database table and column limits, and treat recipes as executable code when deciding where to run them.

Questions people ask

Is Snowfakery free?

Yes. It is free and open source, with no paid plans or usage limits stated.

Which outputs are supported?

File outputs include JSON, TXT, CSV, SQL, DOT, SVG, SVGZ, JPEG, PostScript, and PNG. It can also write to standard output, SQLAlchemy-accessible databases, and Salesforce through CumulusCI.

Can it generate relational data?

Yes. YAML recipes create related records and control the number of related objects per record.

Can Python applications use it?

Yes. Applications can embed Snowfakery through its generate_data function, with Python plugins and providers available for extension.

How is it installed?

The documentation directs non-Salesforce users to install with pipx and recommends CumulusCI for Salesforce use.

What the maker publishes

Database integration
Snowfakery can write to databases accessible through SQLAlchemy, including SQLite, and its documentation describes connecting to databases such as PostgreSQL, MySQL/MariaDB, and Oracle. source
Database limitation
For database output, Snowfakery currently creates new tables rather than importing data into existing tables, and generated columns are text. source
Database support
Snowfakery builds on SQLAlchemy connectors, but its documentation says only SQLite is included in its test suite for SQL dataset URLs. source
Database testing
Snowfakery is not proactively tested with every output database, and the documentation invites users to share their database experiences and report issues. source
Data generation
Recipes can generate fake names, addresses, text, URLs, and other values using Faker-based functions. source
Extensibility
Python plugins can add functions, and providers can add Faker capabilities to Snowfakery. source
File formats
File-based outputs include JSON, TXT, CSV, SQL, DOT, SVG, SVGZ, JPEG, and PS PNG. source
Generated data
Recipes can generate fake names, addresses, text, URLs, and other values, as well as random numbers. source
ID requirement
Snowfakery always generates an ID for each record and requires models that can accommodate an ID field. source
Installation
The documentation instructs non-Salesforce users to install Snowfakery with pipx and recommends installing CumulusCI for Salesforce use. source
Intended users
The documentation describes installation paths for Salesforce users and for users who want to use Snowfakery without Salesforce. source
Output destinations
It can write to standard output, databases accessible through SQLAlchemy, and Salesforce when used with CumulusCI. source
Output formats
File-based output includes JSON, TXT, CSV, SQL, DOT, SVG, SVGZ, JPEG, and PostScript formats, with some diagram formats requiring Graphviz. source
Purpose
Snowfakery generates unique, random fake data with relationships between tables from YAML recipe files. source
Python use
Snowfakery can be embedded in Python applications through its generate_data function. source
Relationships
Recipes can create related records and control how many related objects are generated for each record. source
Repository status
The Snowfakery GitHub repository was archived by its owner on September 18, 2026, and is read-only. source
Salesforce integration
When used through CumulusCI, Snowfakery can generate records in a Salesforce org. source
Salesforce integration
For Salesforce use, the documentation recommends installing CumulusCI, which includes Snowfakery and handles generating records into a Salesforce org. source
Security
The documentation warns that recipes can access much of Python's power, load plugins, and call Python methods, so it advises against running untrusted recipes where they can access secure resources. source
Validation
Strict mode validates a recipe before generation, and validate-only mode checks a recipe without generating data. source

Checked against the maker's pages on 9 Oct 2026.