← Back to Skills Marketplace
wpank

Postgres Job Queue

by wpank · GitHub ↗ · v1.0.0
cross-platform ⚠ suspicious
1196
Downloads
1
Stars
4
Active Installs
1
Versions
Install in OpenClaw
/install postgres-job-queue
Description
PostgreSQL-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.
Usage Guidance
This skill appears coherent and focused: it shows SQL and Go examples for a Postgres-based job queue and does not request secrets or perform network calls. Before using it, however: (1) review and test the SQL locally (claims/updates will modify your DB); (2) ensure you have appropriate Postgres credentials and permissions (the skill doesn't declare them but you'll need them to run the code); (3) verify you have necessary extensions (e.g., gen_random_uuid() requires pgcrypto or an equivalent UUID generator) and that indexes are suitable for your workload; and (4) be cautious running any provided UPDATE queries against production without staging tests. The README's installation examples (e.g., the 'npx add' URL and copy-from-~/.ai-skills instructions) look inconsistent — obtain the skill source from a trusted repository or package before copying/executing.
Capability Analysis
Type: OpenClaw Skill Name: postgres-job-queue Version: 1.0.0 The skill is classified as suspicious due to the presence of a remote code execution instruction in `README.md`. The `npx add` command instructs the agent to fetch and execute a script from a GitHub URL. While this specific instance points to the skill's own repository for installation, it represents a risky capability for remote execution that could be leveraged for malicious purposes if the URL were altered or compromised, aligning with the 'risky capabilities without clear malicious intent' criteria.
Capability Assessment
Purpose & Capability
Name and description match the content: schema, SKIP LOCKED claiming, Go client examples, stale-recovery and decision guidance. All required pieces are appropriate for a Postgres job queue.
Instruction Scope
SKILL.md contains only schema, SQL functions, and example Go code for claiming/completing/failing jobs and recovering stale jobs. It does not instruct the agent to read unrelated files, exfiltrate data, or call external endpoints.
Install Mechanism
Instruction-only skill with no install spec or code files to download/execute — lowest-risk installation model. README's example 'npx add https://...' is unconventional but not an active installer in the skill package itself.
Credentials
The skill declares no required env vars or credentials, which is reasonable for an instruction-only recipe; however, practical use requires database connection credentials (e.g., a DATABASE_URL) that are not documented here. That omission is a documentation gap rather than a mismatch, but users must supply DB credentials to run the examples.
Persistence & Privilege
Skill is not always-on, does not request system-wide configuration changes, and does not modify other skills or agent settings. It has no special platform privileges.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install postgres-job-queue
  3. After installation, invoke the skill by name or use /postgres-job-queue
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of postgres-job-queue, a PostgreSQL-based job queue with priority, batch claiming, and progress tracking. - Production-ready schema for jobs table, with fields for priority, progress, worker tracking, and retries. - Example SQL and Go code for batch claiming using SKIP LOCKED. - Includes job completion, failure, and stale job recovery routines in Go. - Clear decision tree for when to use PostgreSQL vs. other queues. - “NEVER Do” section for critical design guidelines and anti-patterns.
Metadata
Slug postgres-job-queue
Version 1.0.0
License
All-time Installs 4
Active Installs 4
Total Versions 1
Frequently Asked Questions

What is Postgres Job Queue?

PostgreSQL-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. It is an AI Agent Skill for Claude Code / OpenClaw, with 1196 downloads so far.

How do I install Postgres Job Queue?

Run "/install postgres-job-queue" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Postgres Job Queue free?

Yes, Postgres Job Queue is completely free (open-source). You can download, install and use it at no cost.

Which platforms does Postgres Job Queue support?

Postgres Job Queue is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Postgres Job Queue?

It is built and maintained by wpank (@wpank); the current version is v1.0.0.

💬 Comments