malloy-queries SKILL.md skillA

malloy-queries from malloydata/publisher is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add malloydata/publisher/malloy-queries@git:20261110.9520ca9

Pins git:20261110.9520ca9 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
malloydata/publisher
Path
skills/malloy-queries/SKILL.md
Versions recorded
5
Latest version
git:20261110.9520ca9, committed Nov 10, 2026
First version recorded
Sep 25, 2026
Size
22,260 bytes
Repository stars
133
License
MIT

Read before writing or debugging a Malloy query. Dates, aggregates vs dimensions, joins, filters, strings, window functions, chart annotations, and the compile errors a SQL habit produces.

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

<!--
Copyright (c) Credible Data Inc.
SPDX-License-Identifier: MIT
-->

# Malloy Query Reference

Only use field names defined in the model. Ground yourself first with `get_context`; never invent entities or guess field names.

> **Tool names** are written bare here - `get_context`, `execute_query`, `search_malloy_docs`. The exact prefixed name depends on the host surface; match each against the tools you actually have.

## Query Patterns

**Simple aggregation:**
```malloy
run: source -> {
  aggregate: total_revenue, order_count
}
```

**Group by dimension:**
```malloy
run: source -> {
  group_by: category
  aggregate: revenue
  order_by: revenue desc
  limit: 10
}
```

**Time trend:**
```malloy
# line_chart
run: source -> {
  group_by: order_date.month
  aggregate: revenue
  order_by: 1
}
```

**Filtered query:**
```malloy
run: source -> {
  where: status = 'active'
  group_by: region
  aggregate: count_orders, total_revenue
}
```

**Run a pre-built view:**
```malloy
run: source -> view_name
```

**Refine a view with additional options:**
```malloy
run: source -> view_name + { limit: 10, where: region = 'US' }
```

**Percent of total:** use `all()`, not `parent()`.
```malloy
…

Read the whole file at its exact version.

How to install

No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_33xunjjrcrvry7cb/0a951e1804bd02b9ab8b851befdbbe14eb65c5c49f225a90191209baf15b3aa1.json

Then /plugin install malloy-queries@markdownregistry-33xunjjrcrvry7cb in Claude Code. It installs git:20261110.9520ca9, the one graded A here, pinned to the commit it was graded at, and leaves it there.

The exact contents, by fingerprint
mdr add malloydata/publisher/malloy-queries@sha256:0a951e1804bd02b9

The line at the top of this page pins the label git:20261110.9520ca9, 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_33xunjjrcrvry7cb.svg)](https://markdownregistry.com/a/art_33xunjjrcrvry7cb)

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

Ask from your agent
claude mcp add --transport http markdownregistry https://markdownregistry.com/mcp/registry

Then ask it: what changed in malloydata/publisher/malloy-queries since the version I have? It reads every saved version here, no key and no account. Any agent that speaks MCP can add it.

Got a copy of malloy-queries from somewhere else? Ask it: where did my malloy-queries come from, and what was changed? It names the public original, the version yours is closest to and every changed line. The text is not kept.

Versions

The registry has recorded 5 versions of this file, between Sep 25, 2026 and Nov 10, 2026, about one every 11 days.

Watch this file (sign in, one email per new version)

versioncommittedcommitsizeaudit
git:20261110.9520ca9 latest2026-11-10 9520ca9 22,260 BA view · diff
git:20261013.97d8caf2026-10-13 97d8caf 20,622 BA view · diff
git:20261006.26020f82026-10-06 26020f8 20,302 BA view · diff
git:20260930.0473cf82026-09-30 0473cf8 14,308 BA view · diff
git:20260925.b8a3a772026-09-25 b8a3a77 11,999 BA view
Keep it current by itself, install once

Committed this skill to a repository? Install the markdownregistry skill updates app on it, or on all of them. When the registry saves a newer version, a pull request brings your copy to it within minutes, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

Install on GitHub

It asks to read and write contents and pull requests, and to read metadata. No workflow file, no Actions setting, nothing runs on your runners. Uninstall it and everything the registry kept about your repository is deleted.

Keep it current by itself

Committed this skill to a repository? Add one workflow file, and when a newer version is saved, a pull request brings your copy to it, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

mkdir -p .github/workflows && curl -fsSL https://markdownregistry.com/ci/skill-updates.yml -o .github/workflows/skill-updates.yml

It runs daily on GitHub Actions, no key and no account. Read the workflow before you add it.

Check a whole project

From the root of your project, one line hashes each installed skill's SKILL.md, your AGENTS.md and your CLAUDE.md, and asks the registry once. Only the fingerprints and paths are sent.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --data-binary @- https://markdownregistry.com/api/v1/check-copies

In CI, add --fail-with-body: the answer is 409 when any file is behind, so the step fails and still prints which files.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --fail-with-body --data-binary @- https://markdownregistry.com/api/v1/check-copies

No sha256sum on your machine? shasum -a 256 prints the same lines.

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 (22260 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

malloydata/publisher · 133 stars · license MIT · pushed 2026-11-17 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_33xunjjrcrvry7cb
GET https://markdownregistry.com/api/v1/resolve?ref=malloydata/publisher/malloy-queries
GET https://markdownregistry.com/api/v1/blob/0a951e1804bd02b9ab8b851befdbbe14eb65c5c49f225a90191209baf15b3aa1

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 malloydata/publisher

fix-scan-finding SKILL.md skill
malloydata/publisher · .claude/skills/fix-scan-finding/SKILL.md · Fix a CRITICAL Trivy finding that is failing CI in this repo (a vulnerability, misconfiguration, or secret from…
git:20261001.a42ad3a · audit A · 133 stars
publisher-release SKILL.md skill
malloydata/publisher · .claude/skills/publisher-release/SKILL.md · Cut a Malloy Publisher release, and write the RELEASE_NOTES.md entries a release ships. Use when asked to release, cut…
git:20261116.3b6d4a1 · audit A · 133 stars
AGENTS.md AGENTS.md file
malloydata/publisher · AGENTS.md
git:20261117.320a806 · audit B · 133 stars
CLAUDE.md CLAUDE.md file
malloydata/publisher · CLAUDE.md
git:20261116.660817a · audit B · 133 stars
AGENTS.md@examples/html-data-app AGENTS.md file
malloydata/publisher · examples/html-data-app/AGENTS.md
git:20261105.0bd58a0 · audit B · 133 stars
analyst-conventions SKILL.md skill
malloydata/publisher · examples/storefront/agents/analyst/skills/analyst-conventions/SKILL.md · House conventions for revenue questions on the storefront package. Read before answering any revenue, sales, or…
git:20261012.9b94813 · audit A · 133 stars
malloy-phrase-detection SKILL.md skill
malloydata/publisher · examples/storefront/skills/malloy-phrase-detection/SKILL.md · How to turn a storefront question into get_context search targets, including the shop vocabulary that does not appear…
git:20261012.9b94813 · audit A · 133 stars
storefront-conventions SKILL.md skill
malloydata/publisher · examples/storefront/skills/storefront-conventions/SKILL.md · What storefront's measures actually count, and the four places a reasonable reading of them is wrong. Read before…
git:20261012.9b94813 · audit A · 133 stars
AGENTS.md@packages/create-malloy-package/templates AGENTS.md file
malloydata/publisher · packages/create-malloy-package/templates/AGENTS.md
git:20261111.2af71bc · audit A · 133 stars
conventions SKILL.md skill
malloydata/publisher · packages/server/tests/fixtures/skills-agents-test/agents/analyst/skills/conventions/SKILL.md · House rules for the analyst.
git:20261012.9b94813 · audit B · 133 stars
house-rules SKILL.md skill
malloydata/publisher · packages/server/tests/fixtures/skills-agents-test/skills/house-rules/SKILL.md · How this package defines its terms.
git:20261012.9b94813 · audit B · 133 stars
malloy-analysis SKILL.md skill
malloydata/publisher · packages/server/tests/fixtures/skills-agents-test/skills/malloy-analysis/SKILL.md · The package's own analysis guide.
git:20261012.9b94813 · audit B · 133 stars

Every file in malloydata/publisher

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