audit-query-indexes SKILL.md skillA
audit-query-indexes from baristaze/swe_guidelines is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add baristaze/swe_guidelines/audit-query-indexes@git:20261014.62aa70ePins git:20261014.62aa70e in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- baristaze/swe_guidelines
- Path
scaffold/acme_root/.agents/skills/audit-query-indexes/SKILL.md- Versions recorded
- 2
- Latest version
- git:20261014.62aa70e, committed Oct 14, 2026
- First version recorded
- Sep 29, 2026
- Size
- 7,453 bytes
- Repository stars
- 94
- License
- MIT
Audit whether the indexes fit the queries, and what breaks first under load: every statement the Postgres storage sends, mapped to the index that serves it and measured with EXPLAIN on a database of its own seeded at a stated scale, under the login and the tenant scope the application uses. Reports each statement's verdict, the hot paths, the unused indexes, and fixes tested on the same data. Never changes anything.
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
# audit-query-indexes Every query the system sends, the index that serves it, and what it costs when the data is large. The costs are measured, not guessed: on a database the run makes and seeds, under the same login, row-level security policy, and scope the storage funnel uses. ## Input `[--scale <n>] [--focus <namespace,...>] [--contention]` `--scale` is the seed's, `1` by default (5,000 people with a personal org each, a team org of 200 members, a million change events, 50,000 work items); `0.01` is a quick run with the same shape, whose times prove the wiring and nothing about scale. `--focus` narrows the audit, the hot paths of step 5 included, to some namespaces (`tenancy`, `change_events`, `work`, ...); every namespace by default. `--contention` adds the measure of locks held across round trips. The audit reads and runs the checkout, tools and code alike; to audit another commit, run it from a checkout of that commit that has `ops/audit/`. Every command runs from the repository root. ## Role and credential None, local only. The skill runs on the local stack (`make infra-up`, with `make migrate` run once), in a database it makes, seeds, …
Read the whole file at its exact version.
How to install
mdr add baristaze/swe_guidelines/audit-query-indexes@sha256:74d7ffe2681f8bbcThe line at the top of this page pins the label git:20261014.62aa70e, 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.
[](https://markdownregistry.com/a/art_mitwbksyokhwz6iu)
1 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 2 versions of this file, between Sep 29, 2026 and Oct 14, 2026, about one every 15 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20261014.62aa70e latest | 2026-10-14 | 62aa70e | 7,453 B | A | view · diff |
| git:20260929.3422014 | 2026-09-29 | 3422014 | 7,427 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (7453 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
baristaze/swe_guidelines · 94 stars · license MIT · pushed 2026-11-02 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_mitwbksyokhwz6iu GET https://markdownregistry.com/api/v1/resolve?ref=baristaze/swe_guidelines/audit-query-indexes GET https://markdownregistry.com/api/v1/blob/74d7ffe2681f8bbc8d8d6cc5eaa8773ff4236cde055f89061ae5983cabe23410
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.