microsoftmicrosoftOfficialยท1 Agent Skills Included

pg_durable

Run fault-tolerant background workflows directly inside PostgreSQL

Builds long-running, crash-proof SQL workflows that checkpoint every step and resume automatically after restarts or failures. Replaces fragile cron jobs, worker queues, and status tables with durable execution inside Postgres, with no external services required. Generates correct pg_durable SQL for pipelines, parallel fan-out, approvals, HTTP calls, and scheduled maintenance tasks.
npx skills add microsoft/pg_durable --all -g -y

All Skills in This Repository (1)

Pure Emerald Level Indicators

Frequently Asked Questions

FAQPage Schema
How to install pg_durable?โ–ผ

Run `npx skills add microsoft/pg_durable --all -g -y` in your terminal to install the skill globally. The extension itself is added to PostgreSQL via a Debian package, Docker image, or `CREATE EXTENSION pg_durable;`.

What problem does pg_durable solve?โ–ผ

It makes long-running database jobs survive crashes and restarts by checkpointing each step, so you never rerun completed work or rebuild state by hand.

Can pg_durable replace Airflow or Temporal?โ–ผ

For workflows that live mostly in Postgres, yes. It removes the need for external orchestrators, queues, and worker infrastructure by running durable execution as a PostgreSQL extension.

How do I write a durable workflow in SQL?โ–ผ

Compose steps with operators like `~>` for sequence, `&` for parallel, and `?>` for conditions, then launch the graph with `df.start()` to get an instance ID you can monitor.

Does pg_durable need extra infrastructure?โ–ผ

No. It runs entirely as a PostgreSQL extension with a background worker, so there is no Redis, message queue, or separate orchestration service to manage.

Related Repositories in Software Engineering

View All in Software Engineeringโ†’