write-oql-queries SKILL.md skillA

write-oql-queries from mendixlabs/mxcli is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add mendixlabs/mxcli/write-oql-queries@git:20261025.dccdfe6

Pins git:20261025.dccdfe6 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
mendixlabs/mxcli
Path
.claude/skills/mendix/write-oql-queries/SKILL.md
Versions recorded
11
Latest version
git:20261025.dccdfe6, committed Oct 25, 2026
First version recorded
Aug 21, 2026
Size
27,249 bytes
Repository stars
137
License
Apache-2.0

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.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

<!-- skill-index: generated by scripts/skill-index.py; make check-skill-index -->
## Find it fast

`sed -n '<from>,<to>p' SKILL.md` one section rather than reading the file;
`./mxcli syntax <topic>` answers *how do I write this* for a fraction of either.

| lines | section |
|---|---|
| 27-32 | Reference files |
| 33-35 | Purpose |
| 36-42 | When to Use This Skill |
| 43-402 | Critical OQL Syntax Rules |
| 403-539 | Step-by-Step Process |
| 540-635 | Common Mistakes to Avoid |
| 636-667 | Testing OQL Queries |
| 668-686 | Integration with MDL Linter |
| 687-694 | References |
| 695-719 | Summary Checklist |

<!-- /skill-index -->
# 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
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add mendixlabs/mxcli/write-oql-queries@sha256:775b49df9e3125a4

The line at the top of this page pins the label git:20261025.dccdfe6, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_yss7gfpymqu6safu.svg)](https://markdownregistry.com/a/art_yss7gfpymqu6safu)

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 11 versions of this file, between Aug 21, 2026 and Oct 25, 2026, about one every 6 days.

versioncommittedcommitsizeaudit
git:20261025.dccdfe6 latest2026-10-25 dccdfe6 27,249 BA view · diff
git:20261023.3074c5f2026-10-23 3074c5f 26,142 BA view · diff
git:20261010.50fe33a2026-10-10 50fe33a 25,619 BA view · diff
git:20261004.96b4c352026-10-04 96b4c35 24,982 BA view · diff
git:20261004.0953ed02026-10-04 0953ed0 24,871 BA view · diff
git:20261001.3a9ec832026-10-01 3a9ec83 21,862 BA view · diff
git:20260913.a2cdc3c2026-09-13 a2cdc3c 21,821 BA view · diff
git:20260912.6c127022026-09-12 6c12702 21,425 BA view · diff
git:20260912.36367222026-09-12 3636722 19,491 BA view · diff
git:20260822.b0cab652026-08-22 b0cab65 18,552 BA view · diff
git:20260821.ff81a242026-08-21 ff81a24 24,833 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (27249 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

GitHub

mendixlabs/mxcli · 137 stars · license Apache-2.0 · pushed 2026-11-07 · 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/775b49df9e3125a4a68924dd9692868a9041194107bb46a4b30ce11d3c3f1d77

Your AI assistant 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.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from mendixlabs/mxcli

issue-triage SKILL.md skill
mendixlabs/mxcli · .claude/skills/issue-triage/SKILL.md · Cluster and classify the open issues in the ako/mxcli fork, both the mendixlabs/mxcli issues mirrored into it and the…
git:20261106.37b0fe6 · audit A · 137 stars
agents SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/agents/SKILL.md · Author Mendix AI agent documents in MDL — Model, Knowledge Base, Consumed MCP Service and Agent, with variables, tools…
git:20261010.50fe33a · audit A · 137 stars
alter-page SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/alter-page/SKILL.md · Modify an existing page or snippet's widget tree in place with ALTER PAGE / ALTER SNIPPET — SET, INSERT, DROP, REPLACE…
git:20261102.69cffcc · audit A · 137 stars
analyze-runtime SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/analyze-runtime/SKILL.md · Find out what a running Mendix app actually does — logs, Prometheus metrics, OpenTelemetry traces and the model…
git:20261010.50fe33a · audit B · 137 stars
assess-migration SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/assess-migration/SKILL.md · Investigate an existing non-Mendix application (Java, .NET, Python, Node, PHP, …) and produce a structured migration…
git:20261010.50fe33a · audit A · 137 stars
assess-quality SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/assess-quality/SKILL.md · Audit a Mendix project against best practices for naming, security, performance, maintainability and architecture, and…
git:20261101.da695f0 · audit A · 137 stars
atlas-design SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/atlas-design/SKILL.md · Make a Mendix app look designed rather than default-Atlas: layout, spacing, typography, colour and design properties…
git:20261010.50fe33a · audit A · 137 stars
bootstrap-app SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/bootstrap-app/SKILL.md · Provision a Mendix project in a repo that has none — interview, `mxcli new`, session hook, project brief, first commit…
git:20261104.237ae1e · audit A · 137 stars
browse-integrations SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/browse-integrations/SKILL.md · Discover the external services a project consumes and browse their cached contracts through the MDL CATALOG — OData…
git:20261012.365840a · audit A · 137 stars
bulk-widget-updates SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/bulk-widget-updates/SKILL.md · Discover and bulk-change widget properties across many pages with LIST WIDGETS and UPDATE WIDGETS. Use when the same…
git:20261010.50fe33a · audit A · 137 stars
business-events SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/business-events/SKILL.md · Define event-driven APIs over Kafka with Mendix business event services — publish and subscribe contracts…
git:20261025.b57af11 · audit A · 137 stars
catalog-search SKILL.md skill
mendixlabs/mxcli · .claude/skills/mendix/catalog-search/SKILL.md · Search the Mendix Catalog platform service registry (catalog.mendix.com) from the CLI to find services published across…
git:20261010.50fe33a · audit A · 137 stars

Every file in mendixlabs/mxcli

Browse by kind, by grade A, or by owner.