Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add mendixlabs/mxcli --skill mendix-bulk-oql-dmlgit clone --depth 1 https://github.com/mendixlabs/mxcliWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/mendixlabs/mxcli/mendix-bulk-oql-dml)<a href="https://agentmods.dev/skills/mendixlabs/mxcli/mendix-bulk-oql-dml"><img src="https://agentmods.dev/badge/skills/mendixlabs/mxcli/mendix-bulk-oql-dml/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/mendixlabs/mxcli/mendix-bulk-oql-dml"><img src="https://agentmods.dev/badge/skills/mendixlabs/mxcli/mendix-bulk-oql-dml.svg" alt="Reviewed on agentmods" width="80" height="20"></a>- NVIDIA SkillSpector pass
What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00098 | $0.01363 |
| Opus 5.5 | $0.00039 | $0.00545 |
| Sonnet 5.5 | $0.00020 | $0.00273 |
| Haiku 4.5 | $0.00010 | $0.00136 |
Grade A, and why
mendix-bulk-oql-dml scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 120 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Bulk DML through OQL statements
What this is
The Mendix runtime executes OQL statements, not just queries. Three calls, all
in com.mendix.public-api.jar:
com.mendix.core.Core.createOqlStatement(String) // -> OqlStatement
OqlStatement.setVariable(name, value) // -> OqlStatement, chainable
OqlStatement.execute(IContext) // -> int rows affected
Studio Pro has no activity for this, so the only way to reach it is a Java action.
mdl/oql-dml-actions.mdl is three of them, authored in
MDL with inline Java, ready to apply to any project:
| Action | Use |
|---|---|
OQL_Execute(Statement) |
One statement, no variables. Returns rows affected, throws on failure. |
OQL_ExecuteWith(Statement, Name/Value/Type ×4) |
Same, with up to four bound, typed variables. |
OQL_Try(Statement) |
Returns OK rows=N or ERR … instead of throwing. For probing, not for production paths. |
mxcli exec .claude/skills/mendix-bulk-oql-dml/mdl/oql-dml-actions.mdl -p MyApp.mpr
Check the version first
Each statement type arrived in a different runtime release, and the last one is recent enough that "it works on my app" is not transferable:
| Statement | Available from |
|---|---|
DELETE |
11.1.0 |
UPDATE |
11.3.0 — associations 11.4.0 |
INSERT … SELECT |
11.6.0 — associations 11.7.0 |
INSERT … VALUES |
11.13.0 |
Pin the runtime version deliberately before building on this.
When to use it, and when not
Use it when the work is a set and nobody is looking at the rows: applying rules over a table, copying a year of records, promoting a staged import, archiving, backfilling a new column. One statement replaces a retrieve of every match into memory, a loop, and a commit per object.
Do not use it for a single object a user is editing. And know what it skips — this is the thing to say out loud before choosing it:
A statement runs in the database, inside the calling microflow's transaction. It does not pass through the object cache, so no event handlers fire, no validation rules run, an object already retrieved keeps its old values, and a client holding one is not refreshed.
What ships with it
4 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 1mo ago First seen · 120 lines · 98 tokens per session scan A 2054f3eb8084
mendix-bulk-oql-dml is a skill published in the GitHub repository mendixlabs/mxcli (131 stars, last pushed yesterday), licensed Apache-2.0. It adds 98 tokens to every session and 1,363 once invoked, about $0.0004 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.
Other skills, from other repositories
nosql-database-design
Designs a NoSQL data model by leading with access pattern analysis. Covers DynamoDB single-table design (PK/SK/GSI) and MongoDB embedding vs referencing, consistency models, and capacity planning. Invoked when the user asks to design a DynamoDB schema, MongoDB data model, or NoSQL data model.
sql-query-optimization
Diagnoses and optimises slow SQL queries using EXPLAIN ANALYZE. Covers identifying bottlenecks (sequential scans, bad estimates, heap fetches), index strategy, query rewrites, and verification. Invoked when the user asks to optimize a query, fix a slow database query, or improve database performance.
ship-safe-scan
Quick scan for leaked secrets — API keys, passwords, tokens, database URLs. Use when the user wants to check for hardcoded secrets or exposed credentials.
firebase
Use when building on Firebase — Firestore data modeling, Security Rules, Auth and custom claims, Cloud Functions, Storage, modular Web/Admin SDK imports — including symptoms like a database open to the internet, a query rejected by rules, or a doc stuck at 1 write/sec. NOT managed-Postgres BaaS with SQL and RLS (that…
notion-connector
Use when wiring server code or a cron job to Notion as an ops backend over its HTTP API: pushing or mirroring database rows, two-way sync without duplicates, page blocks, or an integration broken by the 2025-09-03 data-source split. NOT generic REST wiring (that is api-connector-builder), NOT inbound Notion webhook…
backend-development
Backend API design, database architecture, microservices patterns, and test-driven development. Use for designing APIs, database schemas, or backend system architecture.