Creative Skills

Transform documents, reports, and data into professional McKinsey-style HTML presentations with intelligent chart selection and interactive navigation. Use when: (1) Creating presentations from documents/reports, (2) Converting markdown/text to slides, (3) Generating HTML slides, (4) Applying McKinsey/BCG design, (5) Data visualization in presentations. Keywords: presentation, slides, HTML, McKinsey style, charts, visualization, 幻灯片, 演示文稿

Master SQL query optimization, indexing strategies, and EXPLAIN analysis. Use when debugging slow queries, designing database schemas, or optimizing application performance.

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 query', 'Check for N+1 problems'.

Guide for Convex performance optimization including denormalization, index design, avoiding N+1 queries, OCC (Optimistic Concurrency Control), and handling hot spots. Use when optimizing query performance, designing data models, handling high-contention writes, or troubleshooting OCC errors. Activates for performance issues, index optimization, denormalization patterns, or concurrency control tasks.

Generate high-quality illustration/chart ideas for a URL, including placement + layout suggestions (HTML-like or Mermaid).

Analyze datasets using Python with pandas, numpy, and visualization libraries. Generates statistical summaries, identifies patterns, creates charts, and provides insights. Use when analyzing CSV/Excel files, exploring data, creating visualizations, or when users mention data analysis, statistics, charts, or datasets.

Create or update interactive charts for car registration and COE data visualization. Use when adding new chart types, fixing chart bugs, or implementing data visualizations.

Data visualization and inspection skill. Use when user asks to plot, chart, graph, or visualize data from files or marimo notebooks. Also use for DataFrame inspection when user wants to "show", "display", or "see" data structure (columns, dtypes, first N rows). Supports matplotlib/seaborn for plots, marimo notebook extraction, and artifact management in .viz/.

World-class expert database master covering PostgreSQL, MySQL, MongoDB, Redis, and database architecture. Use when designing schemas, optimizing queries, planning migrations, implementing caching strategies, or solving complex database challenges at production scale.

Expert UI/UX design intelligence for creating professional, modern, and accessible interfaces in RuoYi-Vue.

Learn how to use D3.js with Helios for data visualization. Use when creating charts, graphs, or data-driven animations.

Build mathematically correct, visually prominent data visualizations for time-series charts. Use this skill when creating charts with mathematical overlays (trendlines, patterns, indicators), fixing visual artifacts (wavy lines, domain mismatches), or validating chart correctness. Focuses on technical correctness and progressive validation, not aesthetic design.

Expert guidance for SQL optimization, MyBatis XML mapping, and Schema design in MySQL.

Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.

The Data Artist. Generates bespoke SVG charts based on data points in the HTML.

AISC Design Guide 1 expert for steel column base plate and anchor rod connection design. Use when users ask about base connections, base plates, anchor rods, column-to-foundation connections, concrete bearing strength, eccentricity, small vs large moment classification, shear transfer, or AISC Design Guide 1. Supports both LRFD and ASD design methods with 15 worked examples covering axial, moment, shear, and biaxial loading.

Research technical solutions, analyze architectures, gather requirements thoroughly. Use for technology evaluation, best practices research, solution design, scalability/security/maintainability analysis.

Build financial models for startups, business cases, revenue forecasting, unit economics, and investment analysis. Includes templates and formulas.

Database schema design, ETL pipelines, and data quality for RetentionAI. Use this skill when working on: (1) Database schema design and migrations, (2) ETL pipelines (GA4, Stripe, Shopify), (3) Data quality validation, (4) Multi-tenant JSONB patterns, (5) Query optimization and indexing, (6) Data generation and seeding.

Generates a premium golden-themed Power BI dashboard design. It provides JSON themes, visual configurations for KPIs, charts, and slicers to create a high-end aesthetic.

Generates a premium golden-themed Power BI dashboard design. It provides JSON themes, visual configurations for KPIs, charts, and slicers to create a high-end aesthetic.

Guide synthesis of Action Mapping workshop outputs into structured discovery documents. Use when processing workshop notes, creating needs analysis, building learner personas, summarizing discovery sessions, or preparing design briefs from stakeholder meetings.

Architecture visualization patterns using Mermaid and ASCII diagrams. Use for service flows, sequence diagrams, C4 models, decision matrices, or expressing architectural ideas visually. Trigger terms: diagram, flowchart, sequence diagram, architecture visualization, C4 model.

Design and implement clean, fast, repeatable, production-grade frontend dashboards optimized for large datasets, static hosting, and long-term maintainability. Use this skill when building data-heavy UIs, dashboards, tables, filters, analytics interfaces, or performance-sensitive frontend applications.

Use when defining product analytics requirements. Use after product live. Produces KPI definitions, dashboard specifications, alert thresholds, and measurement methodology.

Build Python-native dashboards with Streamlit. Covers layouts, components, session state, caching, charts, custom components, and deployment. Use for data science dashboards, ML demos, internal tools, and rapid prototyping with Python.

Create effective data visualizations with React charting libraries. Covers chart selection, Recharts, Chart.js, D3.js basics, real-time data, accessible charts, and color palettes. Use for charts, graphs, dashboards, and data-driven displays.

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Design effective dashboards with clear layouts, KPI displays, data grids, and real-time updates. Covers dashboard patterns, information hierarchy, responsive grids, widget design, and admin panel layouts. Use for building analytics dashboards, admin interfaces, and monitoring displays.

Visualize biomechanics signal data including EMG, Forceplate (Fx/Fy/Fz), and CoP/CoM trajectories. Use when creating grid plots, onset timing markers, window highlights, TKEO pipeline visualizations, or trajectory scatter plots for biomechanics research. Triggers on EMG plot, forceplate visualization, CoP trajectory, CoM trajectory, TKEO onset, signal grid, biomechanics chart.

Optimize SQL queries for Databricks analytics with automatic data profiling, partition analysis, and performance optimization. Use when users request data analysis, SQL queries, or analytics tasks that involve large tables. The skill ensures queries are optimized by checking table metadata, partition columns, data size, and applying best practices before executing queries. Essential for interactive analytics requiring good performance on large datasets.

This skill should be used when the user wants to visualize data. It intelligently selects the most suitable chart type from 26 available options, extracts parameters based on detailed specifications, and generates a chart image using a Python script.

This skill should be used when the user asks to \"create report\", \"dashboard\", \"chart\", \"visualization\", \"analytics\", \"scheduled report\", \"export data\", or any ServiceNow reporting and dashboard development.

Generate draw.io editable diagrams (.drawio, .drawio.svg) from text, images, or Excel. Orchestrates 3-agent workflow (Analysis → Manifest → SVG generation) with quality gates. Use when creating architecture diagrams, flowcharts, sequence diagrams, or converting existing images to editable format. Supports Azure/AWS cloud icons.

Comprehensive health audit for design documentation. Use when performing thorough quality checks, preparing for releases, or ensuring documentation compliance.

Create and fill dynamic layout reports via API. Use when building structured reports with layouts containing grids, flex containers, and content slots. Supports charts (Chart.js), diagrams (Mermaid), infographics (AntV), markdown, tables, and code blocks. Use this skill when asked to create reports, dashboards, or documents with visual layouts.

Use this skill when the user needs to define evaluation metrics, select datasets, or design grading/annotation strategies for agent optimization. Provides a structured, decision-driven workflow and reusable templates.

Generate PDF and PowerPoint reports from PinMeTo location analytics. Triggers: quarterly report, Q1 report, Q2 report, Q3 report, Q4 report, monthly report, annual report, yearly report, H1 report, H2 report, location report, location analytics, PinMeTo, Google Business, create report, generate report, performance report, analytics report, executive summary, board presentation, multi-location brands, Facebook metrics, Apple Maps, keyword analysis, review analysis.

This skill should be used when generating progress visualizations, charts, graphs, sparklines, progress bars, or dashboards in the terminal. Provides patterns for ASCII-based data visualization in Claude Code responses.

Creates beautiful ASCII art visualizations for plans, architectures, workflows, and data. This skill should be used when explaining system architecture, creating implementation plans, showing workflows, visualizing comparisons, or documenting file structures. NOT for code syntax highlighting or markdown tables. User explicitly loves ASCII art - use liberally for visual communication.