Clean scanStatic scanned
Has an AI model describe the tables and columns of your SQL Server, MySQL or PostgreSQL database.
3.9k installs/moBUSL-1.1
Query Gen
memberjunction · App
Query Gen creates SQL query templates for MemberJunction by asking an AI model to write business questions about your schema and then the SQL to answer them. It loads entities and their relationships from MemberJunction metadata, runs each query against the database, corrects failures and refines the query against its question. Results are exported as metadata files or written to the database. It runs through the MemberJunction command line, a standalone command line or as a library.
Written by ooruby from the README of @memberjunction/query-gen 6.1.5.
Not claimed by its maker. Is this yours? Prove it and answer the findings
Why it's useful
A set of parameterised queries for your data is written by a model and tested against your database, not written one by one by hand.
What you could do with it
- Generate query templates for chosen entities only, or exclude entities you do not want covered.
- Run the validate command over a folder of query metadata to check the queries you already have.
- Export the queries already stored in your database to metadata files in a folder you choose.
Written from its documentation: what it says it can do, not what our checks found.
Maintenance
Not measuredNo release date is on record for this package yet. The nightly publisher check records one as it reaches each npm package, about once every ten nights.
Release activity only: it says nothing about quality or safety, and a finished small package can be fine without releases. How it is measured
What this does not cover
- Everything. Treat it as you would software from anywhere else.
Receipt history: every signed receipt for every version of this listing, and what changed between them.
In its maker's words
AI-powered generation of domain-specific SQL query templates with automatic testing, refinement, and metadata export
Compare with
Compare all 4How far this has been checked
Static scanned
- What it establishes
- Its published package, or for a hosted server its source repository at a recorded commit, was read file by file, without running it, by every check in our current scan.
- What it does not
- How it behaves when it runs, or anything the scan does not read yet: several rubric checks, the repository's history, and compiled code in folders named dist or build. For a hosted server, that the endpoint runs the code that was read. The ooruby Index sets out exactly what was read.
- Exactly what was read
- Version 6.1.5, the file with digest sha512-E9qWTdJ8+iQ3BaJi6b1ka3oW8gZ+SwuOECAr/5/wjcEdMx5UbZGyMR7a6gY/Sbm05NsdZ0kd8JbZdIMbErOHWA==, as the registry publishes it. A published version cannot be replaced, so this names the same bytes for anyone who checks.
- Authentication
- Runs locally. No hosted endpoint is listed for this package. You run it on your own machine, so there is no endpoint of ours to authenticate against.
Adding it
Run it with:
npx -y @memberjunction/query-gen@6.1.5Pinned to 6.1.5, which is the version the findings above were found in. Drop the version to take whatever is newest, and the report on this page stops describing what you installed.
Where this came from
- Registry
- npm
- Package
- @memberjunction/query-gen
- Version read
- 6.1.5
- Resolved
- 2026-10-10
Built from source, attested
npm publishes a signed statement that this exact package was built from the repository below, at this commit. It is verifiable without taking our word for it.
- Repository
- github.com/memberjunction/mj
- Commit
- 954ac5f2c8e2
- Built by
- github.com/actions/runner/github-hosted
- Registry publish attestation
- signed by npm · 2026-10-10
- Checked
- 2026-10-10
The badge, if this is your listing
It renders the current rung (static scanned) and links back here, where what that does and does not establish is one click away. It updates itself as the evidence deepens.
[](https://ooruby.com/market/memberjunction-query-gen)About this listing
- Kind
- App
- Category
- Data & analytics
- Pricing
- Free
- Sandbox
- No
- Hosted
- No
- Updated
- 2026-10-07
More from memberjunction
See the storefrontSimilar apps
All apps4 findingsStatic scanned
Free
Indexes your Markdown notes and docs locally, then searches them by keyword, meaning or both.
165k installs/moMIT
5 findingsStatic scanned
4 findingsStatic scanned
Records each turn of your AI feature as an Amplitude event, with model, tokens, cost and latency.
60.4k installs/moMIT
Verification records what our published tests found on a specific version at a specific date. It is not a warranty, and it does not certify that software is free of defects.