FakerForge
fakerforge.com
What it is
FakerForge generates synthetic datasets, seeds mock databases, and publishes mocked API endpoints. Users can upload SQL schemas or migration files, set row counts and field rules, and generate records that follow schema relationships. Supported databases or destinations include MySQL, PostgreSQL, SQLite, MariaDB, MongoDB, and BigQuery. Exports are available as SQL, JSON, CSV, or XML. Mock endpoints can return configurable fake JSON payloads for success states, errors, edge cases, and timeouts. Its open-source CLI can inspect local or private PostgreSQL and MySQL databases and push generated records into their tables. CLI install options cover Linux, macOS, and Windows on amd64 and arm64; database credentials stay in the operating system keychain, and only schema shape is uploaded. FakerForge describes generated records as synthetic, without real names, email addresses, or phone numbers. The free plan is free, billed monthly; BASIC is $10 a month and PRO is $20 a month, both billed monthly. Generation and API or mocking actions can be capped by plan limits, with high request volume potentially throttled or rejected.
Spec sheet
- What it does
- FakerForge generates synthetic datasets, seeds databases and publishes scenario-based REST API mocks.Read 15 Oct 2026 · fakerforge.com
- Purpose
- FakerForge generates synthetic datasets, seeds mock databases, and publishes mocked API endpoints.Read 7 Oct 2026 · fakerforge.com
- Audience
- The site identifies developers, QA engineers, data analysts, and product teams as users of FakerForge.Read 7 Oct 2026 · fakerforge.com
- Support
- The contact page invites users to email for integration help, enterprise licensing, or product questions.Read 7 Oct 2026 · fakerforge.com
- AI data sharing
- The privacy policy says schemas and messages may be shared with AI providers such as OpenAI to provide assistant features.Read 15 Oct 2026 · fakerforge.com
- AI generation
- The service generates names, emails, addresses, timestamps, UUIDs and custom field types using AI-assisted mappings.Read 15 Oct 2026 · fakerforge.com
- API limit behavior
- Rows are capped by plan limits, successful calls consume quota, and exceeding the API allowance returns HTTP 429.Read 15 Oct 2026 · fakerforge.com
- API mocking
- Mock endpoints support success, error, edge-case and timeout scenarios with configurable JSON payloads.Read 15 Oct 2026 · fakerforge.com
- CLI
- The open-source CLI connects to private PostgreSQL or MySQL databases and pushes generated rows directly into tables.Read 15 Oct 2026 · fakerforge.com
- CLI credential handling
- The CLI stores database credentials and API keys in the operating-system keychain and sends only schema shape to FakerForge.Read 15 Oct 2026 · fakerforge.com
- CLI credentials
- The site says CLI database credentials stay in the operating system keychain and only schema shape is uploaded.Read 7 Oct 2026 · fakerforge.com
- CLI databases
- The open-source CLI introspects local or private PostgreSQL and MySQL databases and can push generated data into their tables.Read 7 Oct 2026 · fakerforge.com
- CLI platforms
- The CLI is offered through an install script, Homebrew, Go installation and binaries for Linux, macOS and Windows on amd64 and arm64.Read 15 Oct 2026 · fakerforge.com
- Database integrations
- Officially listed database targets include MySQL 5.7/8, PostgreSQL 13–16, SQLite, MariaDB 10/11, MongoDB and BigQuery.Read 15 Oct 2026 · fakerforge.com
- Database support
- The site lists MySQL, PostgreSQL, SQLite, MariaDB, MongoDB, and BigQuery among its supported databases or destinations.Read 7 Oct 2026 · fakerforge.com
- Documented quota limits
- Large row targets can be capped, generation can fail after quota exhaustion, mock creation can stop at plan maximums and high request volume can be throttled or rejected.Read 15 Oct 2026 · fakerforge.com
- Export formats
- Exports include SQL, JSON, CSV, XML, BSON-ready JSON, newline-delimited JSON and Parquet.Read 15 Oct 2026 · fakerforge.com
- Independent package extensibility
- The separate Python project supports custom Faker providers, seeded generation, schema validation and optional NumPy, pandas and YAML extras.Read 15 Oct 2026 · github.com
- Independent package identity
- A separate PyPI project also named FakerForge describes itself as a Python synthetic-data framework built on Faker; the page provides no link to fakerforge.com.Read 15 Oct 2026 · pypi.org
- Independent package licence
- That separate PyPI project declares an MIT licence.Read 15 Oct 2026 · pypi.org
- Independent package maturity
- The separate PyPI project is classified as Alpha and lists one maintainer.Read 15 Oct 2026 · pypi.org
- Independent package popularity
- The separate GitHub repository shows one star and zero forks.Read 15 Oct 2026 · github.com
- Independent package release
- PyPI records version 0.2.0 of the separate package as released on October 5, 2026.Read 15 Oct 2026 · pypi.org
- Independent package requirement
- That separate PyPI project requires Python 3.10 or newer.Read 15 Oct 2026 · pypi.org
- Limit: independent package execution
- The separate Python project states that generation execution is single-threaded.Read 15 Oct 2026 · github.com
- Limit: independent package relationships
- The separate Python project documents that many-to-many relationships are not supported.Read 15 Oct 2026 · github.com
- MCP integrations
- The MCP server is described as compatible with GitHub Copilot, Claude Desktop, Cursor, Windsurf and other MCP clients.Read 15 Oct 2026 · fakerforge.com
- MCP tools
- Documented MCP tools generate data, list and fetch schemas, add or remove tables and columns, and create or inspect API mocks.Read 15 Oct 2026 · fakerforge.com
- News: CLI launch
- A FakerForge blog post dated October 2, 2026 describes terminal-based PostgreSQL and MySQL seeding with the CLI.Read 15 Oct 2026 · fakerforge.com
- Privacy collection
- The privacy policy says FakerForge collects account details, uploaded schemas, configurations, mock definitions, assistant messages, usage data and technical logs.Read 15 Oct 2026 · fakerforge.com
- Privacy limitation
- The privacy policy tells users not to upload real personal data, production database dumps or secrets.Read 15 Oct 2026 · fakerforge.com
- Public data API
- Authenticated clients can fetch generated rows with GET /api/{schemaId}/{table}, bearer tokens, column selection and page/limit pagination.Read 15 Oct 2026 · fakerforge.com
- Relational generation
- Generated records preserve foreign-key relationships and referential consistency.Read 15 Oct 2026 · fakerforge.com
- Schema generation
- Users can upload SQL schemas or migration files, set row counts and field rules, and generate records that respect schema relationships.Read 7 Oct 2026 · fakerforge.com
- Schema input
- Users can paste SQL, upload migration files or define tables manually; the parser detects columns, relationships, constraints and foreign keys.Read 15 Oct 2026 · fakerforge.com
- Security guidance
- MCP documentation advises keeping tokens out of source control, rotating them after personnel changes and using least privilege.Read 15 Oct 2026 · fakerforge.com
- Synthetic data
- The site describes generated records as 100% synthetic and says they contain no real names, email addresses, or phone numbers.Read 7 Oct 2026 · fakerforge.com
- Usage limits
- The documentation says generation, API, and mocking actions can be capped by plan limits, with high request volume potentially throttled or rejected.Read 7 Oct 2026 · fakerforge.com
Plans and prices
Strong points and limits
Strong points
- Generated records follow schema relationships.
- Exports include SQL, JSON, CSV, and XML.
- Mock APIs cover errors, edge cases, and timeouts.
- CLI credentials stay in the operating system keychain.
- Free plan includes 100 rows per table.
Limits
- Free plan allows one mock API.
- Free plan limits API requests to 500.
- Usage actions may be capped by plan limits.
- High request volume may be throttled or rejected.
Who it suits
FakerForge suits developers, QA engineers, data analysts, and product teams who need synthetic data, mock databases, or API scenarios. Its CLI can also serve teams working with local or private PostgreSQL and MySQL databases.
FakerForge in depth
Read the full write-up
FakerForge is a synthetic-data generator that also seeds databases and mocks APIs. It is best for developers and QA teams who need connected test records alongside controllable endpoint behavior. The combination is useful, but the plan quotas and request caps will shape how far it can serve a busy project.
Overview
Upload a SQL schema or migration, set row counts and field rules, and FakerForge generates records that follow schema relationships. That makes it a better fit for populating structured test databases than for producing isolated sample records. It also combines database seeding and API mocking, so teams can prepare data and exercise response scenarios in one workflow; generation and request limits make it less suited to sustained high-volume work.
Key features
Schema-based generation: Related records can reflect an existing database structure, useful when tests depend on relationships between tables. Row and table ceilings determine how much each plan can create.
Database support and exports: Supported destinations include MySQL, PostgreSQL, SQLite, MariaDB, MongoDB, and BigQuery. SQL, JSON, CSV, and XML output gives teams several ways to move records into other workflows.
API scenarios: Configurable fake JSON payloads can cover success states, errors, edge cases, and timeouts. This is more useful for QA than a single static response, although mock and API request caps can constrain repeated or broader testing.
CLI and integrations: The open-source CLI introspects local or private PostgreSQL and MySQL databases and can push generated data into their tables. Install options cover Linux, macOS, and Windows on amd64 and arm64. CLI credentials stay in the operating system keychain, and only schema shape is uploaded. The MCP server works with GitHub Copilot, Claude, Cursor, Windsurf, and other compatible clients.
Synthetic records and automation: FakerForge describes its generated records as fully synthetic, without real names, email addresses, or phone numbers, and supports automated refresh. Generation, API, and mocking actions may be capped by plan limits; high request volume may be throttled or rejected.
Pricing
The Free plan costs nothing, billed per month. It includes 1 database, 50,000 AI tokens, up to 100 rows per table and 10 tables per database, 500 API requests, 1 mock API, 5 endpoints per mock, 2 scenarios per endpoint, and 500 mock requests. It is a practical starting point for small datasets or a limited proof of concept, but the single database and modest request allowances leave little room for parallel projects or frequent testing.
Basic costs $10 a month, billed per month. It raises the allowances to 5 databases, 1,000,000 AI tokens, 1,000 rows per table, 20 tables per database, 10,000 API requests, 10 mock APIs, 50 endpoints per mock, 10 scenarios per endpoint, and 10,000 mock requests. This is the more workable choice for a small team or recurring QA cycle, though its row ceiling is still far below Pro's.
Pro costs $20 a month, billed per month. It includes 20 databases, 5,000,000 AI tokens, 100,000 rows per table, 50 tables per database, 50,000 API requests, 50 mock APIs, 100 endpoints per mock, 50 scenarios per endpoint, and 100,000 mock requests. The much higher per-table and request ceilings make it the strongest fit for larger or busier test workloads; teams needing more capacity should account for the stated possibility of throttling or rejected high-volume requests.
Platforms
FakerForge supports API, Linux, macOS, web, and Windows. The CLI specifically offers Linux, macOS, and Windows installs for both amd64 and arm64.
Who it's for
Developers, QA engineers, data analysts, and product teams can use FakerForge to create synthetic datasets, seed mock databases, and exercise mocked endpoints. It is particularly well matched to teams that need schema-linked test records and multiple API response scenarios together. A project requiring large datasets or sustained request volume should compare its expected usage with the plan caps before committing.
Pros and cons
Pro: Schema and migration inputs preserve relationships, making generated data more relevant to structured database tests.
Pro: Database seeding, several export formats, and API scenario mocking cover adjacent test-data tasks in one product.
Pro: The CLI can write to local or private PostgreSQL and MySQL databases while keeping credentials in the operating system keychain.
Con: The free tier is limited to one database, 100 rows per table, and 500 API and mock requests, so it is a constrained option for repeated or broader test runs.
Con: Even though Pro expands row and request allowances substantially, high request volume may still be throttled or rejected.
Alternatives
For a narrower synthetic-data task, Synth Studio is free, runs across API, Linux, macOS, self-hosted, web, and Windows, and allows up to 1M rows per generation under an MIT license. Choose it when that generation allowance and license matter more than FakerForge's combined seeding and API-mocking workflow.
REaLTabFormer is free, MIT-licensed software for Linux, macOS, self-hosted, and Windows, and requires Python 3.7 or later. It is a fit when those platform and licensing terms suit the project better.
SimpleTest offers a free Starter plan with 50 parallel test runs per month, 500 execution minutes per month, and AI-generated datasets limited to one per test. Choose it when test execution allowances are the priority rather than FakerForge's database seeding and API-mocking combination.
Synthehol Dataset has a free plan with 1,000 credits per month, 50K rows per month, 5 projects, 5 datasets, 1 user, 1 GB of storage, 30 days of retention, and CSV and JSON formats. It is worth considering when those project, storage, and retention limits fit the need.
IRI DarkShield is a paid alternative with a free trial and API, Linux, macOS, self-hosted, and Windows platforms.
NVIDIA ShadowPlay is a free Windows option requiring Windows 10 or 11, GeForce driver 551.52 or later, and a supported GPU.
Anyverse is a paid web-based alternative with a free trial.
MOSTLY AI has a free tier and supports API, Linux, self-hosted, and web platforms; choose it if those platform options better suit the deployment.
Browse AI Synthetic Data Generators or Test Data Management Software for more options in these categories.
Verdict
FakerForge is a strong choice for developers and QA teams who want schema-aware synthetic records, database seeding, and configurable API mocks in one workflow. Its main advantage is that breadth, backed by a CLI for local or private PostgreSQL and MySQL databases. Look elsewhere if the expected workload will regularly exceed the plan quotas or request limits.
Verdict
FakerForge brings schema-based synthetic data generation, database seeding, and API mocking together. Check the plan quotas and request limits against the intended workload.
Where Specifiction places it
- AI Synthetic Data Generators#1 of 259.4
- Test Data Management Software#1 of 259.2