Skip to content
TrustedSkillsbeta
Back to all skills

Sql Optimization Patterns

Listed
ravinani02·vlatest·database

Helps with optimization, patterns as part of working with databases and data persistence workflows.

Repository

Install on your platform

This skill no longer installs under the name sql-optimization-patterns. ravinani02/opencode-agent-skills is deleted or private, so it cannot be installed from.

We check each listing against its upstream repository with the rules the skills CLI uses, last on 2026-10-22. We don't show a command we know will fail.

Repository install instructions

What we know about this skill

Publisher

ravinani02

Taken from the source listing. We haven't verified who controls this account.

Install target

Live repository

Not pinned. Installing fetches whatever the repository holds at the time you run the command.

Nobody has reviewed this code. TrustedSkills indexes and links skills; it does not audit, run or scan them. A skill runs with whatever access you give your agent — read the source before you install it.

Automated safety checks

scanned

We could not read this skill's source, so none of the checks below were run.

Not scanned. repository not found or private Source recorded as ravinani02/opencode-agent-skills.
This is a static scan, not a review. It reads the skill's files; it does not run them, and it cannot tell you whether the skill is any good or whether the code does what its description says. A skill runs with whatever access you give your agent.
What each check looks for →

About this skill

What it does

This skill provides SQL query optimization patterns to improve database performance. It helps identify and suggest changes to inefficient queries, focusing on common anti-patterns and best practices for faster execution. The skill aims to reduce query latency and overall database load by applying proven optimization techniques.

When to use it

  • Slow Query Analysis: When a specific SQL query is identified as taking an unexpectedly long time to execute.
  • Performance Bottlenecks: To address general performance slowdowns within a database application.
  • Query Refactoring: During code reviews or when refactoring existing SQL queries for improved efficiency.
  • Database Tuning: As part of a broader strategy for optimizing the overall health and responsiveness of a database system.

Key capabilities

  • Identifies common SQL anti-patterns
  • Suggests optimization techniques
  • Focuses on query execution speed
  • Applies best practices for database performance

Example prompts

  • "Analyze this SQL query: SELECT * FROM orders WHERE customer_id = 123; and suggest optimizations."
  • "What are some common reasons why a JOIN operation might be slow?"
  • "I'm seeing high latency on my product listing query. Can you help me optimize it?"

Tips & gotchas

The skill is most effective when provided with the full SQL query text. It assumes a basic understanding of SQL concepts and may require some manual implementation of suggested changes.