Seed a Database with Flock

​

Prerequisites

• Pidgeon CLI installed (dotnet tool install --global Pidgeon.CLI --version 0.1.0-beta.1)
• A database with an existing schema (PostgreSQL, MySQL, or SQL Server)
• Database credentials with read/write access

​

Step 1: Connect to your database

pidgeon flock connect \
  --provider postgres \
  --connection-string "Host=localhost;Port=5432;Database=ehr_dev;Username=dev;Password=${DB_PASSWORD}"

• Tables classified as patient, encounter, clinical, financial, or reference
• Foreign key relationships mapped
• Column types and constraints detected

​

Step 2: Learn patterns from existing data (optional)

pidgeon flock learn --tables patients,encounters,diagnoses --sample-size 500

• Column value distributions (age ranges, gender ratios)
• Referential patterns (which diagnosis codes appear together)
• Temporal patterns (encounter durations, admission-to-discharge intervals)

​

Step 3: Generate a synthetic population

pidgeon flock generate \
  --count 1000 \
  --format sql \
  --geographic-focus us \
  --seed 42

• Demographics: Age, gender, race, and geography distributions matching US Census data
• Comorbidities: Realistic disease correlations (diabetes with hypertension, obesity with sleep apnea)
• Temporal coherence: Admissions before discharges, lab orders before results
• Family linkage: Realistic household structures and family relationships

​

Step 4: Preview with dry-run

pidgeon flock seed --dry-run

​

Step 5: Seed the database

pidgeon flock seed

​

Step 6: Verify the results

# Check job analytics
pidgeon flock status

curl http://localhost:5102/api/flock/generate/{jobId}/analytics

​

Alternative output formats

pidgeon flock generate --count 1000 --format sql --output ./seed-data/

pidgeon flock generate --count 1000 --format csv --output ./seed-data/

pidgeon flock generate --count 1000 --format hl7 --output ./seed-data/

pidgeon flock generate --count 1000 --format fhir --output ./seed-data/

​

Clean up synthetic data

pidgeon flock seed --cleanup

curl -X DELETE "http://localhost:5102/api/flock/seed/cleanup?connectionString=Host%3Dlocalhost%3B..."

​

Next steps

• Explore output formats for HL7 streams and FHIR bundles
• Generate test messages from seeded population data
• Monitor interfaces processing your synthetic data