sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when…
Find an Agent Skill for your task. Read the guide and copy the install command.
Updated 10-23 00:13
16,814 results
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when…
PostgreSQL database design best practices, naming conventions, indexing strategies, and performance optimization for .NET applications using Npgsql and EF Core.
Manage ServiceNow dictionary (sys_dictionary), table/field creation, choice lists, dictionary overrides, and sys_data_policy2 rules that enforce…
Build ServiceNow Performance Analytics — pa_indicators (count/sum/avg/percentage), pa_breakdowns, pa_thresholds with severity colors, pa_widgets, and…
Gravity and magnetic data processing and forward modelling using Fatiando a Terra. Use when the agent needs to: (1) Compute gravity forward models (point…
Geochemistry data analysis and visualization for igneous, metamorphic, and sedimentary rocks. Use when the agent needs to: (1) Create ternary diagrams…
How to benchmark and analyze memory usage in Turso using the memory-benchmark crate and dhat heap profiler. Use this skill whenever the user mentions memory…
Acquire, import, and analyze WeChat or QQ chat histories, including installing supported exporters, guiding required login or contact selection, converting…
Build institutional-grade comparable company analyses with operating metrics, valuation multiples, and statistical benchmarking in Excel/spreadsheet…
Database performance audit — detects N+1 queries, missing indexes, join opportunities, slow queries, EXPLAIN analysis, and per-endpoint DB call counts. Use…
Performance profiling — measures code execution time, DB call time, and identifies bottlenecks at both the application and database layer. Use when asked to…
Create interactive in-app charts (bar, line, pie). For a saved PNG or PDF, use visual-design instead.
Use when working with OpenSearch vector search edition via the Python SDK (ha3engine) to push documents and run HA/SQL searches. Ideal for RAG and vector…
Microsoft SQL Server T-SQL procedural language. Covers stored procedures, functions, triggers, error handling, and SQL Server-specific features. Use for SQL…
Use when selecting STATISTICAL methods (hypothesis tests, regression), performing power analysis, guiding uncertainty quantification (Bayesian/frequentist), or…
Use when structuring Flutter application layers across data, domain, and presentation using Clean Architecture and BLoC.
Calculate distances between geographic coordinates, find nearby points, and compute travel distances. Use for logistics, delivery routing, or location analysis.
Explain ML model predictions using SHAP values, feature importance, and decision paths with visualizations.
Standardize and format phone numbers with international support, validation, and multiple output formats.
Perform statistical hypothesis testing, regression analysis, ANOVA, and t-tests with plain-English interpretations and visualizations.
Use when asked to calculate statistical power, determine sample size, or plan experiments for hypothesis testing.
Extract topics from text collections using LDA (Latent Dirichlet Allocation) with keyword extraction and topic visualization.
Advanced data analysis, pattern detection, and insight generation from structured and unstructured datasets
Generate D2 database diagrams from Entity Framework Core models. USE FOR: EF Core database diagram, Entity Framework Core ERD, DbContext diagram, C# entity…