For Developers & Small Teams

Stop Wrestling With
Broken Foreign Keys

Tired of manual seed scripts that break every schema change? Foreign key violations killing your productivity?

Generate constraint-safe, realistic test data in 5 minutes. Point Aphelion at your PostgreSQL database, and it handles the rest.

Free forever for local development. No credit card required.

terminal
$ aphelion clone postgres://localhost:5432/mydb --output schema.json
✓ Introspected 12 tables, 47 columns, 15 foreign keys

$ aphelion generate schema.json --output ./output --seed 42
✓ Generated 12 files in 0.4s

$ cd ./output && ./load.sh postgres://localhost:5432/mydb_test
✓ Loaded 12,000 rows in 0.8s
✓ Zero foreign key violations
5 min
Setup Time
0
FK Violations
FREE
Local Dev

Built for Developer Productivity

No configuration files. No coding. Just works.

Zero Configuration

Point at your database. Aphelion introspects the schema and generates smart defaults. No YAML, no JSON editing required.

Constraint-Safe

Handles circular dependencies, foreign keys, NOT NULL constraints. Topological sorting ensures perfect referential integrity.

Deterministic

Use --seed flag for reproducible data. Same seed = same data. Perfect for debugging and team collaboration.

CI/CD Ready

--auto-approve flag for automated pipelines. --truncate for clean slate testing. Integrates with GitHub Actions, GitLab CI.

Blazing Fast

~10,000 rows/second. Generate 100K rows in 10-15 seconds. Minimal overhead for constraint checking.

PostgreSQL Native

Supports ltree, JSONB, arrays, enums, custom types. Handles complex PostgreSQL features out of the box.

Get Started in 3 Steps

From zero to realistic test data in 5 minutes

1

Download & Install

curl -O https://algomimic.com/#download-form
chmod +x aphelion
./aphelion --version

Single binary. No dependencies. Linux x64 (macOS & Windows coming soon)

2

Clone Your Schema

./aphelion clone postgres://localhost:5432/mydb \
  --output schema.json

Introspects your database and creates a JSON config with smart defaults.

3

Generate Data

./aphelion generate schema.json \
  --output ./output --seed 42

cd output && ./load.sh postgres://localhost:5432/mydb_test

Generates realistic, constraint-safe data. Same seed = same data every time.

Perfect For

Local Development

Spin up realistic test databases for feature development without waiting for production dumps

Integration Tests

Generate fresh test data for every CI/CD run. Deterministic seeds ensure reproducible tests

Load Testing

Generate millions of rows to stress-test your queries and indexes

Ready to Stop Fighting Foreign Keys?

Free forever for local development. No credit card required.

Need more than 1,000 rows? Check out Pro for unlimited rows and CI/CD features.