Skip to main content
Classifies tables as patient, encounter, clinical, financial, or reference — then maps foreign keys and infers column semantics like MRN fields, coded values, and date columns.

​
Supported Databases

DatabaseProvider String
PostgreSQLpostgres
SQL Serversqlserver

​
Connect

pidgeon flock connect \
  --provider postgres \
  --connection-string "Host=localhost;Port=5432;Database=ehr;Username=dev;Password=secret"

​
What Flock Detects

  • Table classification — Patient, encounter, clinical, financial, or reference tables
  • Relationship mapping — Foreign key detection and dependency ordering
  • Column type inference — Identifies MRN fields, date columns, coded values, free text
  • Healthcare patterns — Recognizes common EHR table naming conventions

​
API

# Connect and analyze
curl -X POST https://api.pidgeon.health/api/flock/connect \
  -H "Content-Type: application/json" \
  -d '{"provider": "postgres", "connectionString": "Host=localhost;Database=ehr;..."}'

# Retrieve analyzed schema
curl https://api.pidgeon.health/api/flock/schema