What is deployment frequency, and how do you measure it in Metabase?
Deployment frequency is how often a team successfully releases to production. It's one of the four DORA metrics and the clearest signal of delivery throughput — elite teams deploy on demand, many times a day. Measure it in Metabase from GitHub or GitLab deploy data synced into a database.
What deployment frequency measures
It counts production releases per day/week, not commits or merges. High, steady frequency usually means small batch sizes and low-risk changes — which correlates with the stability metrics (change failure rate and MTTR) staying healthy.
- Restrict to
environment = 'production'. - Count only successful deploys (
status = 'success') — failed/rolled-back attempts aren't releases. - Segment by service/repo so a busy monolith doesn't mask quiet services.
What data does it need?
- A
deploymentstable:environment,status,created_at, andrepository_id/project_id. - GitHub: the Deployments API or Actions deploy workflows.GitLab: environments/deployments from CI/CD pipelines.
SQL patterns
SELECT
date_trunc('week', created_at) AS week,
COUNT(*) AS deployments,
COUNT(DISTINCT repository_id) AS services_deployed
FROM deployments
WHERE environment = 'production'
AND status = 'success'
GROUP BY 1
ORDER BY 1;SELECT
AVG(daily.deploys) AS avg_deploys_per_day
FROM (
SELECT date_trunc('day', created_at) AS day, COUNT(*) AS deploys
FROM deployments
WHERE environment = 'production' AND status = 'success'
AND created_at >= CURRENT_DATE - INTERVAL '28 days'
GROUP BY 1
) daily;Pitfalls
main is not a production release; join to real deploys.Where this metric applies
- GitHub + Metabase — Deployments API or Actions deploy workflows
- GitLab + Metabase — environments and deployment records from pipelines