Agentdb

Purpose

Provide production-ready vector search, semantic memory, and recall patterns for agent workloads.

Trigger Conditions

• Use this skill when: Need high-speed similarity search, persistent agent memory, or RAG retrieval tuning.
• Reroute when: If user only needs basic KV storage or non-vector data, direct to standard database guidance.

Guardrails (Inherited from Skill-Forge + Prompt-Architect)

• Structure-first: every platform skill keeps SKILL.md, examples/, and tests/ populated; create resources/ and references/ as needed. Log any missing artifact and fill a placeholder before proceeding.
• Confidence ceilings are mandatory in outputs: inference/report 0.70, research 0.85, observation/definition 0.95. State as Confidence: X.XX (ceiling: TYPE Y.YY).
• English-only user-facing text; keep VCL markers internal. Do not leak internal notation.
• Adversarial validation is required before sign-off: boundary, failure, and COV checks with notes.
• MCP tagging for runs: WHO=agentdb-{session}, WHY=skill-execution, namespace skills/platforms/agentdb/{project}.

Execution Framework

1. Intent & Constraints — clarify task goal, inputs, success criteria, and risk limits; extract hard/soft/inferred constraints explicitly.
2. Plan & Docs — outline steps, needed examples/tests, and data contracts; confirm platform-specific policies.
3. Build & Optimize — apply platform playbook below; keep iterative checkpoints and diffs.
4. Validate — run adversarial tests, measure KPIs, and record evidence with ceilings.
5. Deliver & Hand off — summarize decisions, artifacts, and next actions; capture learnings for reuse.

Platform Playbook

• Workflow patterns:
  • Embed and index documents with dimension validation and metadata hygiene
  • Tune search parameters (HNSW/MIPS) for latency vs. recall and tenant isolation
  • Operate memory tiers (short-term, episodic, long-term) with retention policies
• Anti-patterns to avoid: Storing PII in plaintext metadata, Skipping dimension validation before insert, Returning unvalidated search hits to end users
• Example executions:
  • Index knowledge base chunks then retrieve top-k for RAG answers
  • Run latency benchmark and adjust ef_search/ef_construction for 99p targets

Documentation & Artifacts

• SKILL.md (this file) is canonical; keep quick-reference notes in README.md if present.
• examples/ should hold runnable or narrative examples; tests/ should include validation steps or checklists.
• resources/ stores helper scripts/templates; references/ stores background links or research.
• Update metadata.json version if behavior meaningfully changes.

Verification Checklist

• Trigger matched and reroute considered
• Examples/tests present or stubbed with TODOs
• Constraints captured and confidence ceiling stated
• Validation evidence captured (boundary, failure, COV)
• MCP tags applied for this run

Confidence: 0.70 (ceiling: inference 0.70) - Standardized platform skill rewrite aligned with skill-forge + prompt-architect guardrails.