Azimutt on Google Cloud Run

Azimutt is an open-source, next-generation database-schema explorer and ERD (entity relationship diagram) tool for real-world databases, built with Elixir/Phoenix. It lets teams explore, document, and design large schemas (thousands of tables), search across columns and relations, and share diagrams. This module deploys Azimutt on Cloud Run v2 on top of the App_CloudRun foundation, which provisions and manages the shared Google Cloud infrastructure.

This guide focuses on the cloud services Azimutt uses and how to explore and operate them from the Google Cloud Console and the command line. For the mechanics common to every Cloud Run application — service identity, ingress and load balancing, scaling and concurrency, CI/CD, Cloud Armor, IAP, Binary Authorization, VPC Service Controls, backups, and the deployment lifecycle — refer to the App_CloudRun foundation guide rather than repeating them here.

1. Overview

Azimutt runs as a single Elixir/Phoenix container on Cloud Run v2, listening on port 4000. The deployment wires together a focused set of Google Cloud services:

Capability	Google Cloud service	Notes
Compute	Cloud Run v2	Phoenix container, 2 vCPU / 4 GiB by default, serverless autoscaling; scale-to-zero enabled
Database	Cloud SQL for PostgreSQL 15	Required — Azimutt does not support MySQL or other engines
Object storage	Cloud Storage	A bucket is provisioned; uploads default to local ephemeral disk (`FILE_STORAGE_ADAPTER = local`)
Secrets	Secret Manager	Auto-generated Phoenix `SECRET_KEY_BASE`; database password
Image build	Cloud Build + Artifact Registry	Thin wrapper FROM `ghcr.io/azimuttapp/azimutt`, mirrored into Artifact Registry
Ingress	Cloud Run URL / Cloud Load Balancing	Default `run.app` URL; optional external HTTPS load balancer + custom domain

Sensible defaults worth knowing up front:

PostgreSQL 15 is mandatory. The database engine is fixed by the shared application layer; selecting any other engine breaks startup. All Azimutt project data (schemas, diagrams, layouts, users) lives in Postgres.
Azimutt connects to Postgres over private-IP TCP with SSL, not the socket. Ecto/postgrex cannot parse the Cloud SQL Unix-socket DSN, so the cloud entrypoint builds DATABASE_URL against DB_IP and sets DATABASE_ENABLE_SSL=true. The Cloud SQL socket is still mounted (enable_cloudsql_volume = true) purely so the db-init job can create the role/database without SSL.
SECRET_KEY_BASE is generated automatically and stored in Secret Manager. Rotating it after first boot signs out every active session; only rotate in a maintenance window.
Scale-to-zero is enabled by default (min_instance_count = 0, cpu_always_allocated = false). Azimutt is a request/response app and a cold start reconnects to Postgres cleanly. Cold starts add a few seconds of latency after idle; set min_instance_count = 1 to avoid them.
Migrations run automatically on every boot. The container command is /app/bin/migrate && /app/bin/server, so a version upgrade applies its schema changes on start — allow extra time on the first boot.
application_version = "latest" maps to Azimutt's main tag. Azimutt publishes no :latest tag; pin to a specific release in production.
Sign-up is open by default. Azimutt lets anyone with the URL create an account. Restrict access after creating your first account (custom domain + IAP, or Azimutt's own auth settings via environment_variables).

2. Google Cloud Services & How to Explore Them

All commands assume PROJECT and REGION are set. Service and resource names are reported in the deployment Outputs.

A. Cloud Run — the Azimutt service

Azimutt runs as a Cloud Run v2 service that autoscales by request load between the minimum and maximum instance counts. Each deployment creates an immutable revision; traffic can be split across revisions for safe rollouts.

Console: Cloud Run → select the service for revisions, traffic, logs, and metrics.

CLI:

gcloud run services list --project "$PROJECT" --region "$REGION"
gcloud run services describe <service-name> --project "$PROJECT" --region "$REGION"
gcloud run revisions list --service <service-name> --project "$PROJECT" --region "$REGION"
# Confirm the composed DB wiring the entrypoint logged at boot:
gcloud run services logs read <service-name> --project "$PROJECT" --region "$REGION" \
  --limit 50 | grep cloud-entrypoint

See App_CloudRun for scaling, concurrency, execution environment, and traffic splitting.

B. Cloud SQL for PostgreSQL 15

Azimutt stores all application data (schemas, diagrams, layouts, users, sources) in a managed Cloud SQL for PostgreSQL 15 instance. On Cloud Run the service connects over the instance private IP with SSL (DATABASE_ENABLE_SSL=true) — Ecto cannot parse the socket DSN. On first deploy an initialization Job creates the application database and role; Azimutt then runs its own Ecto migrations on boot.

Console: SQL → select the instance for connections, backups, flags, metrics.

CLI:

gcloud sql instances list --project "$PROJECT"
gcloud sql instances describe <instance-name> --project "$PROJECT"
gcloud sql connect <instance-name> --user=<db-user> --database=<db-name> --project "$PROJECT"

The instance name, database, user, and password secret are in the Outputs. See App_CloudRun for the connection model, backups, and password rotation.

C. Cloud Storage

A Cloud Storage bucket is provisioned for Azimutt. With the default FILE_STORAGE_ADAPTER = "local", Azimutt writes file uploads to the container's local ephemeral disk rather than to this bucket; the bucket exists for operators who switch Azimutt to an S3-compatible file adapter. Project data itself lives in Postgres.

Console: Cloud Storage → Buckets.

CLI:

gcloud storage buckets list --project "$PROJECT"
gcloud storage ls gs://<bucket-name>/          # bucket name is in the Outputs

See App_CloudRun for GCS Fuse and CMEK options.

D. Secret Manager

The Phoenix SECRET_KEY_BASE is generated automatically and stored in Secret Manager (used to sign and encrypt session cookies). The database password is managed separately by the foundation.

Console: Security → Secret Manager.

CLI:

gcloud secrets list --project "$PROJECT" --filter="name~secret-key-base"
gcloud secrets versions access latest --secret=<secret-name> --project "$PROJECT"

See App_CloudRun for injection and rotation details.

E. Cloud Build & Artifact Registry

Azimutt's image is a thin wrapper built FROM ghcr.io/azimuttapp/azimutt; Cloud Build produces the wrapped image and it is mirrored into Artifact Registry (enable_image_mirroring = true). The base tag comes from the AZIMUTT_VERSION build arg (with latest mapped to main).

Console: Cloud Build → History; Artifact Registry → Repositories.

CLI:

gcloud builds list --project "$PROJECT" --limit 5
gcloud artifacts docker images list <region>-docker.pkg.dev/$PROJECT/<repo> --include-tags

F. Networking & ingress

The service is reachable at its run.app URL by default. An external HTTPS load balancer with a custom domain, Cloud CDN, and Cloud Armor can be layered on; ingress settings and VPC egress control connectivity. VPC egress is required so Azimutt can reach the Cloud SQL private IP.

Console: Cloud Run (service URL); Network services → Load balancing.

CLI:

gcloud run services describe <service-name> --region "$REGION" --format='value(status.url)'
gcloud compute addresses list --project "$PROJECT"

See App_CloudRun.

G. Cloud Logging & Monitoring

Container logs flow to Cloud Logging; Cloud Run and Cloud SQL metrics flow to Cloud Monitoring, with optional uptime checks and alert policies. The cloud-entrypoint lines show the resolved DATABASE_URL path, PHX_HOST, and PORT.

Console: Logging → Logs Explorer; Monitoring → Dashboards / Alerting.

CLI:

gcloud run services logs read <service-name> --project "$PROJECT" --region "$REGION" --limit 50

3. Azimutt Application Behaviour

First-deploy database setup. An initialization Job runs db-init.sh using postgres:15-alpine. It idempotently creates the application role (LOGIN CREATEDB) and database, grants ALL on the database and the public schema, and ALTERs the schema owner — Azimutt needs full DDL rights because it runs its own migrations. The job is safe to re-run.
Migrations run on start. The container command is /app/bin/migrate && /app/bin/server, so Ecto applies pending migrations on every boot before the Phoenix endpoint binds. Upgrading application_version applies schema changes automatically — no separate migration step.
Runtime DB wiring is composed by the entrypoint. DATABASE_URL is built from the injected DB_* vars, the password is URL-encoded, and on Cloud Run the connection uses the private IP (DB_IP) with DATABASE_ENABLE_SSL=true. PHX_HOST is derived from the injected service URL (scheme stripped).
SECRET_KEY_BASE is stable and effectively immutable. It is generated once and written to Secret Manager. Rotating it invalidates every active session cookie — all users are signed out. Only rotate in a maintenance window.
Health path. The startup and readiness probes target the Phoenix root / — the first endpoint that returns 200 once the server has booted and connected to Postgres. Allow ~1–2 minutes on first boot for migrations (the startup probe provides a 60-second initial delay plus a retry window).
First-run setup. Open the service URL and create the first Azimutt account through the sign-up page. Sign-up is open by default — restrict access afterwards.

Inspect the init job execution:

gcloud run jobs list --project "$PROJECT" --region "$REGION"
gcloud run jobs executions list --job <job-name> --project "$PROJECT" --region "$REGION"

4. Configuration Variables

Variables are grouped exactly as they appear on the deployment platform. Only settings specific to or notable for Azimutt are listed; every other input is inherited from App_CloudRun with its standard behaviour.