postgres-job-queuePostgreSQL-based job queue with priority scheduling, batch claiming, and progress tracking. Use when building job queues without external dependencies. Triggers on PostgreSQL job queue, background jobs, task queue, priority queue, SKIP LOCKED.
Install via ClawdBot CLI:
clawdbot install wpank/postgres-job-queueGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Potentially destructive shell commands in tool definitions
Exec(Calls external URL not in known-safe list
https://github.com/wpank/ai/tree/main/skills/backend/postgres-job-queueAI Analysis
The skill defines a standard PostgreSQL-based job queue schema and functions for internal task management, with no evidence of credential harvesting, data exfiltration, or hidden malicious instructions. The only external reference is a GitHub URL in the signals list, which appears to be a documentation link and does not indicate active data transmission.
Audited Apr 16, 2026 · audit v1.0
Generated Mar 1, 2026
Handles order fulfillment tasks like inventory updates, payment processing, and shipping notifications with priority scheduling for rush orders. Uses PostgreSQL for reliability, ensuring jobs persist through service restarts during high-traffic events like Black Friday.
Manages video and audio encoding jobs with progress tracking for long-running tasks. Prioritizes user-uploaded content over backfill operations, using batch claiming to efficiently process multiple files concurrently without external dependencies.
Processes batch jobs for generating monthly reports, tax documents, and audit trails with guaranteed delivery. Implements retry logic for failed jobs and stale job recovery to handle system outages, ensuring compliance and data integrity.
Coordinates synchronization of patient records and lab results across distributed systems with priority-based scheduling for urgent updates. Uses PostgreSQL to avoid third-party queue dependencies, maintaining HIPAA compliance and data persistence.
Processes sensor data streams from IoT devices, handling tasks like anomaly detection and alert generation. Employs batch claiming to manage high volumes of incoming jobs efficiently, with progress tracking for long-running analytics.
Offers the job queue as a managed service with tiered pricing based on throughput (e.g., jobs per second) and features like priority scheduling. Generates recurring revenue from businesses needing reliable, dependency-free job processing without infrastructure overhead.
Sells perpetual licenses or annual contracts to large organizations for on-premises deployment, with support and customization services. Targets industries like finance and healthcare where data control and compliance are critical, driving high-value deals.
Provides professional services to integrate the job queue into existing systems, offering training, optimization, and custom development. Revenue comes from project-based fees, appealing to companies lacking in-house PostgreSQL expertise.
💬 Integration Tip
Ensure your PostgreSQL instance has adequate connection pooling and monitor the partial index performance for efficient job claiming under load.
Scored Apr 19, 2026
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
Write correct MySQL queries avoiding common pitfalls with character sets, indexes, and locking.