Home / mendixlabs / mxcli · .claude/skills/packs/mendix-odata-pushdown/SKILL.md · GitHub

mendix-odata-pushdown skillA

mendix-odata-pushdown is agent-read markdown (skill) from mendixlabs/mxcli: Push OData query options into the SQL of a Mendix resource served by a read microflow, so $filter, $orderby, $top, $skip, $count and the key lookup reach the database instead of being silently dropped. Use when publishing an OData resource over data Mendix has no table for — a warehouse view, a legacy database, a Databricks catalogue, a stored procedure, a CSV read through a connector — or when a published resource returns 200 with the wrong rows and nothing appears in the log..

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

# Pushing OData query options into your own SQL

## The problem this exists for

Mendix will publish any entity over OData, including one with no table behind
it: declare the resource non-persistable, give it a read microflow, done. What
the documentation does not say is that Mendix then applies **none** of the query
options to your answer. `$filter`, `$orderby`, `$top`, `$skip`, `$count` and the
key lookup all arrive on the request URI and all stay there. Whatever the
microflow returns is exactly what the client gets.

That is not a 500 and not an empty grid. It is a **200 with the wrong rows**:

- `?$top=5` returns all 917 rows and the widget shows five of them, so paging
  looks correct while every page ships the whole table.
- A client re-reading one held row by key gets the collection back, adopts the
  first row as that object's identity, and **keeps it**. A detail page for one
  record shows another record's data, and nothing logs a word.

The second one is the reason to care. It is not a performance problem; it is
wrong data on screen, and every check is green.

## What the pack gives you

Four Java actions and the entity they return. Nothing in them is specific to any
…

Read the whole file at its exact version.

How to install

Latest version
mdr add mendixlabs/mxcli/mendix-odata-pushdown@git:20260818.e76779d
Exact content
mdr add mendixlabs/mxcli/mendix-odata-pushdown@sha256:89fd12e09ea03643

Pin 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.

Badge

mdr badge

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

1 badge views in 30 days

Versions

versioncommittedcommitsizeaudit
git:20260818.e76779d latest2026-08-18 e76779d 9,901 BA view · diff
git:20260817.26e379b2026-08-17 26e379b 9,717 BA view · diff
git:20260816.11b7f4e2026-08-16 11b7f4e 6,563 BA view

Audit of the latest version

A  17 of 17 checks passed. Deterministic, no model, 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 (9901 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 · 124 stars · license Apache-2.0 · pushed 2026-09-24 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_fimym54na5pog4ge
GET https://markdownregistry.com/api/v1/resolve?ref=mendixlabs/mxcli/mendix-odata-pushdown
GET https://markdownregistry.com/api/v1/blob/89fd12e09ea03643bcf92264537367e0bdf1b296da135a1720583634bb0962ff

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.

More from mendixlabs/mxcli

agents 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:20260922.4954f84 · audit A · 124 stars
alter-page 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:20260923.328828c · audit A · 124 stars
analyze-runtime 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:20260821.ff81a24 · audit B · 124 stars
assess-migration 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:20260821.ff81a24 · audit A · 124 stars
assess-quality 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:20260821.ff81a24 · audit A · 124 stars
atlas-design 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:20260915.3d3ca1f · audit A · 124 stars
bootstrap-app 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:20260922.98aa174 · audit A · 124 stars
browse-integrations 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:20260821.ff81a24 · audit A · 124 stars
bulk-widget-updates skill
mendixlabs/mxcli · .claude/skills/mendix/bulk-widget-updates/SKILL.md · Discover and bulk-change widget properties across many pages with SHOW WIDGETS and UPDATE WIDGETS. Use when the same…
git:20260821.ff81a24 · audit A · 124 stars
business-events 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:20260821.ff81a24 · audit A · 124 stars
catalog-search 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:20260821.ff81a24 · audit A · 124 stars
cheatsheet-errors skill
mendixlabs/mxcli · .claude/skills/mendix/cheatsheet-errors/SKILL.md · Quick fixes for the MDL syntax errors that come up most: undeclared variables, wrong retrieve source, list operations…
git:20260911.0d73eed · audit A · 124 stars

Every file in mendixlabs/mxcli

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