Database Query Helper

SQL query builder and optimizer. Generates queries, explains execution plans, and optimizes slow queries. Triggers: sql query, database query, sql optimization.

Security Scan

This instruction-only SQL helper is internally consistent with its stated purpose: it provides query examples and optimization rules and requests no installs, binaries, or credentials.

Purpose & Capability

Name/description match the content in SKILL.md: examples, optimization rules, and when-to-use guidance are appropriate for a SQL query helper. The SKILL.md contains no unrelated requirements (no cloud creds or extra tools). Note: registry slug (database-query-helper) differs from the SKILL.md slug (skylv-sql-helper), which is a minor metadata mismatch but not a functional concern.

Instruction Scope

Runtime instructions are confined to SQL examples and high-level optimization advice (EXPLAIN, indexes, JOIN strategies). The skill does not instruct the agent to read local files, environment variables, or transmit data to external endpoints.

Install Mechanism

No install spec and no code files — the skill is instruction-only, so nothing is written to disk and there is no install-time risk.

Credentials

The skill requests no environment variables or credentials. For actual query execution the agent would need database connection details from the user; asking for such secrets would be expected at use-time but are not declared here.

Persistence & Privilege

always is false and the skill is user-invocable; it does not request persistent or elevated platform privileges. Autonomous invocation is allowed by default but is not combined with any concerning privileges.

Assessment

This skill is coherent and low-risk as provided: it only contains guidance and examples and does not request credentials or install software. Before using it to run queries, avoid pasting production DB credentials into the chat — provide only minimal, scoped access if you must (or run queries yourself). Verify the publisher (source is unknown and the SKILL.md slug differs from the registry slug) and prefer skills with a known author/homepage if you plan to use them in production.

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)