L2 Fact Lookup (Postgres Working Memory)
Perform fast keyword fact lookup in L2 working memory (Postgres tsvector).
Skill by maksim-tsi
Chalk Labs
Need help deploying L2 Fact Lookup (Postgres Working Memory)?
Chalk Labs sets up agents like this inside real teams: connected to your tools, tested on your data, with a human in the loop where it matters.
Install
Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.
npx agentmarket install skill/maksim-tsi-l2-fact-lookup-postgres-working-memory
Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.
Get the weekly diff
The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.
About
Use cases: backend
Reviews
Write a reviewNo reviews yet. Installed it? Reviews come from verified installers only. How reviews work
Permissions
What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.
- Tools
- No tools found
- Secrets
- None asked for
- Install scripts
- None found
Network hosts it talks to 1
codeload.github.com· found in install command
Files it touches
~/.claude/skills/l2-fact-lookup-postgres-working-memory
What's inside
- Skill name
L2 Fact Lookup (Postgres Working Memory)- Description
- Perform fast keyword fact lookup in L2 working memory (Postgres tsvector). Keywords: exact match, SKU, container_id, error code, party name, port code.
- License
- MIT
- Compatibility
- YAAM runtime agents (LangGraph ToolRuntime)
- Metadata
- yaam.layer: policy · yaam.mechanism_contract: docs/specs/spec-mechanism-maturity-and-freeze.md
- Instructions
- 42 lines in SKILL.md · view on GitHub
Agent Skills spec issues
- name: only lowercase letters, digits and single hyphens allowed
- name: "L2 Fact Lookup (Postgres Working Memory)" does not match folder "l2-fact-lookup"
- allowed-tools: must be a space-separated string
Files (1)
- SKILL.md
SKILL.md (first lines)
## When to Use
- You need **exact or near-exact** matches: container IDs, SKUs, bill-of-lading numbers, port codes, error codes.
- You want the fastest path (avoid semantic search) for operational identifiers.
## Preconditions
- L2 tier is configured and reachable; the runtime provides `session_id`.
## Inputs and Outputs
- **Input:** query string + optional `min_ciar` threshold.
- **Output:** JSON of matching facts with CIAR and metadata.
## Tools
- `l2_search_facts(query, min_ciar, limit)`
- `ciar_calculate(...)` / `ciar_explain(...)` (optional; to justify promotion/retention decisions)
## Procedure (Recipe)
1. Run `l2_search_facts` with a narrow query and `limit` (10–30).
2. If results are noisy, raise `min_ciar` (e.g., 0.7–0.8) or tighten the keyword.
3. If you need to justify why a candidate fact should be retained/promoted, compute CIAR explicitly with `ciar_calculate` and optionally produce a human explanation with `ciar_explain`.
### Example Tool Calls
```json
{"query": "MAEU1234567", "min_ciar": 0.7, "limit": 20}
```
## Guardrails (Non-Negotiable)
- Do not run SQL; only use `l2_search_facts`.
- Do not store secrets in fact content or metadata.
## Failure Modes and Fallback
- If L2 is unavailable: fall back to `memory_query` (hybrid) or `get_context_block` to recover recent turns.From maksim-tsi/yet-another-agents-memory, MIT.
More from maksim-tsi/yet-another-agents-memory
- 0.398score
Skill Builder (YAAM)
maksim-tsi
Use when creating or updating YAAM skills (policy artifacts) for runtime agents, especially for multi-agent memory management, knowledge lifecycle automation…
SkillDFreshness: DClaude Code +9 - 0.395score
Skill Selection (Executive Function)
maksim-tsi
Select the most appropriate YAAM skill(s) for the current user intent and constraints.
SkillDFreshness: DClaude Code +9 - 0.395score
L3 Similar Episodes (Qdrant Episodic Memory)
maksim-tsi
Find semantically similar past episodes (L3) using vector similarity search.
SkillDFreshness: DClaude Code +9 - 0.395score
CIAR Scoring and Promotion Gating
maksim-tsi
Decide what should be promoted to L2 working memory using CIAR (certainty×impact×age decay×recency boost).
SkillDFreshness: DClaude Code +9 - 0.395score
Context Block Retrieval (L1+L2+L3+L4)
maksim-tsi
Retrieve a focused context block for a session: recent turns, significant facts (CIAR), episode summaries, and knowledge snippets.
SkillDFreshness: DClaude Code +9 - 0.395score
Knowledge Lifecycle Distillation
maksim-tsi
Distill reusable patterns/rules from multiple episodes and store them as knowledge candidates with provenance.
SkillDFreshness: DClaude Code +9 - 0.395score
L3 Graph Traversal (Neo4j Templates)
maksim-tsi
Safely answer relationship and timeline questions via template-based L3 graph traversal (Neo4j).
SkillDFreshness: DClaude Code +9 - 0.395score
Retrieval-Reasoning Gap Mitigation
maksim-tsi
Mitigate cases where retrieved facts are present but the model ignores them or contradicts them.
SkillDFreshness: DClaude Code +9 - 0.395score
L4 Knowledge Synthesis (Typesense + Synthesizer)
maksim-tsi
Synthesize distilled knowledge (L4) into an answer with provenance and conflict detection.
SkillDFreshness: DClaude Code +9 - 0.392score
Skill Name
maksim-tsi
One sentence describing when to use this skill, with concrete keywords for matching.
SkillDFreshness: DClaude Code +9 - 0.390score
Prospective Memory Followthrough
maksim-tsi
Execute a requested action after a delay (e.g., in N turns) or at a specific future condition.
SkillDFreshness: DClaude Code +9 - 0.390score
Roleplay + Instruction Following
maksim-tsi
Stay in a requested role (e.g., customer vs waiter) and follow scenario constraints.
SkillDFreshness: DClaude Code +9
Signals
- Stars
- 0
- Forks
- 0
- Open issues
- 0
- Last commit (this folder)
- Feb 20, 2026 (8 months ago)
From GitHub (fetched Oct 24, 2026).
Details
- License
- MIT
- First seen
- Oct 24, 2026
- Last checked
- Oct 24, 2026
- Source
- GitHubgithub-graphql
More from maksim-tsi
- 0.398score
Skill Builder (YAAM)
maksim-tsi
Use when creating or updating YAAM skills (policy artifacts) for runtime agents, especially for multi-agent memory management, knowledge lifecycle automation…
SkillDFreshness: DClaude Code +9 - 0.395score
L3 Similar Episodes (Qdrant Episodic Memory)
maksim-tsi
Find semantically similar past episodes (L3) using vector similarity search.
SkillDFreshness: DClaude Code +9 - 0.395score
CIAR Scoring and Promotion Gating
maksim-tsi
Decide what should be promoted to L2 working memory using CIAR (certainty×impact×age decay×recency boost).
SkillDFreshness: DClaude Code +9 - 0.395score
Context Block Retrieval (L1+L2+L3+L4)
maksim-tsi
Retrieve a focused context block for a session: recent turns, significant facts (CIAR), episode summaries, and knowledge snippets.
SkillDFreshness: DClaude Code +9 - 0.395score
Knowledge Lifecycle Distillation
maksim-tsi
Distill reusable patterns/rules from multiple episodes and store them as knowledge candidates with provenance.
SkillDFreshness: DClaude Code +9 - 0.395score
L3 Graph Traversal (Neo4j Templates)
maksim-tsi
Safely answer relationship and timeline questions via template-based L3 graph traversal (Neo4j).
SkillDFreshness: DClaude Code +9
Done for you
Rather not set it up yourself?
Chalk Labs scopes, builds and runs agents for your team: the task audit, the eval harness, the integrations and the weekly ops report. Fixed scope, priced before we start.
See how we build AI agents →Read the case studies
Chalk Labs is a two-founder AI and growth studio. We build AI agents, CRMs and MVPs for Web3 and AI companies, and have shipped 50+ product and token launches.
- launches shipped
- 50+
- launches shipped
- media placements
- 500+
- media placements
- founders on every account
- 2
- founders on every account
Press we've placed: Forbes · CoinDesk · Decrypt · Cointelegraph · The Block
Rahil Jain, Co-founder, Chalk Labs. Ex-Goldman Sachs engineer. You talk to the person who builds it.
Get L2 Fact Lookup (Postgres Working Memory) running in your business
Tell us what you want to automate. A founder replies within one working day with a plan, not a pitch deck.
Cite this page
L2 Fact Lookup (Postgres Working Memory) skill. Agent Mart. https://agentmart.dev/skills/maksim-tsi-l2-fact-lookup-postgres-working-memory (last updated 2026-10-24)