skilld
All skills
jamesrochabrun avatar

/query-expert

@c877664
by James Rochabrunjamesrochabrun/skills212 stars
26

Master SQL and database queries across multiple systems. Generate optimized queries, analyze performance, design indexes, and troubleshoot slow queries for PostgreSQL, MySQL, MongoDB, and more.

Ask your Agent

Use this Skill: https://skilld.dev/gh/jamesrochabrun/skills/query-expert

This session only. Nothing lands on disk.

referencesoptimization.md

≈64 tokens on demand. Your agent reads this file only when SKILL.md points to it.

Query Optimization - See SKILL.md for complete optimization guide including:

  • Avoid SELECT *
  • Use indexes effectively
  • Optimize JOINs
  • EXISTS vs IN
  • Function usage on indexed columns
  • LIMIT and pagination
  • Batch operations
  • Common anti-patterns

Source: SKILL.md on GitHub

Third-party checks

2 warnings16d5 checks · Risk MEDIUM
  • Gen Agent Trust Hub16d

    The skill is a database query optimization toolkit. It includes a utility script for generating queries that is vulnerable to shell command injection due to the unsafe use of the 'eval' command on user-provided input.

  • Socket16d

    1 alert: gptSecurity

  • Snyk16d

    Risk: LOW · No issues

  • Runlayer7mo

    8 files scanned · No issues

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Provenance

Signed by skilld at c877664. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 months ago.

Dormantupdated 11 months ago

README badge

README badge for jamesrochabrun/skills/query-expert