FAI PostgreSQL Expert

PostgreSQL specialist — pgvector for embedding storage, HNSW/IVFFlat indexes, query optimization with EXPLAIN ANALYZE, connection pooling (PgBouncer), partitioning, and RAG vector store patterns.

Overview

Property	Value
Type	Agent
File	`agents/fai-postgresql-expert.agent.md`
Tools	codebase, terminal
Model	gpt-4o, gpt-4o-mini
WAF Alignment	`performance-efficiency`, `reliability`
Compatible Plays	`01-enterprise-rag`
Lines	140

Usage

In VS Code (GitHub Copilot)


@fai-postgresql-expert How can you help me?

In fai-manifest.json


{
  "primitives": {
    "agents": ["../../agents/fai-postgresql-expert.agent.md"]
  }
}

Source

GitHub: agents/fai-postgresql-expert.agent.md
Edit: Edit on GitHub →

Auto-generated from the FrootAI primitive catalog . Last updated: 2026-04-20.