citusdata/pg_cron

Health v2 · maintenance only

Adoption not part of the score

3872 stars · 260 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pg_cron is a cron-based job scheduler for PostgreSQL that runs inside the database as an extension. It uses a background worker to track and execute periodic SQL jobs defined in the cron.job table using standard cron syntax.

Use cases

• schedule periodic SQL jobs in PostgreSQL
• run database maintenance tasks nightly
• clean up old rows on a schedule
• run recurring queries every few minutes
• schedule jobs with second-level intervals
• replace external cron for database tasks

When to choose

• you need periodic jobs that live inside PostgreSQL
• you want cron syntax for scheduling SQL commands
• you want to avoid external schedulers for database tasks

When to avoid

• you need scheduling outside the database
• you use PostgreSQL versions older than 10
• you need distributed job orchestration across services

Facets

library · maturity stable

scheduling database workflow-automation databases developer-tools self-hosted postgresql-extension cron background-jobs sql automation linux macos docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="citusdata/pg_cron")