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 agentmods add skills/m-binimran/dev-pack/query-optimizernpx skills add m-binimran/dev-pack --skill query-optimizergit clone --depth 1 https://github.com/m-binimran/dev-packWhat 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 | $0.00056 | $0.00404 |
| Opus 5 | $0.00028 | $0.00202 |
| Sonnet 5 | $0.00011 | $0.00081 |
| Haiku 4.5 | $0.00006 | $0.00040 |
Grade A, and why
query-optimizer 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 yesterday.
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.
What it actually says
query-optimizer
Make the query fast based on evidence, not guesses.
Process
- Get the plan: run
EXPLAIN (ANALYZE, BUFFERS) <query>. Never optimize without it. - Read the plan top-down: find the costliest node. Look for:
Seq Scanon a big table where an index could be used.Rows Removed by Filterhigh → missing/!selective index.- Estimated vs actual rows far apart → stale stats (
ANALYZE). - Nested loop over many rows → maybe a hash/merge join is better.
- Propose the smallest fix: an index, a rewritten predicate, a
LIMIT, or pagination. - Re-measure with
EXPLAIN ANALYZEand report before/after timing. Don't claim a win without it.
Common fixes
- Composite index ordered by selectivity for multi-column filters.
- Partial index (
where active) for queries that always filter the same way. - Replace
OFFSETpagination with keyset (where id > $last) for deep pages. - Kill N+1: one query per row in app code → use a join or
IN (...)/= ANY.
Output
- The plan's bottleneck in one sentence.
- The fix (SQL/DDL).
- Before/after timing from real
EXPLAIN ANALYZEruns.
Guardrails
- An index isn't free — it slows writes. Only add what the plan justifies.
- Don't add an index that duplicates an existing one's prefix.
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.
- yesterday First seen · 34 lines · 56 tokens per session scan A e6dc8bd37b1e
query-optimizer is a skill published in the GitHub repository m-binimran/dev-pack (2 stars, last pushed 2mo ago), licensed MIT. It adds 56 tokens to every session and 404 once invoked, about $0.0003 per session on Opus 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-08-31.
Other skills, from other repositories
investigate-issue
Investigate a GitHub issue by fetching details, analyzing the codebase, researching documentation, and presenting an actionable implementation plan with test guidance. Use when asked to investigate, analyze, triage, or plan work for a GitHub issue. Invoked with /investigate-issue or /investigate-issue (prompts for ID).
resolve-pr-comments-stack
Resolve unresolved PR review comments across an entire Graphite (gt) stack of many PRs, bottom-up, in one working directory. Use when asked to "go through this stack and resolve comments", "clean up review comments across the whole stack", or given a list/range of PR numbers that form (or partially form) a gt stack.…
resolve-pr-comments
Skill "resolve-pr-comments" from maximhq/bifrost, covering resolve pr comments, usage, workflow overview, step 1: detect repository and step 2: fetch unresolved comments (graphql).
harness-test-writer
Add regression test cases to the Bifrost provider harness (the Postman collection run via make run-provider-harness-test) based on a merged PR or a GitHub issue. Fetches the PR/issue, traces the affected wire path in the codebase, checks existing harness coverage, designs cases following harness conventions, inserts…
trulens-blocking-guardrails
Configure and use feedback functions as runtime blocking guardrails.
review-pr
Reviews a PR or diff with multi-angle finders and adversarial verification, then reports a findings table, a merge/no-merge recommendation, required followups, and offers to create a follow-up PR. Use when the user types /review-pr [PR# | branch | path].