Filter database records by meaning, not exact values
Ask Jev a yes/no question per record, such as whether a role could be remote, to filter a database or list by meaning.
Author's figure: Author's figure: 129 rows, roughly 1 s (Zachi). Reported by the builder, not measured by us.
The use case
Teams sitting on tables of companies, people, notes or todos often want filters that no column supports: which roles could work from home, which notes mention a stalled deal, which companies sell to schools. These builds pass each candidate record to Jev with a yes/no or Choice question and keep the ones that pass, sometimes after a cheap keyword or embedding step narrows the list. It is slower than an index, so it suits hundreds to low thousands of rows per query. A person checks results before acting on them, especially for anything about people.
Example workflow
- Narrow candidates with SQL or embeddings in Postgres
- Pass each remaining record's text to Jev with the filter question
- Keep records above a probability threshold
- Show results with their probabilities in Metabase or a sheet
- A person reviews the list before acting on it
Tools
- Jev (TypeSafe AI)
- PostgreSQL
- pgvector
- Metabase
Risks and guardrails
- Per-row calls get slow and costly on large tables
- Filters about people can encode unfair assumptions
- Vague questions return vague results
Sources
Written by Agents Lookup. Credits and official pages for the tools this use case names:
- jev() for PostgreSQL by Zachi on Made with Jev: madewithjev.com/builds/postgres-jev-function
- jev() for PostgreSQL: original post or repo by Zachi: x.com/iam_zachi/status/2100679300756435135
- Semantic database filters by Avi Chawla on Made with Jev: madewithjev.com/builds/semantic-database-filters
- Semantic database filters: original post or repo by Avi Chawla: x.com/_avichawla/status/2106328920211800165
- YC Indexor by Aayan on Made with Jev: madewithjev.com/builds/yc-indexor
- YC Indexor: original post or repo by Aayan: github.com/Aayan-DEV/aayans-yc-indexor
- Filtering WIP todos by meaning by Marc Köhlbrugge on Made with Jev: madewithjev.com/builds/wip-todo-filter
- Filtering WIP todos by meaning: original post or repo by Marc Köhlbrugge: x.com/marckohlbrugge/status/2101344345857069558
- GitHub repo pg-jev by realZachi (Postgres extension): github.com/realZachi/pg-jev
- GitHub repo dbt-decisions by dbt Labs: github.com/dbt-labs/dbt-decisions
- GitHub repo mysql-ailike by maayanlevy (Show HN): github.com/maayanlevy/mysql-ailike
- Metabase (official page): www.metabase.com/docs/latest/ai/mcp (checked 2026-11-19)