Skip to main content

Focalboard on Google Cloud Run

Focalboard on Google Cloud Run

Focalboard is a self-hosted, open-source Kanban and project-board server from the Mattermost project — a Go backend serving a built React frontend for managing tasks, boards, and workflows. This module deploys Focalboard 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 Focalboard 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.


What Focalboard costs on RAD, and how that compares​

In a Google Cloud project you own, Focalboard on RAD's Cloud Run module costs about US$102 a month, plus US$11 once per deployment and no per-user licence. GKE Autopilot is the alternative for workloads that must stay up continuously or run beside other Kubernetes apps; see the GKE guide, about US$150 a month. Focalboard is an open-source, self-hosted Kanban and project board tool (a Trello/Asana/Notion alternative) from Mattermost. Figures are as at 8 October 2026; sources are listed at the end of this section.

If this runs in a project RAD manages for you, it can be deleted and restored within 30 days for a few credits instead of sitting there running — so an occasional-use deployment costs a few dollars a month, not US$102. See Pause it for free, below.

What you pay on RAD​

In a Google Cloud project you ownIn a project RAD manages for you
Module fee, once per deployment110 credits (US$11 at the top-up price)99 credits (10% lower)
Build timeA few credits per buildThe same
Google Cloud running costBilled by Google to your own billing account, about US$102 a month for the default configuration (table below)Metered hourly in credits; RAD publishes 32 credits a day, about 960 a month (about US$96 at the top-up price)
Who owns whatYou own the project and its billing; RAD deploys and updates itRAD owns the project, with guardrails, quotas and budget alerts; you get console access, and a minimum purchased balance is held in reserve

10 credits cost US$1 on a one-off top-up, and less on a monthly plan. In a project RAD manages, the database, file server and network are shared by every application in the project, so a second application does not add a second database.

Default running cost in your own project (us-central1, Google list prices):

Resource (module default)Per month
Cloud Run, 2 vCPU / 4 GiB, scaling to zeroUS$32
Cloud SQL for PostgreSQL, 1 vCPU / 3.75 GB, zonal, 10 GB SSDUS$51
NFS/cache file server: a small VMUS$13
Cloud NAT gateway and IP addressUS$5
Cloud Storage for backupsUS$1
Totalabout US$102

How it compares​

We could not find a commercial managed/SaaS plan specifically for Focalboard itself as at 8 October 2026, so the honest comparison is against running it yourself:

OptionPer monthWho runs it
Hetzner CPX22 (2 vCPU/4GB)~US$24You: OS, updates, backups, security patches
DigitalOcean 2 vCPU/4GB DropletUS$24You: OS, updates, backups, security patches
GCP Compute Engine e2-standard-2 (2 vCPU/8GB)~US$49You: OS, updates, backups, security patches
RAD, Cloud Run, your own projectUS$102, plus US$11 onceRAD's automation, in your project
RAD, GKE Autopilotabout US$150; see the GKE Autopilot guideRAD
  • RAD is usually not cheaper in cash than a bare VPS — the difference is what is managed for you. A VPS price does not include the admin's own time for backups, security patches and OS upgrades; RAD's managed Cloud SQL (where this app uses a database), Secret Manager and monitoring cover that instead.
  • Focalboard is an open-source, self-hosted Kanban and project board tool (a Trello/Asana/Notion alternative) from Mattermost. That shapes which column matters: predictable, hands-off operation is worth more to most teams running this kind of tool than shaving a few dollars off the monthly bill.

Pause it for free: delete a RAD-managed project, restore it when you need it​

If Focalboard runs in a project RAD manages for you, you have an option beyond scaling down: delete the whole project, and restore it within 30 days for close to nothing. This suits a deployment you only need occasionally — studying for a certification, a demo, a seasonal need — far better than running it continuously.

  • How it works. Deleting a RAD-managed project unlinks its billing first, then asks Google to delete the project. Google does not remove it immediately: it keeps it, recoverable, for 30 days, and because billing is already unlinked, nothing is charged while it waits. Unlike deleting one module, this does not tear down Cloud SQL, the VM or Cloud Run one by one — the whole project, and everything in it, simply stops.
  • Restoring costs a handful of credits, not a rebuild. Within 30 days, the project's owner can restore it. RAD asks Google to undelete the project and reattaches its billing account, then asks you to run Update on each deployment to confirm everything came back. Because nothing was individually destroyed, that Update finds the same resources already there — it is a check, not a rebuild, and an Update never charges the module fee again. That costs a handful of build-time credits in total (under US$1) for a typical 2–3-deployment chain.
  • So a month of occasional use can cost a few dollars, not US$102. Deploy Focalboard, use it for a session, delete the project. Restore it next time you want it, confirm with Update, and delete it again when you're done. You pay only for the module fee once, the builds, and whatever hours it was actually live.
  • What this needs. You must own the project (not a bring-your-own one RAD only manages billing for), and you restore it yourself within the 30 days — after that, Google deletes it for good. Restoring is admitted like creating a new project: your purchased credit balance must still clear the tier's floor (100 credits for the sandbox tier most study/demo use fits). Google says most services are fully working again within 36 hours of a restore.
  • One real gap: nightly backups do not survive. Backups are written to a bucket inside the project, and that bucket has Cloud Storage's soft-delete explicitly turned off, so it is very likely gone as soon as you delete the project — even though the project itself is recoverable for 30 days. If you've customised this deployment and want to keep that work, copy a backup out (to Google Drive, or a bucket outside the project) before deleting. For a default install with nothing irreplaceable in it, this does not matter.

Pay only while you use it, the other way: delete and redeploy​

Cloud Run already scales to zero between requests, so most of its own compute cost stops on its own when nobody is using it. The option above only applies to a RAD-managed project; in your own project, or once the 30-day window has passed, the way to stop paying is to delete the deployment and deploy it again when you need it.

  • What a redeploy costs. The module fee again plus the builds: about 115 credits (US$11.50). Deleting saves money if Focalboard would otherwise sit unused for about 4 days or more in your own project (about US$3.40 a day), or about 4 days or more in a RAD-managed one (32 credits a day).
  • Delete everything Focalboard uses. Most of the running cost is usually the database and any shared file/cache VM. They stop only when nothing else in the project uses them, so deleting this app while something else shares the project saves only this app's own compute part.
  • Keep data first. Nightly backups go to a bucket inside the deployment and are deleted with it, so copy the latest backup out before deleting if you want to keep it.
  • Note your settings. RAD does not recreate a deleted deployment for you; you enter the settings again when you deploy.

Lab sessions and Managed Environments​

  • Lab sessions, for training. A trainer runs a session for a class. Each participant gets Focalboard in their own Google Cloud project for 15 minutes to 24 hours, within an allowance the trainer sets. Either the trainer funds every place, or each participant pays for their own. Everything is deleted when the session ends and unused credits go back to the trainer.
  • Managed Environments, for consultancies. A partner runs the app for a client from a ring-fenced wallet it funds, and settles with the client directly. If the wallet runs low, billing pauses and the data is kept, so nobody receives an unexpected charge. At the end the partner hands the project over and the deployments become the client's own.

Credits can be bought in more than 20 currencies, including XAF, XOF, NGN, GHS, KES and ZAR, by card, bank transfer or mobile money.

Sources (8 October 2026): Google Cloud list prices from the Cloud Billing Catalog API; RAD's own fees and daily-credit estimate from radmodules.dev/pricing; Delete and restore projects for the pause/restore mechanism. Prices change; check each source before relying on a figure.

1. Overview​

Focalboard runs as a single Go container on Cloud Run v2. The deployment wires together a focused set of Google Cloud services:

CapabilityGoogle Cloud serviceNotes
ComputeCloud Run v2Go service on port 8000, 2 vCPU / 4 GiB by default; serverless autoscaling with scale-to-zero
DatabaseCloud SQL for PostgreSQL 15Required — the engine is fixed (database_type = POSTGRES_15)
Attachment storageCloud Storage (GCS FUSE)A dedicated bucket mounted at /data via gcsfuse so uploaded attachments survive restarts
SecretsSecret ManagerAuto-generated FOCALBOARD_ADMIN_PASSWORD; database password managed by the foundation
IngressCloud Run URL / Cloud Load BalancingDefault 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; Focalboard has no MySQL or SQLite path in this module.
  • Focalboard reads config.json, not env vars, for the DB connection. A custom entrypoint regenerates /opt/focalboard/config.json from the Foundation-injected DB_* values on every start, so no DSN is baked into the image.
  • Attachments live on a gcsfuse-mounted GCS bucket at /data. Cloud Run has no block-PVC option, so enable_gcs_storage_volume = true mounts the storage bucket at the Focalboard filespath. Board data (cards, boards, users) lives in PostgreSQL; only uploaded files land on the bucket.
  • No Redis is used. enable_redis = false — Focalboard keeps all board state in PostgreSQL and needs no external cache or queue.
  • Scale-to-zero is enabled (min_instance_count = 0, max_instance_count = 5). Cold starts add a few seconds of latency to the first request after idle; set min_instance_count = 1 to keep an instance warm.
  • The image is a mirrored custom build. The official mattermost/focalboard image is thin-wrapped and mirrored into Artifact Registry; application_version defaults to 7.11.4, and latest maps to that pinned tag at build time (latest is not a published Focalboard tag).
  • Native auth, first-user-is-owner. authMode = native and public shared boards are enabled; the first account registered via the UI becomes the workspace owner. There is no pre-seeded admin.

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 Focalboard service​

Focalboard runs as a Cloud Run v2 service listening on port 8000, autoscaling 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" \
    --filter="metadata.name~focalboard"
    gcloud run services describe <service-name> --project "$PROJECT" --region "$REGION"
    gcloud run revisions list --service <service-name> --project "$PROJECT" --region "$REGION"

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

B. Cloud SQL for PostgreSQL 15​

Focalboard stores all board data (boards, cards, blocks, users, sessions) in a managed Cloud SQL for PostgreSQL 15 instance. The service connects privately — on Cloud Run over the VPC private IP with sslmode=require, or via the Cloud SQL Auth Proxy Unix socket when enable_cloudsql_volume = true; no public IP is exposed. On first deploy an initialization Job creates the application database and role.

  • 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 — attachment bucket​

A dedicated Cloud Storage bucket (the storage suffix) is provisioned automatically and mounted at /data via gcsfuse so uploaded board attachments persist across instance restarts and scale-to-zero. Additional buckets can be declared via storage_buckets.

  • Console: Cloud Storage → Buckets.
  • CLI:
    gcloud storage buckets list --project "$PROJECT"
    gcloud storage ls gs://<attachment-bucket>/ # bucket name is in the Outputs

See App_CloudRun for GCS Fuse and CMEK options.

D. Secret Manager​

One application secret is generated automatically and stored in Secret Manager: FOCALBOARD_ADMIN_PASSWORD (a 24-char random string, injected as a SERVICE secret env). A second, dedicated secret — secret-<resource_prefix>-focalboard-safe-db-password (alnum-only, no special characters) — overrides the SERVICE's DB_PASSWORD and is what db-init actually sets the Postgres role's password to (as FOCALBOARD_SAFE_DB_PASSWORD); the fleet-wide database_password_secret output does not authenticate against the role. See Section 3.

  • Console: Security → Secret Manager.
  • CLI:
    gcloud secrets list --project "$PROJECT" --filter="name~focalboard"
    gcloud secrets versions access latest --secret=<secret-name> --project "$PROJECT"

See App_CloudRun for injection and rotation details.

E. 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.

  • 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.

F. 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 entrypoint prints the resolved DB host, name, user, and sslmode at startup — useful for confirming the connection wiring.

  • Console: Logging → Logs Explorer; Monitoring → Dashboards / Alerting.
  • CLI:
    gcloud run services logs read <service-name> --project "$PROJECT" --region "$REGION" --limit 50

3. Focalboard 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 privileges, and reassigns the public schema owner to the app role so Focalboard can run its migrations. No Postgres extensions are installed. The job is safe to re-run.
  • The role's real password is a dedicated alnum-only secret, not database_password_secret. The Foundation's standard fleet-wide DB password (charset _%@) can contain a % that crashes Focalboard's Go postgres driver — its url.Parse-based DSN validation gate and its actual lib/pq connector disagree on percent-decoding, so no single encoding of that password satisfies both. Focalboard_Common generates a separate password (secret-<resource_prefix>-focalboard-safe-db-password), overrides the SERVICE's DB_PASSWORD with it, and passes it to db-init as FOCALBOARD_SAFE_DB_PASSWORD, which is what the role's password is actually set to. The database_password_secret output (§5) reports the fleet-wide secret name, which does not authenticate against this role.
  • Migrations run on start. Focalboard applies its own schema migrations on every boot as the application user, so upgrading application_version applies schema changes without a separate migration step.
  • config.json is generated at runtime. Focalboard has no env-var override for the DB connection; the entrypoint writes /opt/focalboard/config.json from the injected DB_* vars each start. On Cloud Run it connects over the private IP with sslmode=require (preferring DB_IP, since the Cloud SQL socket does not always materialise).
  • Health path. Startup, liveness, and readiness probes target / — the web UI, which returns 200 once the server binds its port and completes migrations. Allow up to ~7–8 minutes on first boot (60-second startup initial delay + a 15s×30 retry window).
  • First-run setup. Focalboard runs in authMode = native; open the service URL and register the first account, which becomes the workspace owner. enablePublicSharedBoards is on, so boards can be shared via public links.
  • Attachments vs. data. Board content lives in PostgreSQL; only uploaded files are written to the gcsfuse-mounted bucket at /data. If the bucket mount is missing, uploads fail but board editing still works.
  • Inspect the running config and jobs:
    gcloud run services describe <service-name> --region "$REGION" \
    --format='value(spec.template.spec.containers[0].env)'
    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 Focalboard are listed; every other input is inherited from App_CloudRun with its standard behaviour.

Group 3 — Application Identity​

VariableDefaultDescription
application_namefocalboardBase name for resources. Do not change after first deploy.
application_version7.11.4Focalboard image tag; latest maps to the pinned 7.11.4 at build time.
display_nameFocalboardHuman-readable name shown in the Console.

Group 4 — Runtime & Scaling​

VariableDefaultDescription
deploy_applicationtrueSet false to provision infrastructure only.
cpu_limit2000mCPU per instance.
memory_limit4GiMemory per instance.
min_instance_count00 enables scale-to-zero; set 1 to avoid cold starts.
max_instance_count5Maximum instances. Safe to raise — board state is in PostgreSQL, not per-instance.
container_port8000Focalboard listens on port 8000.
enable_cloudsql_volumetrueCloud SQL Auth Proxy socket; the entrypoint also falls back to private-IP TCP.
enable_image_mirroringtrueMirror the mattermost/focalboard image into Artifact Registry.
cpu_always_allocatedfalseRequest-based (cold-start) billing. Focalboard has no background workers or WebSocket server, so scale-to-zero is safe.

Group 12 — Database Backend​

VariableDefaultDescription
database_typePOSTGRES_15Fixed — Focalboard requires PostgreSQL 15.
application_database_namecrappdbCloud SQL database name, injected as DB_NAME. Immutable after first deploy.
application_database_usercrappuserApplication DB user, injected as DB_USER. Password auto-generated in Secret Manager.
enable_auto_password_rotationfalseOptional DB password rotation.

Group 13 — Jobs & Scheduled Tasks​

VariableDefaultDescription
initialization_jobs[]Leave empty to use the built-in db-init job.

Group 14 — Observability & Health​

VariableDefaultDescription
startup_probeHTTP /, 60s delay, 10s timeout, 15s period, 30 retriesStartup probe. Allow ~7–8 minutes on first boot for migrations.
liveness_probeHTTP /, 60s delay, 5s timeout, 30s period, 3 retriesLiveness probe.
uptime_check_config{ enabled=false, path="/" }Cloud Monitoring uptime check; disabled by default.

Group 21 — Redis​

VariableDefaultDescription
enable_redisfalseFocalboard does not require Redis; leave off.

All other inputs follow standard App_CloudRun behaviour and defaults.


5. Outputs​

Returned on a successful deployment — the quickest way to locate and explore the running resources.

OutputDescription
service_nameCloud Run service name.
service_urlDefault run.app URL of the service.
service_locationRegion the service runs in.
stage_servicesStage-specific service details (Cloud Deploy).
load_balancer_ip / load_balancer_urlExternal HTTPS load balancer IP / URL (when enabled).
database_instance_nameCloud SQL instance name.
database_name / database_userApplication database name / user.
database_password_secretSecret Manager secret holding the standard fleet-wide DB password — not the credential Focalboard's Postgres role authenticates with (see Section 3); use secret-<resource_prefix>-focalboard-safe-db-password instead.
database_host / database_portDB endpoint / port.
storage_bucketsCreated Cloud Storage buckets (the attachment bucket).
network_name / network_exists / regionsVPC network, presence, regions.
container_image / container_registryDeployed image and Artifact Registry repo.
monitoring_enabled / monitoring_notification_channels / uptime_check_namesMonitoring status, channels, uptime checks.
initialization_jobsNames of the setup jobs (db-init).
deployment_id / tenant_id / resource_prefixNaming identifiers.
project_id / project_numberProject identifiers.
cicd_enabled / github_repository_url / github_repository_owner / github_repository_name / cicd_configurationCI/CD status and details.
artifact_registry_repository / cloudbuild_trigger_name / cloudbuild_trigger_idRegistry and build trigger.
vpc_sc_enabled / vpc_sc_perimeter_name / vpc_sc_dry_run_modeVPC-SC status.
audit_logging_enabled / artifact_registry_cmek_enabledAudit logging and CMEK status.

6. Configuration Pitfalls & Sensible Defaults​

Risk: Critical (data loss / outage / security) — High (service degraded) — Medium (cost or partial degradation) — Low (minor).

Inherited plan-time validation. This module passes its configuration through the App_CloudRun foundation engine, which validates values and combinations at plan time — an IAP configuration with no authorized identities, a gen1 runtime with GCS mounts, a database_type that does not match an enabled extension, an out-of-range backup_retention_days. Invalid configuration fails the plan with a clear, named error before any resource is created.

SettingSensible valueRiskConsequence if wrong
application_database_name / application_database_userSet onceCriticalInjected as DB_NAME/DB_USER and immutable after first deploy; renaming recreates the DB/user and orphans all board data.
Attachment bucket / enable_gcs_storage_volumeKeep the gcsfuse mount at /dataCriticalWithout a persistent mount at filespath, uploaded attachments are written to ephemeral instance disk and lost on restart / scale-to-zero.
database_typePOSTGRES_15CriticalAny other engine breaks Focalboard startup — there is no MySQL/SQLite path here.
application_versionPin a real tag (7.11.4)Highmattermost/focalboard:latest is not a published tag; the build maps latest to the pinned FOCALBOARD_VERSION, but pinning explicitly avoids surprises.
container_port8000HighFocalboard binds 8000; a mismatched port makes the startup probe never pass.
enable_redisfalseMediumFocalboard needs no Redis; enabling it wires an unused dependency.
min_instance_count1 for latency-sensitive useMediumScale-to-zero (0) adds cold-start latency to the first request after idle.
enable_cloudsql_volumetrueMediumThe entrypoint falls back to private-IP TCP with sslmode=require, but the Auth Proxy socket is the primary path.
database_password_secret outputDon't use it to connectHighReports the fleet-wide DB_PASSWORD secret, which does not authenticate against Focalboard's Postgres role. Retrieve secret-<resource_prefix>-focalboard-safe-db-password for a working credential.

For the foundation behaviour referenced throughout — service identity, scaling and concurrency, ingress and load balancing, CI/CD, Cloud Armor, IAP, Binary Authorization, VPC-SC, backups, and image mirroring — see App_CloudRun. Focalboard-specific application configuration shared with the GKE variant is described in Focalboard_Common.

Need RAD to do something it does not do yet? Request it on the roadmap, or vote on what is already there.