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
Plans
Every plan and priceSnowfakery
Open source
Getting started
- Open the Snowfakery documentation website
- Install Snowfakery with pipx for non-Salesforce use
- Install CumulusCI when generating Salesforce records
- Create a YAML recipe
- Validate the recipe in strict or validate-only mode
- 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.