Data & Analytics

dvcrn Bundle

This skill should be used when a user needs to analyze financial statements (Income Statement, Balance Sheet, Cash Flow Statement) from Excel or CSV files. It extracts financial data and calculates key metrics such as ROE, ROA, gross margin, and net margin. Trigger scenarios include requests like "analyze this financial report", "calculate ROE/ROA", "what's the gross margin", or any task involving reading and interpreting financial spreadsheets.

dvcrn Bundle

Use when defining product KPIs, building metric dashboards, running cohort or retention analysis, or interpreting feature adoption trends across product stages.

dvcrn Bundle

Search using a custom SearXNG instance via HTTP API. Enables privacy-friendly web search by aggregating results from multiple search engines. Supports query, format (json/csv/rss), language, time range, categories, engines, pagination, and safe search filtering. Requires a user-provided or configured SearXNG instance URL.

dvcrn Bundle

调用文档转换全能王(https://www.wdangz.com)API进行文档格式转换。支持PDF/Word/Excel/PPT/图片等格式互转，OCR识别，PDF合并拆分加密等。转换完成后自动下载到原文件目录。

dvcrn Bundle

Profile construction data to understand characteristics, distributions, quality metrics, and patterns. Essential for data quality assessment and ETL planning.

dvcrn Skill

Validate data with schemas across languages and formats. Use when defining JSON Schema, using Zod (TypeScript) or Pydantic (Python), validating API request/response shapes, checking CSV/JSON data integrity, or setting up data contracts between services.

dvcrn Skill

Create, edit, and manipulate Excel spreadsheets programmatically using openpyxl

dvcrn Bundle

Generate ETL and data transformation scripts. Use when migrating data between systems.

dvcrn Bundle

Yahoo Finance API tabanlı tarihsel veri analizi, algoritmik teknik indikatör skoru (RSI, MACD, Stoch, SMA), Excel geçmiş veri dışa aktarma, portföy alarm takibi ve işlem loglama. BIST (.IS), ABD, kripto, emtia ve parite desteklenir. Kullanıcı 'indikatör', 'skor', 'excel', 'geçmiş veri', 'işlem geçmişi', 'portföy raporu' gibi kelimeler kullandığında devreye girer.

dvcrn Skill

Real-time INCLAWNCH token analytics on Base. Price, volume, liquidity, staking TVL, UBI APY, distribution rates, and platform metrics in a single API call. No API key needed. Use when: (1) user asks about INCLAWNCH price or market data, (2) checking UBI staking yields, (3) monitoring ecosystem health, (4) building dashboards or alerts.

dvcrn Bundle

Manage Volcengine Supabase workspaces, branches, SQL queries, migrations, Edge Functions, Storage, and TypeScript type generation via a local CLI. Run uv run ./scripts/call_volcengine_supabase.py to get real-time results.

dvcrn Bundle

Query and analyze website analytics from Plausible Analytics. Use when you need to check real-time visitors, get page views and visitor statistics for a time period, analyze traffic sources or top pages, examine geographic distribution, or generate analytics reports and insights for websites tracked with Plausible Analytics.

dvcrn Skill

Manage database accounts and passwords for KubeBlocks clusters. Configure custom root passwords at cluster creation time and define password generation policies (length, complexity). Use when the user wants to set, change, reset, rotate, or customize database passwords, credentials, or account security policies. NOT for managing TLS/SSL certificates (see configure-tls) or for application-level database user management via SQL (connect directly to the database instead).

dvcrn Bundle

写入内容到本地文件，支持企业安全策略环境。支持文本文件、Word 文档 (.docx)、Excel 表格 (.xlsx) 等 80+ 种格式，通过正确的编码处理避免乱码问题。

dvcrn Skill

Google Sheets: Read values from a spreadsheet.

dvcrn Bundle

Manage HR operations with hiring pipelines, compliance frameworks, compensation strategy, and workforce analytics.

dvcrn Bundle

Buy Xcatcher points via x402 on Solana USDC, obtain an API key, create X crawl tasks, poll status, and download XLSX results.

dvcrn Bundle

Fetch and interpret Rankscale GEO (Generative Engine Optimization) analytics. Pulls brand visibility score, citation rate, sentiment, and top AI search terms.

dvcrn Bundle

Complete newsletter management system with subscriber signup (double opt-in), automated welcome drip sequence, broadcast sender, and subscriber analytics. 4 production-ready n8n workflows with Google Sheets backend.

dvcrn Bundle

Analyze conversation patterns, track productivity, and surface self-knowledge insights. Use when user wants to understand their own patterns (when they chat, what topics they discuss, productivity trends, sentiment over time). Provides weekly/monthly reports, topic recommendations, and time-based insights. Privacy-first design with all analysis local.

dvcrn Bundle

Build ORBCAFE advanced analytics interactions using CPivotTable/usePivotTable and voice navigation using CAINavProvider/useVoiceInput. Use when requests involve drag-drop pivot dimensions, aggregation controls, preset management, or space-key voice navigation workflows.

dvcrn Bundle

Comprehensive SQL Server performance diagnostics, index analysis, execution plan interpretation, query optimization, schema management, backup/restore, and monitoring using sqlcmd and T-SQL DMVs. Use when analyzing slow queries, investigating wait stats, finding missing indexes, reading execution plans, optimizing stored procedures or views, managing migrations, monitoring SQL Agent jobs, or diagnosing blocking/deadlocks on Microsoft SQL Server. Triggers on: SQL Server, MSSQL, sqlcmd, T-SQL performance, slow query, execution plan, DMV, missing index, wait stats, blocking, deadlock, stored procedure optimization, view tuning.

dvcrn Skill

Analyze websites and domains using SimilarWeb traffic data. Get traffic metrics, engagement stats, global rankings, traffic sources, and geographic distribution for comprehensive website research.

dvcrn Bundle

Turn messy client briefs into a production-ready plan for motion design/VFX projects: scope, assumptions/exclusions, deliverables matrix, schedule/milestones, review rounds, and estimate/quote. Also generate an invoice draft payload for Chris's local invoicing system (invoicing_system_2025) or export quote/invoice JSON/CSV/Markdown. Use when Chris asks to go from brief/email notes/chat logs into a clear plan + quote/invoice, or to create a repeatable project folder + docs.

dvcrn Bundle

Bulk upload products to Shopify stores. Read product data from Excel/CSV, automatically create products, images, variants, prices and inventory. Use cases: (1) Batch list new products (2) Migrate products from other platforms to Shopify (3) Batch update existing product information.

dvcrn Bundle

Scrape a public Letterboxd user's watchlist into a CSV/JSONL list of titles and film URLs without logging in. Use when a user asks to export, scrape, or mirror a Letterboxd watchlist, or to build watch-next queues.

dvcrn Bundle

Google Search Console API integration with managed OAuth. Query search analytics, manage sitemaps, and monitor site performance. Use this skill when users want to access Search Console data. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).

dvcrn Skill

Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.

dvcrn Bundle

Designs refreshable Excel dashboards (Power Query + structured tables + validation + pivot reporting). Use when you need a repeatable weekly KPI workbook that updates from files with minimal manual work.

dvcrn Bundle

Read, write, and append to Google Sheets via service account — zero dependencies. Use when an agent needs to access Google Sheets data, export spreadsheet contents, write rows, or list available sheets. Supports 1Password, env var, or file-based SA key loading.

dvcrn Bundle

Secure SharePoint file operations and Office document intelligence via Microsoft Graph API — certificate auth, Sites.Selected, read/write Word (mammoth), Excel (exceljs), PowerPoint (jszip), PDF (pdf-parse).

dvcrn Bundle

Generate warehouse analytics charts, table images, and report-ready visuals from SQLite/CSV data. Use when the user asks for warehouse charts, product table images, stock health pie charts, revenue/profit visuals, missing-product visuals, or image assets for PDF/slide reporting.

dvcrn Bundle

Provide TRON network analytics including transaction volume, type distribution, hot contracts, trending tokens, active accounts, staking metrics, and resource economics. Use when a user asks about TRON network health, daily stats, trending activity, top contracts, most active accounts, ecosystem overview, or on-chain analytics.

dvcrn Skill

神秘商店配置审核与Apollo配置生成工具。用于读取解析神秘商店的配置文档（如Excel、飞书文档等），审核抽奖概率配置（appid: 8001334），并生成Apollo配置输出。适用于：神秘商店活动配置审核、礼物ID规则校验、Apollo配置生成。

dvcrn Bundle

Track mobile app metrics with Firebase, App Store Connect, Play Console, retention, funnels, and cohort analysis.

dvcrn Skill

Turn Google Sheets into a powerful database and workflow engine using formulas, Apps Script, and integrations. Use when building systems in Sheets, automating data entry, creating dashboards, or replacing expensive tools with spreadsheet-based solutions. Covers advanced formulas, Apps Script basics, integration strategies, and real workflow examples. Trigger on "automate spreadsheet", "Google Sheets automation", "Apps Script", "spreadsheet workflow", "Sheets as database", "automate data entry".