agami-query SKILL.md skillA

agami-query from agamiai/agami-core is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add agamiai/agami-core/agami-query@git:20261102.70809b5

Pins git:20261102.70809b5 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
agamiai/agami-core
Path
plugins/agami/skills/agami-query/SKILL.md
Versions recorded
19
Latest version
git:20261102.70809b5, committed Nov 2, 2026
First version recorded
Aug 3, 2026
Size
98,971 bytes
Repository stars
29
License
a license file GitHub does not identify

Answers natural-language questions about the user's database. Loads the agami semantic model (subject areas, tables, columns, relationships with join cardinality, entities, metrics) and few-shot examples from <artifacts_dir>/<profile>/, generates SQL via the examples-first traversal (pick subject area → match examples → resolve entities/metrics → compound table context), executes it locally via the user's chosen tool (psql / mysql / snowsql / sqlite3 native CLI, DuckDB binary, or the Python…

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

# agami query-database

You answer the user's natural-language question about their database. Goal: generate correct SQL from the semantic model + the few-shot examples via the examples-first traversal, execute it locally, return rows + an insight, and offer a chart / export when appropriate. Everything runs on the user's machine.

This skill orchestrates:

1. **Setup** (once per session) — resolve the profile + the semantic model at `<artifacts_dir>/<profile>/`, verify the configured database tool still works.
2. **Generate SQL** — examples-first traversal: pick the subject area → match curated examples → (cold start) resolve entities/metrics + identify opaque literals → compound `get_table_context` → produce one SQL statement → safety checks.
3. **Execute** — run via the chosen tool; the Python tier runs the fan/chasm pre-flight and the scope/PII gates; auto-retry on classified errors; risk-assess large-table queries.
4. **Present** — markdown table; CSV via `--csv` or "export this"; Chart.js HTML via `--chart` or "make that a chart".
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add agamiai/agami-core/agami-query@sha256:8b081908a877303b

The line at the top of this page pins the label git:20261102.70809b5, 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_43sdilxrkehr6gqb.svg)](https://markdownregistry.com/a/art_43sdilxrkehr6gqb)

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

Versions

The registry has recorded 19 versions of this file, between Aug 3, 2026 and Nov 2, 2026, about one every 5 days.

versioncommittedcommitsizeaudit
git:20261102.70809b5 latest2026-11-02 70809b5 98,971 BA view · diff
git:20261102.8710bc02026-11-02 8710bc0 98,981 BA view · diff
git:20261102.4d1962d2026-11-02 4d1962d 98,480 BA view · diff
git:20261102.b003e1d2026-11-02 b003e1d 98,746 BA view · diff
git:20261030.0b08d432026-10-30 0b08d43 98,235 BA view · diff
git:20261030.ffcf5cc2026-10-30 ffcf5cc 98,245 BA view · diff
git:20261029.be66b1a2026-10-29 be66b1a 98,016 BA view · diff
git:20261027.f35f6e12026-10-27 f35f6e1 98,132 BA view · diff
git:20261013.9f20fe32026-10-13 9f20fe3 97,903 BA view · diff
git:20261012.9e27d382026-10-12 9e27d38 97,649 BA view · diff
git:20261011.c18f7cd2026-10-11 c18f7cd 97,139 BA view · diff
git:20261007.2686e642026-10-07 2686e64 96,724 BA view · diff
git:20260916.a0ecf982026-09-16 a0ecf98 96,353 BA view · diff
git:20260916.c0c33252026-09-16 c0c3325 96,241 BA view · diff
git:20260805.d0f57d52026-08-05 d0f57d5 96,061 BA view · diff
git:20260805.76aad282026-08-05 76aad28 95,694 BA view · diff
git:20260805.59796b42026-08-05 59796b4 95,440 BA view · diff
git:20260804.bb65ee12026-08-04 bb65ee1 92,534 BA view · diff
git:20260803.62b27712026-08-03 62b2771 91,682 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 (98971 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

agamiai/agami-core · 29 stars · license a license file GitHub does not identify · pushed 2026-11-06 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_43sdilxrkehr6gqb
GET https://markdownregistry.com/api/v1/resolve?ref=agamiai/agami-core/agami-query
GET https://markdownregistry.com/api/v1/blob/8b081908a877303ba218a0b07adfe5d66e147a220bdf998a16d0383a80a88515

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 agamiai/agami-core

CLAUDE.md CLAUDE.md file
agamiai/agami-core · CLAUDE.md
git:20260915.6624fbc · audit A · 29 stars
agami-connect SKILL.md skill
agamiai/agami-core · plugins/agami/skills/agami-connect/SKILL.md · End-to-end database connection for agami: sets up credentials on first run (DB-type picker → writes…
git:20261102.70809b5 · audit A · 29 stars
agami-deploy SKILL.md skill
agamiai/agami-core · plugins/agami/skills/agami-deploy/SKILL.md · EARLY ACCESS (in testing) — usable today, but newer than the local single-player path; feedback welcome via a GitHub…
git:20261011.c18f7cd · audit B · 29 stars
agami-eval SKILL.md skill
agamiai/agami-core · plugins/agami/skills/agami-eval/SKILL.md · Runs the golden evaluation harness for a profile. Picks one golden dataset, regenerates SQL for every question in it…
git:20261011.c18f7cd · audit A · 29 stars
agami-model SKILL.md skill
agamiai/agami-core · plugins/agami/skills/agami-model/SKILL.md · The single dashboard for the active profile's semantic model — browse, curate, AND sign off the trust layer in one…
git:20261102.70809b5 · audit A · 29 stars
agami-reconcile SKILL.md skill
agamiai/agami-core · plugins/agami/skills/agami-reconcile/SKILL.md · Reconciles known (label, expected_value) numbers from an existing dashboard against agami's answers. Input can be a…
git:20261011.c18f7cd · audit A · 29 stars
agami-save-correction SKILL.md skill
agamiai/agami-core · plugins/agami/skills/agami-save-correction/SKILL.md · Saves a user correction so future queries learn from it. Always appends a (question, corrected_sql) pair to the subject…
git:20261030.0b08d43 · audit A · 29 stars
agami-save-golden SKILL.md skill
agamiai/agami-core · plugins/agami/skills/agami-save-golden/SKILL.md · Writes golden-dataset items for a profile through two doors. The import door turns a question bank — a CSV, one sheet…
git:20261011.c18f7cd · audit A · 29 stars
agami-serve SKILL.md skill
agamiai/agami-core · plugins/agami/skills/agami-serve/SKILL.md · Wires the local agami MCP server (python -m mcp_harness) into the Claude Desktop app in one step, so you can ask your…
git:20261011.c18f7cd · audit A · 29 stars

Every file in agamiai/agami-core

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