DEDUPED Hot AI repos, turned into use cases Get 5 a day

What you can do with Jev4 PG

jev4pg is a PostgreSQL-based tool that adds natural-language-to-SQL and semantic operators, so you can filter, rank and verify text and data with JEV while PostgreSQL runs the relational SQL.

Trended earlier

Sheltercosmo/jev4pg on GitHub

Third-party repos we don't own or vouch for. AI-generated use cases can be wrong: review everything and run at your own risk.

What do you want to do?

3 use cases

  • Find support tickets by meaning, not keywords

    Count and group tickets that describe a problem, using a plain-language condition in SQL.

    View prompt
    Use the jev4pg repository to set up the workspace, import the CSV at <path-to-csv> as a dataset named tickets, and run a SQL query that counts rows where SEMANTIC(body, 'The ticket describes an unresolved billing problem.') is true, grouped by product. Return the grouped counts and confirm that the decision states and any uncertain rows are reported before the counts are treated as final.

  • Run semantic analysis on existing PostgreSQL tables in place

    Attach a table you already run without copying its rows, then query it with JEV from the workspace.

    View prompt
    Use the jev4pg repository to attach the existing table <schema>.<table> to the workspace for tenant demo without copying rows, using the external PostgreSQL setup. Report the grants that were applied and confirm that a test SELECT through the workspace returns only rows visible to the runtime login.

  • Query semantic conditions directly from psql with native functions

    Call jev_native functions from any PostgreSQL client against tables you already own.

    View prompt
    Use the jev4pg repository to install the jev_native extension on a PostgreSQL 17 server and grant access to a SQL login named <login> for the table <schema>.<table>. Return a grouped query over jev_native.scan and confirm that the result includes decision states and uncertainty for each row.

How to use Jev4 PG

  1. Check you have what it needs: Python 3.11+ and Docker with Compose v2; A TypeSafe key or other JEV provider settings; A CSV export or an existing PostgreSQL table to query.
  2. Open Sheltercosmo/jev4pg on GitHub and read the README and license.
  3. Run git clone --branch v0.7.0 https://github.com/Sheltercosmo/jev4pg.git and then cd jev4pg.
  4. Run python deploy/configure.py and enter your TypeSafe key when prompted.
  5. Run docker compose build and then docker compose up -d --wait.
  6. Run python deploy/configure.py --show-token, open http://127.0.0.1:8000/ask/en and connect with that token.

These steps come from our top use case, Find support tickets by meaning, not keywords, which also has a copy-paste agent prompt.

Jev4 PG alternatives · Best AI repos for Data and analytics

About this repo

Requirements

  • Python 3.11+ and Docker with Compose v2
  • A TypeSafe key or other JEV provider settings
  • A CSV export or an existing PostgreSQL table to query
Maintain Jev4 PG? Add the Featured on Deduped badge

Paste this into your README:

[![Featured on Deduped](https://dedupedai.com/badge/sheltercosmo-jev4pg.svg)](https://dedupedai.com/use-cases/sheltercosmo-jev4pg/?ref=badge)

More badge styles and HTML

Questions about Jev4 PG

What is Jev4 PG?

jev4pg is a PostgreSQL-based tool that adds natural-language-to-SQL and semantic operators, so you can filter, rank and verify text and data with JEV while PostgreSQL runs the relational SQL. It is an open-source project on GitHub: https://github.com/Sheltercosmo/jev4pg.

Who is Jev4 PG for?

Data analysts, database administrators and developers who want semantic queries over text in PostgreSQL tables or CSV exports.

What can I do with Jev4 PG?

3 use cases so far, for example: Find support tickets by meaning, not keywords; Run semantic analysis on existing PostgreSQL tables in place; Query semantic conditions directly from psql with native functions. Each has steps and a copy-paste agent prompt.

What do I need to run Jev4 PG?

Python 3.11+ and Docker with Compose v2; A TypeSafe key or other JEV provider settings; A CSV export or an existing PostgreSQL table to query.

What are alternatives to Jev4 PG?

Other hot AI repos in Data and analytics: Kronos, DBT Charts, Brandpose, Idx, Open Lakehouse Compute Fabric.

Is Jev4 PG safe to run?

Deduped does not own, audit or vouch for it. Read the README and license, run it on your own systems first and review every command before you run it.