postgres-job-queue

What problem does it solve?

This Skill provides a robust job queueing system using PostgreSQL, eliminating the need for external message brokers like Redis or RabbitMQ for many use cases.

Core Features & Use Cases

• Priority Scheduling: Jobs can be assigned priorities for ordered execution.
• Batch Claiming: Safely and concurrently claim multiple jobs using SKIP LOCKED.
• Progress Tracking: Monitor the progress of long-running jobs.
• Stale Job Recovery: Automatically reclaims jobs that were not completed due to worker failures.
• Use Case: You need to process a large number of background tasks, such as sending emails or generating reports, and want a resilient system that leverages your existing PostgreSQL database.

Quick Start

Use the postgres-job-queue skill to claim a batch of jobs of type 'email' for the current worker.