flux-query SKILL.md skillA

flux-query from jeremylongshore/tons-of-skills-marketplace is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add jeremylongshore/tons-of-skills-marketplace/flux-query@v0.6.4

Pins v0.6.4 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
jeremylongshore/tons-of-skills-marketplace
Path
plugins/ai-agency/tonone/skills/flux-query/SKILL.md
Versions recorded
1
Latest version
v0.6.4, committed May 1, 2026
Size
3,279 bytes
Repository stars
2,907
License
MIT

Optimize slow database queries — analyze execution plans, add indexes, rewrite queries. Use when asked about "slow query", "optimize SQL", "query performance", or "explain this query".

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

# Optimize Slow Queries

You are Flux — the data engineer on the Engineering Team.

Follow the output format defined in docs/output-kit.md — 40-line CLI max, box-drawing skeleton, unified severity indicators, compressed prose.

## Steps

### Step 0: Detect Environment

Identify the database:

- Check for ORM configs: `prisma/schema.prisma`, `alembic.ini`, `drizzle.config.ts`, `ormconfig.ts`
- Check for connection strings to identify the engine (PostgreSQL, MySQL, SQLite, etc.)
- Check for query code: ORM queries, raw SQL files, repository/DAO layers
- Identify if there is a query logging or APM tool in use

If the stack is ambiguous, ask the user.

### Step 1: Read the Query

Get the full query — either from the user directly or by finding it in the codebase:

- Search for the slow query in ORM code, raw SQL, or query builder calls
- If the user provides EXPLAIN output, read it carefully
- Understand the intent: what data is this query trying to retrieve?

### Step 2: Analyze the Query

Check for these common performance problems:

- **Missing indexes** — columns in WHERE, JOIN ON, ORDER BY without indexes
- **Full table scans** — no filtering or filtering on unindexed columns
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add jeremylongshore/tons-of-skills-marketplace/flux-query@sha256:e20e0fd700ca7f9e

The line at the top of this page pins the label v0.6.4, 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_sf2rocovhjm3bmdt.svg)](https://markdownregistry.com/a/art_sf2rocovhjm3bmdt)

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

Versions

The registry has recorded 1 version of this file, committed on May 1, 2026.

versioncommittedcommitsizeaudit
v0.6.4 latest2026-05-01 38b9461 3,279 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 (3279 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

jeremylongshore/tons-of-skills-marketplace · 2,907 stars · license MIT · pushed 2026-11-08 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_sf2rocovhjm3bmdt
GET https://markdownregistry.com/api/v1/resolve?ref=jeremylongshore/tons-of-skills-marketplace/flux-query
GET https://markdownregistry.com/api/v1/blob/e20e0fd700ca7f9e5eef5f9493fbd459b6b42ee1abc85039f292a0275f9fbc6d

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 jeremylongshore/tons-of-skills-marketplace

beads SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · .agents/skills/beads/SKILL.md · Use when working in a repository that uses bd or Beads for durable project task tracking, issue dependencies, blocker…
git:20261022.33a49ad · audit A · 2,907 stars
AGENTS.md AGENTS.md file
jeremylongshore/tons-of-skills-marketplace · AGENTS.md
git:20261022.33a49ad · audit A · 2,907 stars
CLAUDE.md CLAUDE.md file
jeremylongshore/tons-of-skills-marketplace · CLAUDE.md
git:20261022.f12c241 · audit A · 2,907 stars
DESIGN.md@marketplace DESIGN.md file
jeremylongshore/tons-of-skills-marketplace · marketplace/DESIGN.md
git:20260910.e6f3178 · audit A · 2,907 stars
agency-os SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · plugins/ai-agency/agency-os/skills/agency-os/SKILL.md · Notion-as-source-of-truth dispatch board for running your work like an AI agency. One Tasks database is the source of…
v0.2.0 · audit A · 2,907 stars
audit SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · plugins/ai-agency/hyperflow/skills/audit/SKILL.md · Use when the user wants a code review on recent changes — quality, spec, security, or performance feedback. Triggers a…
v3.1.3 · audit A · 2,907 stars
background SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · plugins/ai-agency/hyperflow/skills/background/SKILL.md · Use when the user wants to see, inspect, cancel, or prune background agents fired during prior chain runs. Read/manage…
v4.7.0 · audit A · 2,907 stars
bridge SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · plugins/ai-agency/hyperflow/skills/bridge/SKILL.md · Use when the user wants hyperflow's behavioral rules to apply outside the terminal CLI — in Claude Code Desktop…
v4.10.1 · audit A · 2,907 stars
cache SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · plugins/ai-agency/hyperflow/skills/cache/SKILL.md · Use when the user wants to view, search, add, edit, prune, archive, or clear hyperflow memory entries. CRUD interface…
v3.1.3 · audit A · 2,907 stars
deploy SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · plugins/ai-agency/hyperflow/skills/deploy/SKILL.md · Use when ready to ship — runs pre-push gates (lint, typecheck, build, tests, security sweep), commits, releases, and…
v3.1.3 · audit A · 2,907 stars
design SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · plugins/ai-agency/hyperflow/skills/design/SKILL.md · Use when the user wants the visual/experiential design of a product done systematically — a design system, a screen, a…
v1.0.0 · audit A · 2,907 stars
dispatch SKILL.md skill
jeremylongshore/tons-of-skills-marketplace · plugins/ai-agency/hyperflow/skills/dispatch/SKILL.md · Use when a task file exists in .hyperflow/tasks/ and workers need dispatching. Fans out parallel workers under…
v3.2.0 · audit A · 2,907 stars

Every file in jeremylongshore/tons-of-skills-marketplace

Other files named flux-query

flux-query SKILL.md skill
tonone-ai/tonone · bundle/engineering-team/skills/flux-query/SKILL.md · Optimize slow database queries — analyze execution plans, add indexes, rewrite queries. Use when asked about "slow…
v0.6.4 · audit A · 77 stars
flux-query SKILL.md skill
tonone-ai/tonone · bundle/full-team/skills/flux-query/SKILL.md · Optimize slow database queries — analyze execution plans, add indexes, rewrite queries. Use when asked about "slow…
v0.6.4 · audit A · 77 stars

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