Data & Analytics

tomevault-io Bundle

Use when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to Snowflake) using dbt Fusion's real-time compilation to identify and fix SQL dialect differences.

tomevault-io Bundle

Embedded SQL database providing ACID transactions, full-text search (FTS5), spatial indexing (R-Tree), JSON processing, virtual tables, and extensions. Use when building applications requiring embedded SQL databases, performing data analysis, implementing persistent storage, or working with SQLite features from basic CRUD to advanced queries. Use when this capability is needed.

tomevault-io Bundle

backtesting.py configuration for SQL oracle validation and range bar pattern backtesting. Use when running backtesting.py against ClickHouse SQL results, configuring Backtest() constructor, handling overlapping trades, multi-position mode, rolling quantile NaN handling, trade sorting, or oracle gate validation. TRIGGERS - backtesting.py, Backtest(), hedging, exclusive_orders, multi-position, overlapping trades, oracle validation, SQL vs Python, trade comparison, entry price mismatch, signal count mismatch, rolling quantile NaN, ExitTime sort, stats._trades, gen600_strategy, champion_strategy, gen300_strategy, barrier setup. Use when this capability is needed.

tomevault-io Bundle

Use when working with a Python data visualization library based on matplotlib. It provides a high-level interface for drawing attractive and informative statistical graphics. Great for exploring relationships between variables and visualizing distributions. Use for statistical data visualization, exploratory data analysis (EDA), relationship plots, distribution plots, categorical comparisons, regression visualization, heatmaps, cluster maps, and creating publication-quality statistical graphics from Pandas DataFrames.

tomevault-io Bundle

Master quick plotting and interactive visualization with hvPlot. Use this skill when creating basic plots (line, scatter, bar, histogram, box), visualizing pandas DataFrames with minimal code, adding interactivity and hover tools, composing multiple plots in layouts, or generating publication-quality visualizations rapidly. Use when this capability is needed.

tomevault-io Bundle

SQL database management — migrations, schema auto-upgrade, PostgreSQL, SQLite, optimization Use when this capability is needed.

tomevault-io Bundle

Merge multiple CSV/Excel files with intelligent column matching, data deduplication, and conflict resolution. Handles different schemas, formats, and combines data sources. Use when users need to merge spreadsheets, combine data exports, or consolidate multiple files into one. Use when this capability is needed.

tomevault-io Bundle

Specialized Preact development skill for standards-based web applications with native-first architecture and minimal dependency footprint. Use when building Preact projects, particularly those involving data visualization, interactive applications, single-page apps with HTM syntax, Web Components integration, CSV/JSON data parsing, WebGL shader visualizations, or zero-build solutions with vendored ESM imports. Use when this capability is needed.

tomevault-io Bundle

Master modern business analysis with AI-powered analytics, real-time dashboards, and data-driven insights. Build comprehensive KPI frameworks, predictive models, and strategic recommendations. Use when this capability is needed.

tomevault-io Bundle

AI-native session continuity through shape anchors rather than linear logs. Use when beginning a session to orient from prior state, or when ending to crystallize state for future instances. Use when this capability is needed.

tomevault-io Bundle

Create a minimal working Snowflake example with real SQL queries. Use when this capability is needed.

tomevault-io Bundle

Scaffold or extend a FeathersJS v5 (Dove) service using the idiomatic four-file pattern (<name>.ts, <name>.class.ts, <name>.schema.ts, <name>.shared.ts), register it with app.configure, and wire it into the ServiceTypes declaration. Use this whenever the user wants to add a new resource, endpoint, collection, table-backed CRUD service, or "service" to a FeathersJS / Feathers app, or mentions feathers generate service, app.use, a database adapter (Knex/SQL, MongoDB, Memory), or asks why their service isn't registered. Trigger even if they just say "add a posts endpoint" or "make a CRUD resource" in a Feathers project. Use when this capability is needed.

tomevault-io Bundle

SQL Server Core Knowledge

tomevault-io Bundle

Logs and scores skill usage quality, tracking output effectiveness, user satisfaction signals, and improvement opportunities. Expert in skill analytics, quality metrics, feedback loops, and Use when this capability is needed.

tomevault-io Bundle

Spreadsheet generation powered by CellCog. Create Excel files, financial models, budget templates, data trackers, calculations, projections, XLSX files. AI-powered spreadsheet builder. Use when this capability is needed.

tomevault-io Bundle

SQL Gameplay

tomevault-io Bundle

Predictive analytics for Dynatrace — time series forecasting with the timeseries-forecast tool, capacity saturation planning, trend and anomaly detection across hosts, services, and infrastructure. Use when this capability is needed.

tomevault-io Bundle

SQL注入测试的专业技能和方法论 Use when this capability is needed.

tomevault-io Bundle

NetworkSim - Provider Network Intelligence & Analytics

tomevault-io Bundle

---

tomevault-io Bundle

Expert knowledge for building SQL database sinks from Substreams. Covers database changes (CDC), relational mappings, PostgreSQL, ClickHouse, and materialized views. Use when this capability is needed.

tomevault-io Bundle

Database expert - query optimization, schema design Use when this capability is needed.

tomevault-io Bundle

Agent/Skill 사용 통계 및 성과 리포트 생성 전문가. CLI 차트로 시각화하고 인사이트를 제공합니다. "통계", "사용량", "analytics", "성과", "리포트", "메트릭", "분석", "usage", "metrics", "statistics", "report" 키워드에 반응. Use when this capability is needed.

tomevault-io Bundle

Create/edit .xlsx spreadsheets with formulas, charts, and data validation. Use when asked to generate Excel reports, models, or exports. Use when this capability is needed.

tomevault-io Bundle

Detects various injection vulnerabilities including SQL injection, LDAP injection, XPath injection, and code injection. Use when analyzing database queries, dynamic code generation, or investigating injection attacks. Use when this capability is needed.

tomevault-io Bundle

Design and optimize database schemas for SQL and NoSQL databases. Use when creating new databases, designing tables, defining relationships, indexing strategies, or database migrations. Handles PostgreSQL, MySQL, MongoDB, normalization, and performance optimization. Use when this capability is needed.

tomevault-io Bundle

Work on an issue or PR - implement changes, add tests, update docs, lint, add changesets, and create a PR Use when this capability is needed.

tomevault-io Bundle

Tracks untrusted input propagation from sources to sinks in binary code to identify injection vulnerabilities. Use when analyzing data flow, tracing user input to dangerous functions, or detecting command/SQL injection. Use when this capability is needed.

tomevault-io Bundle

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices. Use when this capability is needed.

tomevault-io Bundle

Generate production-ready T-SQL scripts for the TSQL.APP framework. Use when creating TSQL.APP action scripts, modal forms, data processing scripts, or any T-SQL code that runs within the TSQL.APP environment. This skill enforces 11 critical mandated practices and ensures procedure verification against the authoritative CSV catalog. Use when this capability is needed.

tomevault-io Bundle

ドキュメント内のNuxt UI v3記法を検出し、v4記法への修正を支援します。「ドキュメントをチェックして」「Nuxt UI v4の記法を確認」などで呼び出されます。 Use when this capability is needed.

tomevault-io Bundle

開発作業のテスト手順書（testing.md）を生成します。このスキルは単独で使用することも、generate-working-docsから呼び出されることもあります。 Use when this capability is needed.

tomevault-io Bundle

Use when implementing authentication/authorization, securing user input, or preventing OWASP Top 10 vulnerabilities — including custom security implementations such as hashing passwords with bcrypt/argon2, sanitizing SQL queries with parameterized statements, configuring CORS/CSP headers, validating input with Zod, and setting up JWT tokens. Invoke for authentication, authorization, input validation, encryption, OWASP Top 10 prevention, secure session management, and security hardening. For pre-built OAuth/SSO integrations or standalone security audits, consider a more specialized skill.

tomevault-io Bundle

Generate parameter bindings for SQL files by analyzing database schema and extracting SQL placeholders. Queries the live database for table structures, matches placeholders to column types, and generates appropriate test values based on column patterns (IDs, dates, status enums, etc). Use when this capability is needed.

tomevault-io Bundle

God-level database mastery covering SQL (PostgreSQL deep dive, MySQL differences), NoSQL (MongoDB, Cassandra, DynamoDB), NewSQL (CockroachDB, Spanner), caching (Redis deep dive — data structures, persistence, clustering, pub/sub), message streaming (Apache Kafka — architecture, partitioning, consumer groups, exactly-once semantics), Elasticsearch/OpenSearch (indexing, mapping, search relevance, aggregations), time-series (InfluxDB, TimescaleDB), graph databases (Neo4j), schema design, query optimization, indexing strategies, ACID vs BASE, CAP theorem, replication, sharding, and connection pooling. A developer who does not understand their database is a developer who will eventually bring it to its knees. Use when this capability is needed.

tomevault-io Bundle

Comprehensive guide for BlazeMeter API Monitoring, including test creation, configuration, scripting, integrations, notifications, and management. Use when working with API Monitoring tests for (1) Creating and configuring API tests, (2) Writing custom scripts (Initial, Pre-request, Post-response), (3) Integrating with third-party services (Slack, PagerDuty, Datadog, etc.), (4) Managing teams, buckets, and RBAC, (5) Configuring notifications and sharing results, (6) Using test data (CSV, Data Entities), (7) Advanced features (GraphQL, SOAP, file uploads, environments), or any other API Monitoring tasks. Use when this capability is needed.