SKILLEMALL.ai
GitHub ↗ RU Sign in

CF pg-memory

PostgreSQL-based structured memory system for OpenClaw agents with pre/post-compaction integration, dual-write capability, and full context preservation. Primary storage with markdown backup. Supports multi-agent deployments.

ClawHub Agent Skills author: Skip Potter v2.7.3 27 files · 3 scripts body ≈ 6 537 tokens Open the sourceclawhub.ai↗ analyzed 3 d ago

As a process F 36/100 · Will not run — References files that are not bundled: scripts/pg_memory_v2.py

IntegrationPostgreSQLDockerAI and agentstype and topics are labelled automatically from the skill text
Runs in: OpenClaw Claude / Claude Code ChatGPT / Codex Gemini CLI Cursor GitHub Copilot / VS Code Qwen Code Kimi Code CLI Z.ai (GLM) DeepSeek (Deep Code) Mistral Vibe LangChain (deepagents) Goose OpenCode
JSON
Technical rating
C
73/100
safety, quality, tests
Safety 60%
94
Quality 40%
42
Run on models
none yet
Process rating
F
36/100
Will not run
References files that are not bundled: scripts/pg_memory_v2.py
Tools and files w 18
0
Result and completion w 14
0
Inputs and preconditions w 11
0
the three weakest of ten parameters · all ten

What is at stake

Medium-severity findings: the skill is probably honest, but read what alarmed the scanner.

Dangerous commands medium severity

Below is the worst case for this category. The finding here is medium: the guard saw a sign, not a proof.

If you install

The skill contains commands that delete files, rewrite disks or execute code fetched from the network. The agent may run them without asking if it believes the instructions require it.

For the author

Replace destructive commands with safe equivalents that ask for confirmation, scope them to one folder, and stop piping curl into a shell: pin a version and a checksum.

How to improve

  1. Say in the description WHEN to use the skill ("use when…", example requests): that is the agent's main cue.
  2. The SKILL.md body is over 5,000 tokens: move reference detail into references/ and load it when needed.
  3. The text references files that are not there: add them or drop the references.
For the model run — optional
  • Your own cases (evals/evals.json, 4–6 real requests with expected answers): the full check would then run those instead of a model-drafted suite.
  • A spec.yaml with trigger phrases and assertions — a behaviour contract for CI; `skilltest init` writes a template.

Guard findings · 2

✓ No critical or high findings

Medium and low: 2
  • medium Dangerous commands cmd-shell-rc install.sh:229
    Writes to a shell startup file
    echo "  2. Add to your profile: echo 'source $CONFIG_FILE' >> ~/.zshrc"
  • low Exfiltration net-credential-use server-setup.sh:147
    Credential used in a network call (verify the destination is the intended service) (quoted — discussed, not commanded)
    if [ "$DB_PASSWORD" != "$DB_PASSWORD_CONFIRM" ]; then
    quoted

Files scanned: 27. Evidence is masked. Grey chips explain why severity was lowered.

Against the Agent Skills spec

  • warning description-no-when description does not say WHEN to use the skill (no "use when")
  • warning body-long SKILL.md body ≈ 6537 tokens (recommended < 5000); move details to references/
  • warning missing-ref reference to a missing file: scripts/pg_memory_v2.py
  • note frontmatter-key unknown frontmatter key "homepage"

Process rating: all ten parameters 36/100

Will not run. References files that are not bundled: scripts/pg_memory_v2.py
  • 0Tools and files. 1 referenced file(s) missing: scripts/pg_memory_v2.py
  • 0Result and completion. Does not say what the result is
  • 0Inputs and preconditions. Does not say what the process needs to start
  • 0Progress reporting. Says nothing while it works
  • 20When it triggers. No condition that starts the skill
  • 50Failures and branches. 0 branches, has a failure section
  • 70Execution cost. Instruction body is 6537 tokens
  • 85Steps. 65 steps, 1 vague phrases
  • 100Consistency. Name and required fields are in place
  • 100Running it twice. Mutating operations check current state
  • medium Safety rules and hard prohibitions inside a skill: they belong in the system prompt, here they protect nothing
  • low 15 top-level sections: this looks like several domains in one skill

Everything here is measured from the skill text rather than judged by a model, so the numbers are checkable. A parameter weighs more when it is a more common reason for the process to stall.

Quality signals

  • +5Description has no quoted example phrases that should trigger the skill
  • +4Description does not say when NOT to use the skill (false activations)
  • +3Output format is not stated: the model decides each time
  • -4Absolute local paths (C:\Users, /home/…): not portable
  • -227 emoji in the instructions: noise for the model
  • -41 reference files, but SKILL.md never points to them: the model will not open them
  • -36 of 8 scripts are never mentioned in SKILL.md
  • +1No license
  • +2Single-language instructions
  • +3Description length 225: enough signal without eating the budget
  • +4Structure: 73 headings
  • +3Step-by-step instructions: 65 items
  • +4Has examples (42 code blocks)

Quality base 70; lint remarks subtract, signals add up to 100. Result: 42.

External checks

ClawHub: suspicious
This is a real PostgreSQL memory skill, but it stores sensitive agent history and includes overbroad database setup, network exposure guidance, and unsafe backup/restore paths that need review before use.
LLM: suspicious (high) · VirusTotal: · 29 May 2026