standards-queries

What problem does it solve?

This Skill helps developers enforce secure, efficient database access patterns by promoting parameterized queries, eager loading where appropriate, and targeted indexing.

Core Features & Use Cases

• Parameterized Queries: Enforce prepared statements or ORM filters to prevent SQL injection.
• N+1 Prevention & Eager Loading: Guidance to fetch related data efficiently via joins or optimized loading strategies.
• Selective Columns & Indexing: Recommend retrieving only necessary columns and applying indexes on common filters.
• Transactional Integrity: Encourage wrapping related writes in transactions to maintain consistency.
• Performance Validation: Use explain plans and query logging to verify improvements.

Quick Start

• Refactor a sample vulnerable query to a parameterized version and describe how to test it with a simple dataset.
• Add an index on a frequently filtered column and verify performance improvements with EXPLAIN plans.