database-query-helper

by sky-lv

Install this Skill

curl -fsSL -o database-query-helper.zip https://skill.seembox.com/api/v1/skills/database-query-helper/download && unzip database-query-helper.zip

Download database-query-helper.zip

SKILL.md About

---
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)

_meta.json Metadata

{
  "ownerId": "kn7c4d4r1tezx1t4dxm5mh62rn84f02r",
  "publishedAt": 1776924614440,
  "slug": "database-query-helper",
  "version": "1.0.0"
}