Performance
Performance profiling and optimization
trino
by treasure-data
TD Trino SQL with TD-specific functions (td_interval, td_time_range, td_time_string, td_sessionize). Use for time-based filtering, partition pruning, and TD query patterns.
trino-to-hive-migration
by treasure-data
Convert Trino queries to Hive when memory errors occur. Covers syntax differences (td_time_string→TD_TIME_FORMAT, REGEXP_LIKE→RLIKE, ARRAY_AGG→COLLECT_LIST) and engine selection.
identity
by treasure-data
Query identity change logs to explore profile creation and merging
trino-optimizer
by treasure-data
TD Trino performance optimization including CTAS (5x faster), UDP bucketing for ID lookups, magic comments for join distribution, REGEXP_LIKE vs LIKE, and approx functions.
hive
by treasure-data
TD Hive SQL with TD-specific functions and Hive-only features (lateral view, explode, MAPJOIN hint). Use when Trino memory errors occur or for Hive-specific syntax.
ask-questions-if-underspecified
by skillcreatorai
Clarify requirements before implementing. Do not use automatically, only when invoked explicitly.
java-performance
by pluginagentmarketplace
JVM performance tuning - GC optimization, profiling, memory analysis, benchmarking
oni-mcp-opening-setup
by LIghtJUNction
当开始新的 Oxygen Not Included 殖民地，或用户要求开局设置/bootstrap 配置时使用。涵盖思考前暂停、错峰日程、按属性重命名复制人并由用户确认命名风格、禁用自动消毒、侦察起始星体，以及规划早期双侧扩张和打印舱实验室。
oni-mcp-play-loop
by LIghtJUNction
当用户要求 agent 通过 MCP 循环游玩 Oxygen Not Included、自动玩一段时间、继续殖民地，或运行暂停-规划-恢复循环时使用。强制执行严格的 pause -> observe -> plan -> execute -> resume briefly -> pause -> verify 循环，读取 game_control domain=ui uiDomain=edit_mark action=list，限制运行窗口，并在风险或歧义决策前停下等待用户确认。
code-optimization
by bytedance
Optimize code performance through iterative improvements (max 2 rounds). Benchmark execution time and memory usage, compare against baseline implementations, and generate detailed optimization reports. Supports C++, Python, Java, Rust, and other languages.
bio-chipseq-visualization
by GPTomics
Visualize ChIP-seq data using deepTools, Gviz, and ChIPseeker. Create heatmaps, profile plots, and genome browser tracks. Visualize signal around peaks, TSS, or custom regions. Use when visualizing ChIP-seq signal and peaks.
bio-chipseq-peak-annotation
by GPTomics
Annotate ChIP-seq peaks to genomic features and genes using ChIPseeker. Assign peaks to promoters, exons, introns, and intergenic regions. Find nearest genes and calculate distance to TSS. Generate annotation plots and statistics. Use when annotating ChIP-seq peaks to genomic features.
bio-alignment-msa-statistics
by GPTomics
Calculate alignment statistics including sequence identity, conservation scores, substitution matrices, and similarity metrics. Use when comparing alignment quality, measuring sequence divergence, and analyzing evolutionary patterns.
advanced-memory-skill-creator
by sandraschi
Use when planning, scaffolding, validating, or packaging Claude skills inside Advanced Memory MCP.
asset-optimization
by arjun988
Validates and optimizes Blender assets for polycount, topology, UV efficiency, material count, naming, collections, and game-ready performance. Use before export on all production assets via MCP.
react-best-practices
by henkisdabro
Comprehensive React and Next.js performance optimisation guide with 40+ rules for eliminating waterfalls, optimising bundles, and improving rendering. Use when optimising React apps, reviewing performance, or refactoring components.
quality-metrics
by Logos-Liber
Test coverage, code quality, defect metrics, and QA KPIs
rust-systems-design
by organvm-iv-taxis
Provides expert guidance on Rust programming, focusing on memory safety, concurrency patterns, and idiomatic architectural choices for systems software.
Remotion Best Practices
by ComposioHQ
Use this skill when the user asks about creating videos with React, Remotion framework, programmatic video generation, video animations, or needs help with Remotion projects
Dotfiles Best Practices
by kriscard
"Dotfiles: Reference knowledge for modern CLI tools and shell best practices. Loaded by dotfiles-optimizer when needed."
Dotfiles Optimizer
by kriscard
"Dotfiles: Use when optimizing shell configs (zsh, tmux, git), auditing dotfiles security, or improving dev environment. NOT for application configs."
Chrome DevTools
by kriscard
"Browser: Use when inspecting pages, checking console errors, analyzing network requests, or running performance traces. NOT for writing frontend code."
react-best-practices
by kriscard
"React: Use when auditing React components for performance, re-renders, or bundle size. NOT for Vue, Angular, or general TypeScript."
unity
by Logos-Liber
Unity game engine patterns, lifecycle, best practices, and C# conventions