Write secure, performant database queries with eager loading and parameterization.
npx skills add https://github.com/DevanB/lucidlog --skill backend-queries-devanb
Please help me install this Agent Skill. Skill: Backend Queries Source: https://github.com/DevanB/lucidlog/tree/main/.claude/skills/backend-queries Command: npx skills add https://github.com/DevanB/lucidlog --skill backend-queries-devanb
This Skill solves the problem of slow, insecure, or inefficient database queries that can degrade application performance and expose data vulnerabilities. It guides the creation of performant, secure, and optimized queries, ensuring your application interacts with the database efficiently and safely.
with('posts')) to prevent N+1 query issues and ensure the query is performant.Optimize the database query for fetching 'orders' and their associated 'items' by implementing eager loading and selecting only necessary columns.
High-intent search queries and answers about installing and using this skill.
N+1 problems occur when a query executes one initial query plus one additional query for each result. Use eager loading with query builders or ORM methods—in Laravel Eloquent, use `with('relation')` to fetch related data in a single query, eliminating the cascading queries and significantly improving performance.
Secure queries use parameterized queries or prepared statements, which separate SQL logic from user data. Query builders and ORM methods like Eloquent handle this automatically; avoid concatenating raw SQL with user input. Always use placeholders or the ORM's built-in binding methods to ensure safe handling.
Optimize queries by selecting only necessary columns instead of `SELECT *`, implementing proper database indexing on frequently queried fields, using eager loading to eliminate N+1 problems, and analyzing query execution plans. Combine these techniques to reduce query execution time and database load.
Yes, transactions wrap related operations together, ensuring all succeed or all fail as a single unit. This maintains data integrity and prevents partial updates. Use transaction management in your query layer when multiple queries must succeed together or roll back together on failure.
Filter using parameterized WHERE clauses and paginate using LIMIT and OFFSET in query builders. Combine filtering, sorting, and pagination in a single query to retrieve only the data you need, reducing database load and application memory usage significantly.
Query caching stores frequently accessed results in memory, avoiding repeated database calls. Implement caching at the query layer using your framework's caching methods, and invalidate cached data when underlying records change to keep results fresh and reduce database strain.
0r0looGuide database schema design, normalization, relationships, and optimization strategies.
Tnemo65Analyze slow queries and execution plans to optimize database performance.
rongaredeApply PostgreSQL patterns for query tuning, indexing, and Row Level Security.
EIS-ITSGenerate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.