Schema Intelligence

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

Database	Provider String
PostgreSQL	`postgres`
SQL Server	`sqlserver`

Connect

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

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 http://localhost:5102/api/flock/connect \
  -H "Content-Type: application/json" \
  -d '{"provider": "postgres", "connectionString": "Host=localhost;Database=ehr;..."}'

# Retrieve analyzed schema
curl http://localhost:5102/api/flock/schema

Flock Overview Population Generation

Getting Started

Install

Desktop Apps

Post (Testing Tool)

Flock (Population Engine)

Loft (Observability)

Guides & Tutorials

Support

Supported Databases

Connect

What Flock Detects

API

​Supported Databases

​Connect

​What Flock Detects

​API

Supported Databases

Connect

What Flock Detects

API