All skills
PostgreSQL & Vector Search
Relational modelling, Drizzle, and retrieval that returns the right thing rather than merely something.
How I use it
Schema and code disagreeing about a row
Drizzle schemas driving both migrations and application types, so the database and the code cannot hold different beliefs about what a record contains.
Similarity search that misses the obvious answer
Embeddings combined with structured filters and deliberate chunk boundaries. Pure vector search happily returns something adjacent and confident.
Multi-tenant data in a shared table
Tenant isolation enforced in the query layer so a filter cannot be forgotten at a call site and quietly leak across boundaries.
What I use
- PostgreSQL
- pgvector
- Drizzle ORM
- SQLite
Related skills
Want the detail behind any of this?
I can walk through any of it in as much depth as you want.