Back to portfolio
Python / FastAPI / PostgreSQL + pgvector / pydantic-ai / psycopg 3 / Docker / GitHub Actions
Personal project · May 2026 — nowRAG
Enterprise RAG Assistant
A RAG backend for enterprise knowledge bases: tenant isolation enforced in SQL, the tenant derived from the API key alone, and a lexical retrieval arm rebuilt on character trigrams for Chinese.
- Hybrid recall@1
- 97.2%
- Tests, no external services in CI
- 111
- Tenant isolation lives in SQL: every table carries tenant_id, the tenant is derived from the API key, and the X-Tenant-Id header is ignored outright.
- Hybrid retrieval: vector kNN and pg_trgm trigram rankings fused with RRF, because tsvector cannot segment Chinese.
- A 20-document / 36-question retrieval benchmark, shipped with an honest reading of what it cannot yet prove.