emirozer

fake2db: Generate Fake Test Databases Across Six Engines

fake2db is a Python CLI built on fake-factory for creating test databases populated with fake data. It supports SQLite, MySQL, PostgreSQL, MongoDB, Redis, and CouchDB, with options for row counts, locales, seeds, and custom fields.

InactivePythonGPL-2.0DatabaseCLITesting
View on GitHub Compare
Stars
2.3k
Forks
119
Stars, last 30 days
+0
Last commit
6.9 years ago
Contributors
16

Our take

Inactiveno commits in over a year

Health score

25/100

How it is scored
Activity
19
Community
38
Issues
21
Pull requests
20

+0 stars in the last 30 days

fake2db covers several database engines in a straightforward Python CLI, but its inactive status and highly concentrated contributions make it a legacy choice that should be evaluated before adoption.

Good fit if

  • You need fake test data in one of its six supported database systems and can install the relevant optional driver.
  • You are maintaining an existing workflow built around fake2db or can validate it against your current database setup.
  • Your use is compatible with its GPL-2.0 license.

Look elsewhere if

  • You need an actively maintained tool: the repository has had no commits in over a year, and there have been no releases in over a year.
  • You need ongoing issue handling or recent merged changes; none were recorded in the measured recent period.
  • Your project requires a more broadly maintained codebase, since most contributions come from one person.
All health signals
Last commit2019-11-25 (6.9 years ago)
Commits, last 90 days0
Releases, last 12 months0 (latest 1.0.0, 2019-03-09)
Contributors16 (top contributor: 84% of commits)
Issues closed, last 90 days0
Pull requests merged, last 90 days0
Project age12 years

Checked on 2026-10-29 with the GitHub API.

Project history

Daily GitHub snapshots since Oct 7, 2026. History covers stars and forks; health signals are not tracked historically.

Selected snapshot

Stars

2,342

Forks

119

Change since Nov 14, 2026: 0 stars·0 forks

Overview

fake2db is a Python command-line tool built on fake-factory that creates databases filled with fake but valid data for testing. It supports SQLite, MySQL, PostgreSQL, MongoDB, Redis, and CouchDB, giving developers a way to prepare sample data without hand-entering records.

It is aimed at developers and test teams who need populated databases for development or testing. You can generate a default dataset or choose fields, locale, and a seed; database-specific drivers are optional dependencies. See the README for full setup and usage details.

Key Features

  • Generates data for SQLite, MySQL, PostgreSQL, MongoDB, Redis, and CouchDB.
  • Sets the number of rows and, where applicable, connection host, port, username, and password.
  • Selects a locale for generated data, with en_US as the default.
  • Accepts a seed to reproduce generated datasets, though UUID4 values remain random.
  • Builds custom databases or tables from selected fields supported by the project.
  • Can be used with FoundationDB SQL Layer through the PostgreSQL generator and a specified port.

Use Cases

  • Developers preparing a local database with sample records before building or testing an application.
  • Test engineers creating populated test databases across one of the supported database engines.
  • Teams checking how their application handles localized data, using the locale option.
  • Developers reproducing test scenarios with a seeded dataset, while accounting for random UUID4 values.

What you need

Detected in the repository

  • Python (from setup.py)

License in plain words

GPL-2.0strong copyleft

  • Commercial use: yes
  • Modify and redistribute: yes
  • You must keep: the license notice
  • Share your changes: yes, the full source of anything you distribute that includes it, under the GPL

A summary, not legal advice: the LICENSE file is what applies.

Getting Started

Install the package from PyPI:

pip install fake2db

For example, generate 200 SQLite rows with fake2db --rows 200 --db sqlite. See the README for database-specific dependencies, connection options, and custom fields.

Considerations

  • The repository is marked inactive, with no commits in over a year and no recent releases. No issues were closed and no pull requests were merged in the measured recent period.
  • Contribution is concentrated: most of the code comes from one person, despite a wider contributor list.
  • Database drivers are optional and must be installed separately for PostgreSQL, MongoDB, Redis, MySQL, and CouchDB. PostgreSQL installation may also require pg_config and system packages.
  • Seeded runs do not make UUID4 values repeatable.
  • The project is licensed under GPL-2.0; review its terms for your intended use.

Found this useful?

Share it with someone who would like fake2db.

Comparisons