Installs into .claude/skills of the current project.
Are you the author of Database Query Helper?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/luokai0-database-query-helper)
---
name: skylv-sql-helper
slug: skylv-sql-helper
version: 1.0.0
description: "SQL query builder and optimizer. Generates queries, explains execution plans, and optimizes slow queries. Triggers: sql query, database query, sql optimization."
author: SKY-lv
license: MIT
tags: [automation, tools]
keywords: [automation, tools]
triggers: sql-helper
---
# SQL Helper
## Overview
Helps write, optimize, and debug SQL queries.
## When to Use
- User asks to "write a SQL query" or "optimize this query"
- Debugging slow database operations
## Pagination
SELECT * FROM users ORDER BY id LIMIT 20 OFFSET 40;
## Join with Aggregation
SELECT u.name, COUNT(o.id) as order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
GROUP BY u.id;
## Optimization Rules
- Add indexes on WHERE/JOIN columns
- Avoid SELECT * - specify columns
- Use EXPLAIN to analyze execution plan
- Optimize JOIN order (small table first)
- Add LIMIT for pagination
## Anti-Patterns to Avoid
- SELECT * in production code
- Nested subqueries (use JOINs or CTEs)
- OR in WHERE clause (use IN or UNION)
