sql-query-optimizer

Name: sql-query-optimizer
Author: jeremylongshore

github.com/jeremylongshoreData & databases2.9k64 installsUpdated today

About sql-query-optimizer

sql-query-optimizer is a data analytics skill for SQL query optimization tasks. It provides step-by-step guidance, generates code and configurations, and validates outputs against common standards.

Key features

01Step-by-step task guidance
02Best-practice patterns
03Code and configuration generation
04Output validation

Use cases

01Getting guidance on SQL query optimization
02Generating configurations for data analytics

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer

After installing, type/sql-query-optimizerin Claude Code to confirm it loaded.

Details

From the project README

Sql Query Optimizer

Overview

This skill provides automated assistance for sql query optimizer tasks within the Data Analytics domain.

When to Use

This skill activates automatically when you:

Mention "sql query optimizer" in your request
Ask about sql query optimizer patterns or best practices
Need help with data analytics skills covering sql queries, data visualization, statistical analysis, and business intelligence.

Instructions

Provides step-by-step guidance for sql query optimizer
Follows industry best practices and patterns
Generates production-ready code and configurations
Validates outputs against common standards

Examples

Example: Basic Usage Request: "Help me with sql query optimizer" Result: Provides step-by-step guidance and generates appropriate configurations

Prerequisites

Relevant development environment configured
Access to necessary tools and services
Basic understanding of data analytics concepts

Output

Generated configurations and code
Best practice recommendations
Validation results

Error Handling

Error	Cause	Solution
Configuration invalid	Missing required fields	Check documentation for required parameters
Tool not found	Dependency not installed	Install required tools per prerequisites
Permission denied	Insufficient access	Verify credentials and permissions

Resources

Official documentation for related tools
Best practices guides
Community examples and tutorials

Related Skills

Part of the Data Analytics skill category. Tags: sql, analytics, visualization, statistics, bi

Comments

Markdown supported

Details

Author: jeremylongshore
Repository: jeremylongshore/tons-of-skills-marketplace
Category: Data & databases
Installs: 64
GitHub stars: 2,885

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.7k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

834.8k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

833.3k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

714.8k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).