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.