write-oql-queries skillA
write-oql-queries is agent-read markdown (skill) from mendixlabs/mxcli: Write OQL for Mendix VIEW entities — joins, aggregates, calculated fields, and the syntax the runtime actually accepts. Use when creating a VIEW entity or building a report or analytics query..
Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.
What the file says
# Skill: Write OQL Queries for Mendix VIEW Entities ## Reference files - [`reference/patterns.md`](reference/patterns.md) — the recurring OQL shapes (aggregation, joins across associations, date bucketing, ranking, filtered counts) and a full worked query, to adapt rather than derive. ## Purpose Generate correct OQL (Object Query Language) queries for Mendix VIEW entities. This skill helps you create VIEW entities with proper OQL syntax that will execute successfully in Mendix runtime. ## When to Use This Skill - User asks to create a VIEW entity - User requests help with OQL queries - User wants to create analytics, reports, or aggregated data views - User needs to join entities or create calculated fields - You encounter OQL syntax errors when creating VIEW entities ## Critical OQL Syntax Rules ### 0. VIEW Entity Best Practices (CRITICAL) **RULE 1: All SELECT columns MUST have explicit AS aliases** Every column in the SELECT clause must have an alias that matches the entity attribute name: ```sql -- ❌ WRONG - Missing aliases create view entity Finance.CashFlowProjection ( ProjectionDate: datetime, ProjectedIncome: decimal, ProjectedExpense: decimal ) as ( …
Read the whole file at its exact version.
How to install
mdr add mendixlabs/mxcli/write-oql-queries@git:20260913.a2cdc3cmdr add mendixlabs/mxcli/write-oql-queries@sha256:e4cf6cda6bc8e384Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.
[](https://markdownregistry.com/a/art_yss7gfpymqu6safu)
1 badge views in 30 days
Versions
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20260913.a2cdc3c latest | 2026-09-13 | a2cdc3c | 21,821 B | A | view · diff |
| git:20260912.6c12702 | 2026-09-12 | 6c12702 | 21,425 B | A | view · diff |
| git:20260912.3636722 | 2026-09-12 | 3636722 | 19,491 B | A | view · diff |
| git:20260822.b0cab65 | 2026-08-22 | b0cab65 | 18,552 B | A | view · diff |
| git:20260821.ff81a24 | 2026-08-21 | ff81a24 | 24,833 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (21821 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
mendixlabs/mxcli · 124 stars · license Apache-2.0 · pushed 2026-09-24 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_yss7gfpymqu6safu GET https://markdownregistry.com/api/v1/resolve?ref=mendixlabs/mxcli/write-oql-queries GET https://markdownregistry.com/api/v1/blob/e4cf6cda6bc8e3846af9acebf362e0b1cc2e77108b6c69fcbf3cba77e7aee967
Your agent does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.