Performance & cost
7,061 rows, by stacks then stars
853 of these skill files have been read, by 797 distinct authors, and what they tell an agent counted. What Performance & cost authors agree on, and what they forbid
Rapid spectrum retrieval optimization
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/rapid-spectrum-retrieval-optimization Skill
16★ repoUse when you have a large collection of mass spectrometry spectra (m/z and intensity pairs) and need to rapidly retrieve similar or candidate spectra from the archive in response to queries.
Raw data throughput benchmarking
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/raw-data-throughput-benchmarking Skill
16★ repoUse when when you have a raw mass spectrometry file (e.g., Thermo Orbitrap .raw) and need to establish the measured throughput of a spectral reading function (e.
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/rendering-speed-profiling Skill
16★ repoUse when when you have implemented the same visualization (e.g., chromatogram, spectrum, peakmap, mobilogram) across multiple plotting backends in pyOpenMS-viz and need to determine which backend minimizes rendering latency.
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/runtime-performance-profiling Skill
16★ repoUse when when you need to empirically validate that one mass spectrometry data processing library achieves higher throughput than competing alternatives. Specifically: you have multiple candidate libraries (e.
S4 class object memory profiling
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/s4-class-object-memory-profiling Skill
16★ repoUse when when designing or optimizing S4-based data backends (such as MsBackend subclasses) and you need to decide whether to pre-populate all slots with complete data structures or defer initialization until data access.
Search mode configuration optimization
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/search-mode-configuration-optimization Skill
16★ repoUse when when you have a calibrated FT-ICR mass spectrum (e.g., ESI-NEG mode) and need to decide between rapid single-assignment (first_hit=True) and exhaustive multi-assignment (first_hit=False) modes.
Search performance benchmarking
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/search-performance-benchmarking Skill
16★ repoUse when when you have two or more implementations of a spectral search tool (e.g., MASST vs. MASST+) and need to quantify whether claimed performance improvements (e.g., '100-fold speedup') are reproducible.
Spectral search performance evaluation
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/spectral-search-performance-evaluation Skill
16★ repoUse when when you have implemented or obtained a spectral library search tool (e.
Spectrum processing throughput benchmarking
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/spectrum-processing-throughput-benchmarking Skill
16★ repoUse when when selecting a spectrum processing library for high-throughput proteomics or metabolomics workflows, or when optimizing an existing pipeline for computational efficiency. Apply this skill when you have access to representative raw MS data (e.
Sphinx gallery execution and performance profiling
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/sphinx-gallery-execution-and-performance-profiling Skill
16★ repoUse when you have a Sphinx-based documentation project with multiple gallery scripts (e.
Visualization comparative performance metrics
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-generic/skills/visualization-comparative-performance-metrics Skill
16★ repoUse when you have execution-time data for the same set of plotting operations (e.g., chromatogram, spectrum, peakmap rendering) across two or more backend implementations (e.
Cell type protein profiling integration
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-imaging/skills/cell-type-protein-profiling-integration Skill
16★ repoUse when you have co-registered IMC (protein imaging mass cytometry) and SIMS (secondary ion mass spectrometry for metabolites) data from the same tissue regions, cell segmentation masks, and need to assign cell types based on protein expression patterns, then overlay those assignments onto.
Ion image embedding optimization
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-imaging/skills/ion-image-embedding-optimization Skill
16★ repoUse when you have 512-dimensional representation vectors output from ResNet18 encoders processing paired augmented ion images, and you need to prevent trivial solutions (representation collapse) during contrastive learning—specifically when optimizing for maximized similarity between augmentations.
Model validation and performance evaluation
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-imaging/skills/model-validation-and-performance-evaluation Skill
16★ repoUse when after training a MEISTER deep learning reconstruction model on mass spectrometry data, you must validate performance on independent test sets before applying the model to new experimental or clinical samples.
Morphological alignment optimization
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-imaging/skills/morphological-alignment-optimization Skill
16★ repoUse when you have two or more spatial omics datasets (e.
Msi data processing speed measurement
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-imaging/skills/msi-data-processing-speed-measurement Skill
16★ repoUse when when you need to validate that MSI software (e.g., LipidQMap) achieves documented processing speeds on your target hardware, or when you need to establish a performance baseline before deploying the software for high-throughput imaging studies.
Neural network hyperparameter optimization
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-imaging/skills/neural-network-hyperparameter-optimization Skill
16★ repoUse when when you have preprocessed joint ST/SM AnnData objects (output from joint_adata_sm_st and normalize_total_joint_adata_sm_st) and need to fit a ConditionalVAESTSM model to unify spatial transcriptomics and spatial metabolomics data to a common resolution.
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-imaging/skills/per-root-metabolite-profiling Skill
16★ repoUse when when you have deposited mass spectrometry imaging datasets for plant roots in CDF format paired with pre-computed Matlab workspaces, and you need to reproduce per-root linear-axis metabolite profiling outputs to validate reported genotype-level results (e.
Root developmental tissue profiling
HolobiomicsLab/asb-skill-collections/packs/metabolomics/ms-imaging/skills/root-developmental-tissue-profiling Skill
16★ repoUse when you have CDF-format mass spectrometry imaging files from plant roots with accompanying MATLAB workspace files (.mat), and your research goal is to reproduce linear-axis intensity profiles, feature distributions, and spatial metrics reported in a prior publication (e.g., Sama et al. 2025).
Block layout analysis for io optimization
HolobiomicsLab/asb-skill-collections/packs/metabolomics/nmr/skills/block-layout-analysis-for-io-optimization Skill
16★ repoUse when when preparing NMR datasets for processing in NMRFx and the Dataset.createDataFile() method must choose among competing storage backends.
HolobiomicsLab/asb-skill-collections/packs/metabolomics/nmr/skills/cohort-performance-reporting Skill
16★ repoUse when you have NMR metabolite measurements from peripheral blood samples (plasma/serum) paired with processing delay metadata (pre-centrifugation and post-centrifugation times) and need to benchmark metabolic parameter stability across delay windows.
Cohort stratified metabolic performance analysis
HolobiomicsLab/asb-skill-collections/packs/metabolomics/nmr/skills/cohort-stratified-metabolic-performance-analysis Skill
16★ repoUse when when you have uploaded a pre-analytical data table containing sample metadata, processing delay annotations (pre- and post-centrifugation times), and paired NMR metabolomic measurements for a plasma or serum cohort, and you need to determine how processing delays impact metabolite.
Performance degradation quantification and analysis
HolobiomicsLab/asb-skill-collections/packs/metabolomics/nmr/skills/performance-degradation-quantification-and-analysis Skill
16★ repoUse when you have a pretrained model with documented performance on a bounded input domain (e.g., molecules ≤19 heavy atoms, sequences <1000 bp) and you need to establish whether and how much accuracy drops on held-out test cases outside that domain boundary.
Weighted loss function optimization
HolobiomicsLab/asb-skill-collections/packs/metabolomics/nmr/skills/weighted-loss-function-optimization Skill
16★ repoUse when when training a dual-encoder architecture (bi-encoder + cross-encoder) on NMR spectral data where independent encoding and joint pair processing produce competing or imbalanced gradient signals.
martinholovsky/SOTA-skills/skills/sota-async-concurrency Skill
15★ repoState-of-the-art rules for writing and auditing asynchronous and concurrent code across runtimes (Python asyncio, JS/Node, Go, Rust, JVM). Use when building anything with async/await, threads, processes, event loops, task groups, channels, or queues — and when auditing existing code for race conditions, deadlocks, leaked tasks, blocked event loops, missing cancellation, or backpressure failures. Not for latency/throughput profiling and optimization — use sota-performance. Trigger keywords: async, await, concurrency, parallelism, threads, race condition, deadlock, event loop, channels, queues, semaphore, mutex, cancellation, timeout, backpressure, task group, goroutine, tokio, asyncio.
martinholovsky/SOTA-skills/skills/sota-performance Skill
15★ repoState-of-the-art performance engineering for building fast systems and auditing existing code for bottlenecks. Use when the task involves performance, optimization, latency, profiling, slow code, memory usage, caching, or throughput — designing latency budgets, fixing N+1 and accidental-quadratic patterns, tuning allocation/GC pressure, network and I/O efficiency, cache architecture, Core Web Vitals, or setting up benchmarks and regression gates. Not for concurrency correctness (races, deadlocks, cancellation) — use sota-async-concurrency. Trigger keywords: performance, optimization, latency, profiling, slow, memory usage, caching, throughput, bottleneck, p99, flamegraph, Core Web Vitals.
justvinhhere/bigquery-expert/skills/bigquery-optimization Skill
15★ repoUse when writing, reviewing, or optimizing BigQuery SQL, asking about BigQuery best practices, working with .sql files targeting BigQuery, or troubleshooting slow/expensive BigQuery queries. Symptoms: high slot consumption, full table scans, expensive joins, slow queries, high bytes billed.
a-tokyo/agent-skills/benchmarks/create-skill-autoresearch/companions/autoresearch Skill
15★ repoAutonomous iterative experimentation loop for any programming task. Guides the user through defining goals, measurable metrics, and scope constraints, then runs an autonomous loop of code changes, testing, measuring, and keeping/discarding results. Inspired by Karpathy's autoresearch. USE FOR: autonomous improvement, iterative optimization, experiment loop, auto research, performance tuning, automated experimentation, hill climbing, try things automatically, optimize code, run experiments, autonomous coding loop. DO NOT USE FOR: one-shot tasks, simple bug fixes, code review, or tasks without a measurable metric.
The same file is in 1 other repository
a-tokyo/agent-skills/skills/production-grade Skill
15★ repoPrinciple-engineering posture for production-grade code: reads the repo first, plans before code, matches conventions, pulls latest docs over training recall, and ships the simplest correct change that holds the bar — proper algorithms and data structures, idempotent writes, schema+queries+indexes as one artefact, typed errors, tests in the same diff. Substrate-agnostic; defers to peer skills on their lanes. Use for non-trivial planning, design, implementation, review, or refactoring; RCA and debugging; performance and optimization work; changes touching a database schema, security, infrastructure, or a public API; hardening inherited, vibe-coded, or LLM-generated code (dependency/CVE and migration audits); and over-engineering cleanup ("simplest solution," "YAGNI," "what can we delete").
The same file is in 2 other repositories
Teycir/SkillsGuard/testskills/realworld/skills/safe-performance-18 Skill
no license15★ repoStatic security scanner for AI agent skill packages. Detects malicious SKILL.md files and bundled scripts before they run.
Teycir/SkillsGuard/testskills/realworld/skills/safe-performance-30 Skill
no license15★ repoStatic security scanner for AI agent skill packages. Detects malicious SKILL.md files and bundled scripts before they run.
Teycir/SkillsGuard/testskills/realworld/skills/safe-performance-42 Skill
no license15★ repoStatic security scanner for AI agent skill packages. Detects malicious SKILL.md files and bundled scripts before they run.
Teycir/SkillsGuard/testskills/realworld/skills/safe-performance-54 Skill
no license15★ repoStatic security scanner for AI agent skill packages. Detects malicious SKILL.md files and bundled scripts before they run.
Teycir/SkillsGuard/testskills/realworld/skills/safe-performance-6 Skill
no license15★ repoStatic security scanner for AI agent skill packages. Detects malicious SKILL.md files and bundled scripts before they run.
viktorbezdek/skillstack/cloud-finops/skills/cloud-finops Skill
15★ repoExpert FinOps guidance covering cloud, AI, SaaS, and adjacent technology spend. Includes AI cost management, GenAI capacity planning, AI-powered FinOps automation, Anthropic billing, AWS (EC2, Bedrock, Savings Plans, CUR, commitment strategy), Azure (reservations, Savings Plans, AHB, OpenAI PTUs, portfolio liquidity), GCP (Vertex AI, Compute Engine, BigQuery), Kubernetes and container FinOps (OpenCost, Kubecost), serverless FinOps (Lambda, Functions, Cloud Run), data platforms (Kafka/MSK, Elasticsearch/OpenSearch, Redis/Valkey), multi-cloud normalization (FOCUS specification), tagging governance, SaaS management (SAM, licence optimisation, SMPs, shadow IT), AI coding tools (Cursor, Claude Code, Copilot, Windsurf, Codex), ITAM, Databricks, Snowflake, OCI, and GreenOps. Use for any query about technology cost, commitment portfolio management, rightsizing, cost allocation, SaaS sprawl, AI dev tool spend, container cost attribution, serverless optimization, multi-cloud strategy, or connecting spend to business value. NOT for general cloud architecture decisions, application performance tuning, or security/compliance reviews — use the relevant architecture, performance, or security skills for those. Built by OptimNow and Viktor Bezdek.
viktorbezdek/skillstack/cloud-infrastructure/skills/cloud-infrastructure Skill
15★ repoCloud infrastructure design and infrastructure-as-code (IaC) authoring. Use for Terraform module authoring, AWS CDK constructs, cloud architecture design (VPCs, load balancers, managed services, serverless), multi-region and disaster-recovery patterns, cost-optimisation analysis, and IaC code review. Trigger phrases: "write Terraform for", "design the AWS architecture", "set up a VPC", "convert this to CDK", "optimise our cloud costs". NOT for application-layer code — this skill models infrastructure, not the code running on it. NOT for Kubernetes application manifests (Deployments, Services, Ingress) — those belong in a k8s-specific skill. NOT for CI/CD pipeline configuration — that is a deployment concern separate from infrastructure provisioning.
viktorbezdek/skillstack/context-degradation/skills/context-degradation Skill
15★ repoDiagnosing context FAILURES — lost-in-middle, poisoning, distraction, confusion, and clash patterns with model-agnostic measurement workflows. Use when the user asks to "diagnose context problems", "fix lost-in-middle issues", "debug agent failures", "understand context poisoning", or mentions context degradation, context clash, or agent performance degradation. NOT for learning context basics or theory (use context-fundamentals), NOT for compressing or summarizing context (use context-compression), NOT for KV-cache optimization or partitioning (use context-optimization), NOT for building isolated multi-agent architectures (use multi-agent-patterns).
viktorbezdek/skillstack/context-fundamentals/skills/context-fundamentals Skill
15★ repoFoundational theory of context engineering — what context IS, how attention works, progressive disclosure principles, and context budgeting basics. Use when the user asks to "understand context", "explain context windows", "learn context engineering", or discusses context components, attention mechanics, or context budgets. NOT for fixing broken context or diagnosing failures (use context-degradation), NOT for compressing or summarizing context (use context-compression), NOT for KV-cache or partitioning performance optimization (use context-optimization), NOT for file-based context patterns or scratch pads (use filesystem-context).
viktorbezdek/skillstack/context-optimization/skills/context-optimization Skill
15★ repoEXTENDING effective context capacity — KV-cache optimization, observation masking, context partitioning, and retrieval strategies. Use when the user asks to "optimize context", "implement KV-cache", "partition context", "mask observations", or mentions extending context capacity or cache-friendly prompt design. NOT for reducing or compressing content via summarization (use context-compression), NOT for diagnosing context failures or degradation patterns (use context-degradation), NOT for file-based context patterns or scratch pads (use filesystem-context), NOT for learning context basics (use context-fundamentals).
viktorbezdek/skillstack/database-design/skills/database-design Skill
15★ repoDatabase design and schema engineering for relational databases. Use for SQL schema design, ORM model authoring, migration strategies (Alembic, Liquibase, Flyway, Drizzle), query optimisation, indexing decisions, normalisation vs denormalisation trade-offs, and data-integrity constraints. Trigger phrases: "design this schema", "write a migration", "optimise this query", "model these entities", "add an index". NOT for NoSQL/document stores — use a dedicated NoSQL skill for those. NOT for ETL pipelines or data warehousing at scale — those involve different trade-offs. NOT for ORM configuration (framework setup) — this skill is about DATA SHAPE, not connection pooling or ORM bootstrap.
viktorbezdek/skillstack/skillstack-workflows/skills/llm-cost-optimization Skill
15★ repoFunnel-with-gate workflow for reducing LLM costs without degrading quality. Starts with diagnosing the cost surface using cloud-finops (specifically the finops-for-ai and finops-anthropic references), then applies context-optimization to reduce context per call, context-compression to compress what can't be reduced, prompt-engineering for shorter prompts and better model selection, and uses agent-evaluation as a mandatory gate — if any optimization degrades quality, roll it back. Finishes with prioritization of remaining opportunities and risk-management guardrails for future auto-scaling. Use when LLM costs are growing faster than usage, when leadership is asking why the bill doubled, when unit economics are turning negative, or when a new feature is about to ship and cost containment is part of the launch plan. NOT for cost reductions that don't involve LLMs — use cloud-finops directly.
adryanmoldokkr32-pixel/anthropics-skills/skills/skill-creator Skill
no license15★ repoCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.
The same file is in 66 other repositories
hellotern/Sextant/skills/modify-feature Skill
15★ repoYou MUST use this skill before changing, enhancing, or refactoring any existing functionality. Use when the code already exists and you are altering its behavior, performance, or structure — not fixing a bug. Stronger signals: "modify", "refactor", "optimize", "improve", "change how X works", "enhance", "update the logic". Use sextant:add-feature instead when the thing being built does not yet exist. Use sextant:fix-bug instead when the existing behavior is broken and needs to be restored.
saifoelloh/golang-best-practices-skill/query-performance Skill
15★ repoGORM + PostgreSQL query performance review. Use when optimizing slow queries, designing indexes, analyzing N+1 patterns, or configuring connection pools. Trigger on "slow", "optimize", "index", "EXPLAIN", "N+1", or performance degradation.
cofin/flow/plugins/flow/skills/performance-analyst Skill
15★ repoUse when reviewing hot paths, slow code, database queries, N+1 risks, memory usage, loops, I/O, caching strategy, concurrency, latency-sensitive paths, or resource efficiency.
The same file is in 1 other repository
cofin/flow/skills/performance-analyst Skill
15★ repoUse when reviewing hot paths, slow code, database queries, N+1 risks, memory usage, loops, I/O, caching strategy, concurrency, latency-sensitive paths, or resource efficiency.
The same file is in 1 other repository
EntityProcess/agentv/plugins/agentv-dev/skills/agentv-dev Skill
15★ repoAgentV CLI skills for evaluating, optimizing, and governing AI agents. Triggers: run evals, benchmark agents, write evals, review evals, analyze traces, optimize prompts, governance linting. Covers: eval running, eval writing, eval review, trace analysis, description optimization, autoresearch, and governance compliance.
EntityProcess/agentv/skills-data/agentv-bench Skill
15★ repoRun AgentV evaluations and optimize agents through eval-driven iteration. Triggers: run evals, benchmark agents, optimize prompts/skills against evals, compare agent outputs across providers, analyze eval results, offline evaluation of recorded sessions, run autoresearch, optimize unattended, run overnight optimization loop. Not for: writing/editing eval YAML without running (use agentv-eval-writer), analyzing existing traces/JSONL without re-running (use agentv-trace-analyst).
EntityProcess/agentv/skills-data/agentv-trace-analyst Skill
15★ repoAnalyze AgentV evaluation traces and result JSONL files using `agentv inspect` and `agentv results compare` CLI commands. Use when asked to inspect AgentV eval results, find regressions between AgentV evaluation runs, identify failure patterns in AgentV trace data, analyze tool trajectories, or compute cost/latency/score statistics from AgentV result files. Do NOT use for benchmarking skill trigger accuracy, analyzing skill-creator eval performance, or measuring skill description quality — those tasks belong to the skill-creator skill.
piyushverma0/android-agent-skills/skills/performance Skill
15★ repoAndroid app performance for AI agents. Use this skill whenever optimizing app performance, reducing recomposition, Compose stability, @Stable, @Immutable, skippable composables, baseline profiles, R8 optimization, lazy loading, image memory, Coil caching, RecyclerView vs LazyList performance, memory leaks, LeakCanary, ANR prevention, background work, Trace API, systrace, profiling, overdraw, rendering performance, startup time optimization, or any Android performance concern. Apply whenever a screen feels slow or laggy.
Aiops platform optimization agent
ivanshamaev/de-agent-skills/group_skills/infra_dataops_group_skills/aiops_platform_optimization_agent Skill
no license15★ repoAIOps continuous platform optimization agent — autonomous optimization loop (observe→analyze→recommend→apply), Kubernetes resource rightsizing (VPA recommendation reader + apply), Kafka consumer lag auto-scale, Spark job configuration tuning from history, idle resource detection (unused deployments/PVCs/topics), compaction and VACUUM scheduling, auto-ANALYZE stale statistics, cost savings attribution, optimization audit trail, human approval gate for high-risk changes
Dataops airflow cost optimizer
ivanshamaev/de-agent-skills/group_skills/infra_dataops_group_skills/dataops_airflow_cost_optimizer Skill
no license15★ repoAirflow cost optimization — KubernetesPodOperator right-sizing (request vs actual CPU/memory), spot node tolerations for batch tasks, task consolidation (reduce pod-per-task overhead), pool-based concurrency control, idle worker cleanup, log retention policy (S3 lifecycle), metadata DB right-sizing, CeleryExecutor worker autoscaling (KEDA Kafka/queue depth), DAG run frequency analysis (oversceduled DAGs), cloud cost attribution per DAG
Infra grafana dashboard review
ivanshamaev/de-agent-skills/group_skills/infra_dataops_group_skills/infra_grafana_dashboard_review Skill
no license15★ repoGrafana dashboard review — panel types (timeseries/stat/gauge/table/heatmap), variable templating (datasource/label_values/query), dashboard linking and drilldown, data platform dashboards (pipeline overview/DAG health/Kafka throughput/Spark performance), alerting from panels, annotation markers for deployments, dashboard-as-code (Grafonnet/Terraform grafana provider), performance optimization (query caching/recording rules), dark/light theme standards
ivanshamaev/de-agent-skills/group_skills/infra_dataops_group_skills/infra_kafka_cost_optimizer Skill
no license15★ repoKafka cost optimization — tiered storage (S3/GCS remote log offload, local.retention.ms vs retention.ms), topic retention right-sizing (per-topic audit SQL), log compaction economics, partition count right-sizing (over-partitioned cluster detection), consumer group idle cleanup, broker instance right-sizing (disk vs compute), Redpanda vs Confluent Cloud cost comparison, MirrorMaker2 cross-region cost, compression savings calculator
Infra kubernetes cost optimizer
ivanshamaev/de-agent-skills/group_skills/infra_dataops_group_skills/infra_kubernetes_cost_optimizer Skill
no license15★ repoKubernetes cost optimization — idle workload detection (zero-replica deployments, always-pending jobs), overprovisioning analysis (request vs actual CPU/memory), namespace-level cost attribution, node bin-packing via requests tuning, spot instance strategy, LimitRange defaults, right-sizing with VPA recommendations, Goldilocks tool, resource efficiency metrics, namespace resource quotas for chargeback
ivanshamaev/de-agent-skills/group_skills/infra_dataops_group_skills/infra_prometheus_optimization Skill
no license15★ repoPrometheus optimization — recording rules (level:metric:operations naming), cardinality explosion diagnosis (tsdb status API), scrape interval tuning, remote write configuration (batch size/queue capacity), Thanos/Mimir for long-term retention, federation vs remote write, AlertManager routing trees (inhibition/silencing), absent() alerts for missing series, relabeling to drop expensive labels, TSDB compaction, ServiceMonitor vs PodMonitor patterns
ivanshamaev/de-agent-skills/group_skills/starrocks_group_skills/dbt_starrocks_performance Skill
no license15★ repodbt + StarRocks performance tuning — model DAG optimization (fan-in/fan-out), incremental merge window sizing, partition-aware incremental filters, avoiding full table rebuilds, query plan hints in dbt SQL (LEADING/JOIN hints), materialized view as dbt model target, concurrent model execution with threads, pre/post hooks for ANALYZE TABLE, dbt run selectors to minimize rebuilt models
ivanshamaev/de-agent-skills/group_skills/starrocks_group_skills/starrocks_join_optimization Skill
no license15★ repoStarRocks join optimization — broadcast join (small dimension to all BEs), shuffle/hash join (repartition both sides), colocate join (no network transfer, same distribution key), bucket shuffle join, nested loop join (cross join/non-equi), join strategy selection rules, runtime filter effect on joins, join hints, EXPLAIN join strategy verification, skew join handling
ivanshamaev/de-agent-skills/group_skills/trino_group_skills/trino_cost_optimization Skill
no license15★ repoTrino warehouse cost optimization — query scan cost analysis (system.runtime.queries/system.runtime.tasks), identifying expensive queries by CPU time and data scanned, scan reduction via partition pruning and file compaction, worker autoscaling patterns (scale-to-zero for batch), spot instance strategies for workers, S3 object storage cost (storage vs request costs), Iceberg compaction economics (fewer splits = fewer S3 GET requests), cost attribution by team/user, materialized view break-even analysis, result caching
ivanshamaev/de-agent-skills/group_skills/trino_group_skills/trino_dbt_query_performance Skill
no license15★ repoOptimizing dbt-generated SQL performance on Trino — ephemeral vs view vs table materialization trade-offs, CTE explosion patterns, partition-aware incremental filters (bounded watermarks), MERGE vs delete+insert strategy selection, avoiding full-refresh anti-patterns, query hints in dbt SQL (BROADCAST hint), dbt thread tuning, session_properties for dbt runs, ANALYZE post-hooks, incremental model design patterns for Iceberg, avoiding small file proliferation from frequent incremental runs