devwithjev
Submit a build

Query workload classifier for Postgres

A desktop app that uses Jev to classify your entire query workload and tell you which queries to EXPLAIN ANALYZE first.

Frone0910 in r/SQL@Frone0910
I built an app that uses Jev to classify your entire query workload and tell you which queries to EXPLAIN ANALYZE first I posted here last month about RDST, the free desktop app that runs the slow query to EXPLAIN to index recommendation loop. The biggest change since then is what happens before EXPLAIN. When a database has thousands of distinct query shapes, you can't EXPLAIN ANALYZE all of them, and sorting queries by their performance doesn't always tell you which ones are actually badly written. RDST now answers that with Jev, a small classification model from TypeSafe that answers fixed multiple-choice questions about a query in a fraction of a second. Every query shape it discovers gets classified from its SQL and the schema, without executing anything, on five structural questions:
Sep 23, 2026Reddit postsView on Reddit

Also filed under Tools & apps

  • jev-sec-audit Flags Risky npm Packages

    jev-sec-audit uses Jev, a System 1 model built for fast decisions, to flag risky npm installs. It runs as one step in GitHub Actions and is open source.

  • Google Icons Search Tool

    Roman Khrupa built a tool that searches Google Icons using JEV (Laya-MLX).

  • AI Slop Finder for X

    Utkarsh Singh built an AI-slop finder for X using Jev. A content script extracts tweet text, sends it through a backend API to Jev, and displays the resulting AI-slop score as a badge on the tweet.

  • Enforce CLAUDE.md With Jev

    The build uses Jev to check Claude’s final replies and edits against rules in CLAUDE.md. It sends violations back to Claude to fix in the same turn.