Skip to content

Neon (Cloud Postgres)

Purpose: Canonical cloud Postgres — the production data store for all clean, processed data accessible from Windmill, Modal, and Cloudflare Workers.

URL/Endpoint: https://console.neon.tech

Auth: Connection string in Infisical. Connect from host using psycopg2 (Python). Use from ops.db_connect import get_connection — never hardcode connection strings.

Key Operations

  • Query and write production data via psycopg2 from the host machine
  • Inspect tables via DBeaver using the Neon connection string from Infisical
  • Run scripts: infisical run --env=dev -- python script.py (injects the connection string)

Dependencies

  • Infisical (connection string)
  • Local Postgres (staging — data is cleaned there before promotion to Neon)
  • ADR-128: LLM routing by data sensitivity — Neon holds business-sensitive data, Claude only

Runbook

CRITICAL: Never run docker exec postgres psql "NEON_URL" — the Docker container has no outbound internet. Always connect from the host machine via psycopg2. See liflode-scripts/python/ops/db_connect.py for the standard helper.