skills.rest
agoodway
agoodwayOFFICIAL
Explore all skills by this author →
GitHub

pgflow

Bootstrap PgFlow workflow engine and dispatch subcommands in Elixir/Phoenix apps.

1|Updated May 7, 2026
Search Tags:#elixir#phoenix#dag workflows#pgflow#pgmq#liveview debugging#postgres orchestration
One-click install
npx skills add https://github.com/agoodway/GoodSkills --skill pgflow
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pgflow
Source: https://github.com/agoodway/GoodSkills/tree/main/skills/pgflow
Command: npx skills add https://github.com/agoodway/GoodSkills --skill pgflow

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you set up and manage PgFlow DAG workflows in a Phoenix/Elixir app so background orchestration no longer depends on Redis queues or external schedulers.

Core Features & Use Cases

  • Bootstrap a Phoenix integration: install PgFlow deps, copy migrations, configure PgFlow, and add supervision tree wiring.
  • Scaffold workflow components: generate new flow modules, job modules, and add steps to existing flows with database compilation.
  • Operate and observe executions: mount the PgFlow dashboard, create LiveViews for real-time tracking, and inspect runs/debug failures (statuses, step states, errors, and retries).
  • Use Case: You need a reliable order-processing pipeline (validate → process → finalize) with retries and visibility; use PgFlow to compile it to database, enqueue runs, and debug step-level failures from the dashboard or via /pgflow debug.

Quick Start

Ask the AI to: Add PgFlow to my Phoenix app and walk me through creating a first flow, compiling it to the database, and starting a run.

Frequently Asked Questions about pgflow

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run multi-step workflows in Phoenix using Postgres instead of Redis?▼

You can run multi-step workflows in Phoenix using Postgres by bootstrapping PgFlow, which compiles DAG-based orchestration to the database and uses PGMQ with OTP for execution, eliminating the need for external Redis queues or schedulers.

How do I set up and manage DAG workflows in an Elixir application?▼

To set up DAG workflows in Elixir, you install the PgFlow dependency, copy migrations, configure the supervision tree, and then use the /pgflow subcommand interface to scaffold flow modules, compile jobs to the database, and enqueue runs.

Can I track and debug Postgres workflow executions in real-time with LiveView?▼

Yes, you can track and debug Postgres workflow executions by mounting the PgFlow dashboard and creating LiveViews for real-time tracking, allowing you to inspect run statuses, step states, errors, and retries via inspection queries.

Do I need an external scheduler for background orchestration in my Phoenix app?▼

No, you do not need an external scheduler for background orchestration in Phoenix because PgFlow provides PostgreSQL-backed execution using PGMQ and OTP, handling retries and operational visibility directly within your existing database.

What is the best way to debug step-level failures in Elixir Postgres workflows?▼

The best way to debug step-level failures in Elixir Postgres workflows is using the /pgflow debug command or the PgFlow dashboard, which provide inspection queries to view statuses, step states, errors, and retry history for failed runs.

How do I scaffold new flow and job modules for Phoenix Postgres orchestration?▼

You scaffold new flow and job modules for Phoenix Postgres orchestration by using the PgFlow subcommand interface to generate flow modules, add steps to existing flows, and compile the workflow directly to the database for execution.

Related Skills

Explore More Software Engineering Skills→
mkreymanmkreyman
10

elixir-quality-gate

Run Mix-based quality checks for Elixir/Phoenix projects.

Community
Intermediate
georgeguimaraesgeorgeguimaraes
167

phoenix-thinking

Review Phoenix LiveView apps to prevent database queries in mount.

Community
Intermediate
GoosLabGoosLab

moai-lang-elixir

Guide Elixir 1.17+ development with Phoenix 1.7, LiveView, Ecto, and OTP patterns.

Community
Advanced
zenbuappszenbuapps

bullmq-v5

Document BullMQ v5 queues, workers, and FlowProducer workflows for Node.js.

Official
Advanced