The `heroku connect:diagnose` CLI command provides an instant health check for Heroku Connect data pipelines syncing Salesforce with Heroku Postgres. Running it with `--verbose` outputs color-coded status flags (GREEN/YELLOW/RED) across two categories: connection environment checks (API version, permissions, database tier) and mapping/field validation checks (field types, schema alignment). Common warnings include outdated Salesforce API versions requiring connection recreation, unsupported binary or calculated fields that conflict with sync mechanics, and schema drift between Salesforce objects and the Postgres database. The tool replaces manual dashboard investigation and is recommended as a proactive check before database migrations or Salesforce schema changes.
