sql-perf

Official

Optimize SQL queries and indexing strategies.

AuthorObjective-Arts
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses slow SQL query performance by providing guidance on effective indexing, query optimization, and understanding how databases execute SQL statements.

Core Features & Use Cases

  • Indexing Strategies: Learn the rules for creating effective composite and single-column indexes.
  • Query Optimization: Understand how to write queries that leverage indexes and avoid full table scans.
  • EXPLAIN Analysis: Interpret query execution plans to identify performance bottlenecks.
  • Use Case: A developer is experiencing slow response times on a critical database query. They can use this Skill to understand why the query is slow and how to add or modify indexes to improve its performance.

Quick Start

Use the sql-perf skill to understand how to optimize a query with a WHERE clause on multiple columns.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sql-perf
Download link: https://github.com/Objective-Arts/lens-dist/archive/main.zip#sql-perf

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.