Business

Transform Bronze layer data using DuckDB for joins, aggregations, and business logic. Use this skill for high-performance data transformations in the pipeline.

Create SEO-optimized marketing content with consistent brand voice. Includes brand voice analyzer, SEO optimizer, content frameworks, and social media templates. Use when writing blog posts, creating social media content, analyzing brand voice, optimizing SEO, planning content calendars, or when user mentions content creation, brand voice, SEO optimization, social media marketing, or content strategy.

Build premium SaaS interfaces that avoid vibe-coded anti-patterns. Use when creating UI components, forms, dashboards, hero sections, pricing pages, or any user-facing templates. Enforces consistent spacing, typography, color discipline, and accessibility standards.

Calculates supplier allowances (Marketing, DDR, General Discount) and volume rebates. Generates credit requests and credit memos. Use when working with CalculationType (ItemCost, ItemCostWithCredit, ItemCostWithCreditAllowance), ForCreditRequest, Earned, Accrual metrics, rebate tiers/steps, PaidToTheFirst, Growth rebate types, PaymentOnReachingStep, or ConditionType (CreditMemo, DeductedFromPayment).

Process vehicle insurance Excel data using Pandas - file handling, data cleaning, merging, validation. Use when processing Excel/CSV files, handling data imports, implementing business rules (negative premiums, zero commissions), debugging data pipelines, or optimizing Pandas performance. Keywords: data_processor.py, Excel, CSV, Pandas, merge, deduplication, date normalization.

Expert knowledge for Business Layer modeling in Documentation Robotics

Use this skill whenever the user wants to improve or set up logging, tracing, metrics, and monitoring for Cloudflare Workers/Pages (e.g. Hono + TypeScript), including Wrangler tail, Workers Analytics, log structure, and integration with external tools like Sentry.

Install and configure OADP operator with DataProtectionApplication for backup and restore operations on OpenShift clusters.

Build and implement Spring Boot 3 backend with Java 17 - REST APIs, JPA entities, services, repositories, security (JWT), and database migrations for Photo Map MVP. This skill should be used when creating, developing, or implementing *.java files, backend endpoints, business logic, database entities, DTOs, authentication, or API error handling. File types .java, .xml, .properties, .yml, .sql (project)

Store ClickHouse Cloud credentials in Doppler + 1Password for gapless-crypto-clickhouse. Use when setting up new services, rotating credentials, or backing up authentication material. Covers API keys, connection details, and database password storage.

Ecommerce integration patterns and decomposer/composer

Create high-quality, SEO-optimized content that ranks AND reads like a human wrote it. Use when turning keyword research into actual content pieces. Takes a target keyword/cluster and produces a complete article optimized for search while avoiding AI-sounding output. Triggers on: write SEO content for X, create article for keyword, write blog post about X, SEO article, content for keyword cluster. Outputs publication-ready content with proper structure, optimization, and human voice.

Complete Android release build configuration - orchestrates keystore, ProGuard, and signing setup

Enterprise Encryption Security with AI-powered cryptographic architecture, Context7 integration, and intelligent encryption orchestration for data protection

Restores full context when user says "hi-ai" or starts a new conversation. Searches project files, loads memory indexes, reads session state, and creates visual dashboard showing current project, recent decisions, active blockers, and quick actions. Use when user says "hi-ai", "continue", "restore context", or starts a fresh conversation.

Conducts user experience research and analysis to inform design decisions. Reviews first-party and third-party user data, analyzes industry trends from UX and visual design perspectives, and plans user research studies. Creates personas, customer segments, design principles, design roadmaps, and research discussion guides.

Specialized skill for AI product video generation. Use when you need product reveals, animated product shots, hero video banners, or e-commerce video content. Triggers on: product video, product reveal, animate product, hero video. Outputs professional product videos.

Complete guide for OpenAI's Assistants API v2: stateful conversational AI with built-in tools(Code Interpreter, File Search, Function Calling), vector stores for RAG (up to 10,000 files),thread/run lifecycle management, and streaming patterns. Both Node.js SDK and fetch approaches.⚠️ DEPRECATION NOTICE: OpenAI plans to sunset Assistants API in H1 2026 in favor of Responses API.This skill remains valuable for existing apps and migration planning.Use when: building stateful chatbots with OpenAI, implementing RAG with vector stores, executingPython code with Code Interpreter, using file search for document Q&A, managing conversation threads,streaming assistant responses, or encountering errors like "thread already has active run", vectorstore indexing delays, run polling timeouts, or file upload issues.Keywords: openai assistants, assistants api, openai threads, openai runs, code interpreter assistant,file search openai, vector store openai, openai rag, assistant streaming, thread persistence,state

Guides consistent, correct implementation of Stripe payment processing including payment flows, webhooks, subscriptions, and customer management. Use when integrating Stripe payments, setting up subscriptions, implementing webhooks, or managing customer billing.

Expert knowledge for running winter festival operations covering customer experience, security, vendor relations, lost & found, and marketing communications