clickhouse-query-optimization
Optimize ClickHouse queries for speed and efficiency. Helps with primary key design, sparse indexes, data skipping indexes (minmax, set, bloom filter, ngrambf_v1), partitioning strategies, projections, PREWHERE...
Découvrez les skills tools data analysis, comparez leurs dépôts et consultez leurs instructions.
Optimize ClickHouse queries for speed and efficiency. Helps with primary key design, sparse indexes, data skipping indexes (minmax, set, bloom filter, ngrambf_v1), partitioning strategies, projections, PREWHERE...
Xiaohongshu (Little Red Book) infographic series generator with multiple style options. Breaks down content into 1-10 cartoon-style infographics. Use when user asks to create "小红书图片", "XHS images", or "Red...
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for...
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. Provides intelligent header detection and semantic column mapping for robust da...
Data analysis workflows and patterns for processing, analyzing, and visualizing data using Python data science libraries.
Analyze plans and improve query performance.
Document ER diagrams and table metadata.
MongoDB database exploration for understanding game data, debugging, and investigation. Auto-applies when discussing database structure or debugging data issues.
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Create and embed Mermaid diagrams in Markdown files for visualizing documentation, features, architecture, workflows, and processes. Use when asked to "add a diagram", "create a flowchart", "visualize the workf...
Product analytics and feedback loop guidance for KPIs, funnels, and experimentation. Use when defining metrics instrumentation, experiments, or indicators of product success.
Progress reporting and dashboard creation
Perform comprehensive data analysis, statistical modeling, and data visualization by writing and executing self-contained Python scripts. Use when you need to analyze datasets, perform statistical tests, create...
Create dashboards with KPIs and real-time metrics.
Automated weekly report generation from exported Excel time tracking data. Transforms cost report exports into formatted weekly project reports following company templates. Use when generating 項目週報 (project...
Activates when user requests performance optimization, N+1 query analysis, caching strategy design, database tuning, or scalability assessment. Do NOT use for security audits. Examples: 'Optimize this slow quer...
Design data visualisations for B2B dashboards displaying buying signals, composite scores, trends, and alerts. Apply when building charts, sparklines, score breakdowns, heatmaps, or any interface requiring rapi...
Data analysis, scientific computing, visualization with pandas, numpy, matplotlib
多次元フィールドデータ(Field4D/Matrix等)の抽出ロジックと描画APIを、物理的整合性を保ちながら実装する
A/B testing framework for safe experimentation with statistical validation
Ideate and critique data visualizations using Edward Tufte's principles from "The Visual Display of Quantitative Information." Use this skill when: (1) Designing new data visualizations or charts (2) Critiquing...
Data visualization and inspection skill. Use for (1) creating matplotlib/seaborn plots from data files or marimo notebooks, or (2) inspecting DataFrames by showing first N rows, column names, and dtypes. For pl...
Analyze Excel file structure including worksheets, headers, formulas, and data types.
Health overview for your entire book of business — Enterprise or SMB/Mid-Market
Le classement utilise les étoiles du dépôt GitHub indexé. Plusieurs skills peuvent partager ce nombre : ce n’est ni un nombre d’installations ni une note de qualité.