← 返回 Skills 市场
wpank

Postgres Job Queue

作者 wpank · GitHub ↗ · v1.0.0
cross-platform ⚠ suspicious
1196
总下载
1
收藏
4
当前安装
1
版本数
在 OpenClaw 中安装
/install 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.
安全使用建议
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.
功能分析
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.
能力评估
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.
如何使用
  1. 确保已安装 OpenClaw(本地或 Docker 部署)
  2. 在对话框中输入安装命令:/install postgres-job-queue
  3. 安装完成后,直接呼叫该 Skill 的名称或使用 /postgres-job-queue 触发
  4. 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
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.
元数据
Slug postgres-job-queue
版本 1.0.0
许可证
累计安装 4
当前安装数 4
历史版本数 1
常见问题

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. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 1196 次。

如何安装 Postgres Job Queue?

在 OpenClaw 或 Claude Code 对话框中运行命令「/install postgres-job-queue」即可一键安装,无需额外配置。

Postgres Job Queue 是免费的吗?

是的,Postgres Job Queue 完全免费(开源免费),可自由下载、安装和使用。

Postgres Job Queue 支持哪些平台?

Postgres Job Queue 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。

谁开发了 Postgres Job Queue?

由 wpank(@wpank)开发并维护,当前版本 v1.0.0。

💬 留言讨论