Can it help with data visualization tasks?

Yes, as part of the Data Analytics skill category, it helps structure and optimize the underlying queries used to feed data into visualization and BI tools.

Is this skill specific to a particular database engine?

While it follows general industry best practices applicable to most SQL dialects (like PostgreSQL, MySQL, and SQL Server), it focuses on universal optimization patterns used in data analytics.

What does the SQL Query Optimizer skill do?

It provides automated assistance for improving the performance and efficiency of SQL queries by offering optimization patterns, refactoring guidance, and production-ready code generation.

Does it provide code validation?

Yes, the skill validates optimized outputs against common standards to ensure the generated SQL is both efficient and syntactically correct.

How do I activate the SQL Query Optimizer in Claude Code?

The skill activates automatically when you mention 'sql query optimizer' in your prompt or ask questions regarding SQL query patterns and database performance.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: jeremylongshore

byjeremylongshore

•

982

データベース管理

Optimizes complex SQL queries to enhance performance and efficiency across data analytics and business intelligence workloads.

概要

The SQL Query Optimizer skill provides automated assistance within Claude Code to refine database queries and resolve performance bottlenecks. By analyzing SQL patterns and applying industry-standard optimization techniques, it helps developers generate production-ready code that minimizes execution time and resource consumption. Whether you are dealing with large-scale data analytics or complex business intelligence reports, this skill ensures your database interactions are as efficient as possible.

主な機能

Step-by-step guidance for query refactoring and tuning
Automated identification of SQL performance bottlenecks
982 GitHub stars
Validation of query outputs against database standards
Expert advice on indexing strategies and execution plans
Generation of production-grade, optimized SQL code

ユースケース

Refactoring slow-running analytical queries for faster execution
Improving database performance for high-traffic BI dashboards
Optimizing join logic and subqueries in complex data pipelines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills sql-query-optimizer

For use in Claude.ai and ChatGPT

Download Skill

GitHub

概要