Skip to content
Agentmart
Submit a tool

query-optimization

Repeatable workflow for "is this query or aggregate efficient, and can we prove an optimization helps?" in any codebase.

Skill by jorgeavaldez

IndexedLicense unknown
Write a review

Install

Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.

npx agentmarket install skill/jorgeavaldez-query-optimization

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

Repeatable workflow for "is this query or aggregate efficient, and can we prove an optimization helps?" in any codebase. Captures the exact SQL and params an ORM emits, then compares old vs new with read-only EXPLAIN (ANALYZE, BUFFERS) and behavior tests. jj-first, ORM-agnostic (Drizzle, Prisma, Kysely, Knex, TypeORM, SQLAlchemy, Django, Rails, raw SQL). Use for "is this query efficient", "optimize this aggregate/dashboard query", "reduce round trips", "prove this is faster", or "EXPLAIN this".

Use cases: backend, data, productivity

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.

Tools
No tools found
Secrets
None asked for
Install scripts
None found
Runs as
Python package

Network hosts it talks to 1

  • codeload.github.com · found in install command

Files it touches

  • ~/.claude/skills/query-optimization

What's inside

Skill name
query-optimization
Description
Repeatable workflow for "is this query or aggregate efficient, and can we prove an optimization helps?" in any codebase. Captures the exact SQL and params an ORM emits, then compares old vs new with read-only EXPLAIN (ANALYZE, BUFFERS) and behavior tests. jj-first, ORM-agnostic (Drizzle, Prisma, Kysely, Knex, TypeORM, SQLAlchemy, Django, Rails, raw SQL). Use for "is this query efficient", "optimize this aggregate/dashboard query", "reduce round trips", "prove this is faster", or "EXPLAIN this".
License
unknown
Instructions
210 lines in SKILL.md · view on GitHub

Before installing

  • Ships executable scripts

Files (4)

  • SKILL.md
  • build_explain.py · scripts/
  • capture_postgresjs.ts · scripts/
  • summarize_explain.py · scripts/

The license isn't open source, so the instructions aren't shown here. Read SKILL.md on GitHub

More from jorgeavaldez/pi-config

Signals

Stars
0
Forks
2
Open issues
0
Last commit (this folder)
Oct 2, 2026 (27 days ago)

From GitHub (fetched Oct 24, 2026).

Details

License
License unknown
Repository
github.com/jorgeavaldez/pi-config
First seen
Oct 24, 2026
Last checked
Oct 24, 2026
Source
GitHubgithub-graphql

More from jorgeavaldez

Cite this page

query-optimization skill. Agent Mart. https://agentmart.dev/skills/jorgeavaldez-query-optimization (last updated 2026-10-24)