User repository on GitHub
SQLite extension that calls TypeSafe Jev (or tensai serve) from SQL
- Forks
- 1
- Last pushed
- Updated Sep 2026
Repo stats from the GitHub API, cached Oct 2026.
Jev directory
CommunityJev Tools & CLIs
Sqlite3 Jev
SQLite 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.
- Stars
- 3
- Language
- C
- License
- MIT
- Reading time
- 3 min
- Published by
- Community
- Author
- mattn
- Last verified
- Sep 2026
About this project
SQLite extension that calls TypeSafe Jev — a decision-only model that returns typed answers (yes/no probability, choice, score) instead of text — straight from SQL. Written in C, depends only on libcurl. Builds on Linux, macOS and Windows (MinGW-w64). criteria for jevchoice is either a JSON object {"option": "description"} (description may be null) or a JSON array of option names. levels for jevscore is a JSON array of at least two level descriptions, in order.
Quoted from the project's README. Read the full README.
Works forJev for Extraction
Used inJev for Data & Analytics
Highlights
- Exposes jev_noul, jev_choice, jev_score and their JSON variants, plus jev() for several questions in a single request.
- Written in C and depends only on libcurl; builds on Linux, macOS and Windows via MinGW-w64.
- Structured JSON states work through SQLite's json_object and json_array, and *_json results chain with ->> and json_extract.
- 429 and 529 responses are retried with exponential backoff up to three times, and API errors are raised as SQL errors.
- Point base_url at mattn's tensai server to run the same SQL against a local GGUF model on port 8080.
Quickstart
sql
.load ./jev
SELECT jev_noul('Help! My payouts have been failing for 3 days.', 'Does this convey urgency?');
SELECT id, jev_choice(body, 'Which team should handle this?', '["billing", "technical", "sales"]') AS dept FROM tickets;Watch out
MIT-licensed. Needs a C compiler, sqlite3ext.h and libcurl to build, plus a TYPESAFE_API_KEY or a tensai base_url; without a key no Authorization header is sent.
Questions about this entry
Short answers drawn from the linked project or page.
The README documents no batching, caching or request coalescing, so a SELECT over many rows appears to cost one call per row per function, and cost control at table scale is not documented. What it does document is that jev() and jev_raw() send several questions in a single request, and that jev_config('timeout') defaults to 60 seconds.
API errors are raised as SQL errors, so 401 and 422 abort the statement rather than quietly returning null. 429 and 529 are retried with exponential backoff up to three times, and the default timeout is 60 seconds, tunable through jev_config or JEV_TIMEOUT. Without an API key no Authorization header is sent at all.
Only the arguments you pass. state and instructions are sent as strings, and to send structure you hand it a value produced by SQLite's own JSON functions such as json_object, json_array or json, which is embedded as-is. Coming back, the *_json functions and jev() return JSON with SQLite's JSON subtype, so ->, ->> and json_extract chain directly.
Yes. Point base_url at tensai, mattn's server for a local GGUF model that answers the same request and response shape on POST /v1/systemone, and the identical SQL runs against it with nothing else changed. A bare host, http://host/ and host:port all expand to http://host:port/v1/systemone; a URL with a path is used as given.
Run make to produce jev.so or jev.dylib, then make install to put it under /usr/local/lib/sqlite3/. Load it with .load ./jev in sqlite3.exe or from any SQLite binding that supports load_extension. Build needs a C compiler, sqlite3ext.h and libcurl; Debian needs libsqlite3-dev and libcurl4-openssl-dev, macOS uses brew install sqlite curl. It is MIT licensed.
jev_noul returns a REAL probability, jev_choice returns the chosen TEXT option, jev_choice_json returns choice, probabilities and confidence, jev_score returns a weighted REAL score, jev_score_json adds score, legend, probabilities and confidence, jev returns a JSON answers object for several questions in one call, jev_raw returns the full response, and jev_config gets or sets api_key, model, base_url and timeout.
Yes. tensai serves the same request and response shape on POST /v1/systemone, answered by a local GGUF model, so the same SQL runs against it with nothing but the base URL changed: jev_config('base_url', 'localhost:8080'). tensai serve -api-key pairs with jev_config('api_key', ...) or $TYPESAFE_API_KEY.
Reactions & coverage
Posts, threads, and videos about this entry from around the web.
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 NewsX: jev(): Postgres WHERE clauses in plain language
More 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_typesafeCA 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/jevsqlJavaScriptA 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.
Jev Tools & CLIs#community#postgres#sql
Community
realZachi/pg-jevShell
realZachi/pg-jevShellAn 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 drop-in proxy that distills a repeated Jev classification call into a local model as it runs: it learns from Jev's own probability distributions, then answers most requests itself while uncertain ones and a 2% audit slice keep going to Jev.
Jev Tools & CLIs#community#python#distillation
Community
tomerglick57/JevstillerPython
tomerglick57/JevstillerPythonA schema-guided document-to-graph pipeline: local parsing feeds entity mentions and bounded candidate pairs to Jev, which chooses among closed-set relations, and every edge lands as proposed, review, or rejected with page-level evidence.
Jev Tools & CLIs#community#catalog-import#madewithjev
Community
chenmingtang830/jevgraphPython
chenmingtang830/jevgraphPythonFrom 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.