ln-812-query-optimizer

Fix database query inefficiencies from audit findings with verified code changes.

Updated Mar 14, 2026

Search Tags:#testing #performance #database #query-optimization #n+1 #redundant-fetch

Ready to run

npx skills add https://github.com/0xtaoist/taogate --skill ln-812-query-optimizer

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: ln-812-query-optimizer
Source: https://github.com/0xtaoist/taogate/tree/main/ln-812-query-optimizer
Command: npx skills add https://github.com/0xtaoist/taogate --skill ln-812-query-optimizer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill fixes N+1 queries, redundant fetches, and over-fetching by applying keep/discard verification to ensure correctness while improving performance.

Core Features & Use Cases

Audit-driven fixes: identify and prioritize query inefficiencies from audit findings.
Deterministic changes: surgical code edits with verification via tests.
Reporting: generates a clear remediation report detailing before/after results and coverage.

Quick Start

Run ln-812-query-optimizer to automatically identify and fix inefficient queries in your codebase using the built-in auditor and tester.

Frequently Asked Questions about ln-812-query-optimizer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I fix N+1 queries and redundant fetches in my backend codebase?▼

To fix N+1 queries and redundant fetches, an audit-driven optimizer identifies inefficiencies in hot paths and applies surgical code edits to remove them. It verifies changes via tests to ensure correctness while improving performance.

What is over-fetching in database queries and how do I resolve it?▼

Over-fetching occurs when database queries retrieve more data than needed. You resolve it by applying surgical code modifications to eliminate redundant fetches, using a test framework to validate that the optimized queries maintain correctness.

Do I need a test framework to optimize database queries?▼

Yes, a test framework is required to optimize database queries safely. It validates the surgical code edits by running keep/discard verification, ensuring the query optimization changes maintain correctness and do not break existing functionality.

What's the best way to automate query optimization for backend services?▼

The best way to automate query optimization is using an audit-driven workflow that takes audit findings as input, applies deterministic code edits to hot paths, and generates a remediation report detailing before/after results and test coverage.

Can query optimization changes be verified before applying to production?▼

Yes, query optimization changes can be verified before production by running them against a test framework. This keep/discard verification validates that the surgical fixes for N+1 patterns and over-fetching produce correct results.