User repository on GitHub
Ask your Postgres tables questions in plain language. A PostgreSQL extension powered by TypeSafe's Jev.
- Forks
- 97
- Last pushed
- Updated Oct 2026
Repo stats from the GitHub API, cached Oct 2026.Homepage
Jev directory
CommunityJev Tools & CLIs
Pg Jev
A PostgreSQL extension that filters, ranks, and classifies table rows with plain-language conditions judged by Jev, batching 20 rows per request and caching answers per session.
- Stars
- 1.2k
- Language
- Shell
- Reading time
- 3 min
- Published by
- Community
- Author
- realZachi
- Last verified
- Sep 2026
About this project
Write the condition the way you would say it. Postgres does the rest. jev lets you filter, rank and classify rows with plain-language conditions. Every row is judged by TypeSafe's Jev, a System One model that returns calibrated probabilities instead of generated text. No index, no embeddings, no vector column. jev() is an ordinary boolean function, so it composes with everything else in SQL: AND age > 40, joins, GROUP BY, LIMIT, ORDER BY jevprob(...).
Quoted from the project's README. Read the full README.
Works forJev for Decision gating
Used inJev for Data & Analytics
Highlights
- jev(), jev_prob(), jev_choice(), and jev_score() work inside WHERE, ORDER BY, and GROUP BY.
- Batches 20 rows per request; a 2,000-row first run measured about 3.5 seconds and $0.012.
- Read-ahead streams the table in physical order so LIMIT stops early work.
- Per-row answers are cached for the session, making re-runs and threshold tweaks free.
Watch out
Managed hosts that withhold superuser or plpython3u, including Supabase, Neon, and RDS, cannot run it; needs PostgreSQL 14 to 17.
Questions about this entry
Short answers drawn from the linked project or page.
Server only. It needs PostgreSQL 14 through 17 with plpython3u and a superuser, because CREATE EXTENSION jev CASCADE creates plpython3u, an untrusted language. Managed hosts that withhold either one cannot run it, and the README names Supabase, Neon and RDS as examples.
Default batches of 20 are the tested sweet spot. Jev finds rows[i] by position in the array and that degrades in long arrays: against ground truth from structured columns over 400 rows each, batches of 1 to 20 were 100 percent correct, 40 fell to 92 to 98 percent, and 80 to 77 to 94 percent. jev.batch_size is a GUC, but accuracy drops measurably above roughly 20 to 25.
On the README's 2,000-row measurement, a first run took about 3.5 seconds across 100 requests, around 296k input tokens and roughly $0.012; the second run was about 50 ms because answers are cached per row content and question. LIMIT 3 on a new condition took about 0.6 seconds.
Both are addressable. jev.api_url can point at any server speaking the same POST /v1/systemone contract, so stuntd or laya-server keep rows local with no per-row billing. The answer cache does grow with unique row and question pairs until jev_cache_clear() or the session ends; jev.max_prefetch_rows bounds only the read-ahead, not the cache.
jev() returns a boolean predicate, jev_prob() a 0-to-1 probability, jev_score() and jev_score_norm() a position on ordered levels, jev_choice() the most likely option, jev_confidence() the confidence, and jev_eval() the full jsonb answer, plus jev_stats(), jev_cache_clear(), and jev_version().
jev.model defaults to jev-latest, jev.threshold to 0.5, jev.batch_size to 20, jev.concurrency to 16, and jev.max_prefetch_rows to 5000. All are plain GUCs you can set per session, per role, per database, or in postgresql.conf.
It targets PostgreSQL 14 to 17 with plpython3u and needs a superuser. Install from PGXN with pgxn install jev and CREATE EXTENSION jev CASCADE, from source with make install, or run the Docker image with TYPESAFE_API_KEY set. The license is the PostgreSQL license.
Reactions & coverage
Posts, threads, and videos about this entry from around the web.
X: jev(): Postgres WHERE clauses in plain language
Hacker News: A MySQL plugin that filters rows by asking Jev whether a column matches a sentence.
maayanlevy-hn2 pointsA MySQL plugin that filters rows by meaning (built on TypeSafe Jev)Read the thread on Hacker NewsMore Jev resources like this
A pre-alpha PostgreSQL extension for categorical work in SQL: Noul, Choice, and Score functions plus batched variants that classified 38 strings in two requests.
Jev Tools & CLIs#community#postgres#sql
Community
giuliosmall/pg_typesafeC
giuliosmall/pg_typesafeCpsql-shaped CLI and Go, TypeScript, and Python SDKs that let you write jev(), jev_prob, jev_choice, and jev_score in queries against vanilla PostgreSQL, judging the surviving rows with Jev in batches. No CREATE EXTENSION or superuser required.
Jev Tools & CLIs#community#go#postgres
Community
kylemclaren/jevqlGo
kylemclaren/jevqlGoAn open-source, commercially hosted generative-engine-optimization platform that uses Jev judgments within a broader application to track brand mentions and placement in AI answers across ChatGPT, Claude, Gemini, and Perplexity.
Jev Tools & CLIs#community#typescript#postgres
Community
usenotra/notraTypeScript
usenotra/notraTypeScriptA semantic database built on the DuckDB ecosystem that runs classification, semantic joins and scoring over text as ordinary SQL. It batches decisions on a Jev model and returns probabilities, labels and scores directly, without generated explanations.
Jev Repos & SDKs#community#github#database
Community
pdais/jevdbC++
pdais/jevdbC++A zero-dependency Node library and CLI that adds Jev natural-language predicates and decision tables to SQLite, with batching, caching, review queues, and saved decisions queryable as ordinary SQL tables.
Jev Tools & CLIs#community#javascript#sql
Community
EugeneBoondock/jevsqlJavaScript
EugeneBoondock/jevsqlJavaScriptSQLite C extension that exposes Jev as SQL functions (jev_noul, jev_choice, jev_score) so queries can classify states such as ticket bodies directly, with only libcurl as a dependency.
Jev Tools & CLIs#community#sql#data
Community
mattn/sqlite3-jevC
mattn/sqlite3-jevCFrom the Jev guides
Original write-ups on what this entry is for.
From the Jev AI model community
Posts from builders shipping with Jev right now.