All Skills Search Tools

|

Loading...

AI Agent Skills Directory with categorization, English/Chinese translation, and script security checks.

Sitemap

Home
All Skills
Search
Tools

About

About Us
Disclaimer
Copyright

Help

FAQ
Privacy
Terms

Contact Us:osulivan147@qq.com

© 2026 Skill4Agent. All rights reserved.

Home/All Skills/Data Processing/query-optimization

query-optimization

Original：🇺🇸 English

Translated

1 scriptsChecked / no sensitive code detected

SQL query optimization and performance tuning

1installs

Sourcepluginagentmarketplace/custom-plugin-sql

Added on2026-02-07

NPX Install

npx skill4agent add pluginagentmarketplace/custom-plugin-sql query-optimization

Tags

Translated version includes tags in frontmatter

sql-optimization query-performance indexing-strategy database-tuning query-analysis

SKILL.md Content

View Translation Comparison →

Query Optimization Skill

Overview

Optimize SQL queries for maximum performance across different database systems.

Topics Covered

Query Analysis

EXPLAIN plans
Execution statistics
Cost-based optimization
Query profiling
Wait event analysis

Indexing Strategy

B-tree indexes
Covering indexes
Partial indexes
Index selection
Index maintenance

Query Patterns

JOIN optimization
Subquery alternatives
Aggregate optimization
Pagination patterns
Bulk operations

Database Specific

PostgreSQL optimization
MySQL tuning
SQL Server hints
Oracle optimization
Cloud DB optimization

Prerequisites

SQL fundamentals
Database internals basics

Learning Outcomes

Analyze query plans
Create effective indexes
Rewrite slow queries
Tune database performance

Download

Download TranslatedIncludes original Skill.md

(5.7 KB)Download Original(4.9 KB)

Related Skills

scientific-visualization

Meta-skill for publication-ready figures. Use when creating journal submission figures requiring multi-panel layouts, significance annotations, error bars, colorblind-safe palettes, and specific journal formatting (Nature, Science, Cell). Orchestrates matplotlib/seaborn/plotly with publication styles. For quick exploration use seaborn or plotly directly.

analytics-tracking

When the user wants to set up, improve, or audit analytics tracking and measurement. Also use when the user mentions "set up tracking," "GA4," "Google Analytics," "conversion tracking," "event tracking," "UTM parameters," "tag manager," "GTM," "analytics implementation," or "tracking plan." For A/B test measurement, see ab-test-setup.

firecrawl-agent

AI-powered autonomous data extraction that navigates complex sites and returns structured JSON. Use this skill when the user wants structured data from websites, needs to extract pricing tiers, product listings, directory entries, or any data as JSON with a schema. Triggers on "extract structured data", "get all the products", "pull pricing info", "extract as JSON", or when the user provides a JSON schema for website data. More powerful than simple scraping for multi-page structured extraction.

snowflake-semanticview

Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow). Use when asked to build or troubleshoot semantic views/semantic layer definitions with CREATE/ALTER SEMANTIC VIEW, to validate semantic-view DDL against Snowflake via CLI, or to guide Snowflake CLI installation and connection setup.