Data & Analytics

tomevault-io Bundle

Excel Automation with excelcli

tomevault-io Bundle

Excel MCP Server Skill

tomevault-io Bundle

Guide for implementing database engines in IterableData. Use when adding support for new SQL or NoSQL databases, implementing DBDriver classes, or extending database capabilities. Use when this capability is needed.

tomevault-io Bundle

Use this skill for processing and analyzing large tabular datasets (billions of rows) that exceed available RAM. Vaex excels at out-of-core DataFrame operations, lazy evaluation, fast aggregations, efficient visualization of big data, and machine learning on large datasets. Apply when users need to work with large CSV/HDF5/Arrow/Parquet files, perform fast statistics on massive datasets, create visualizations of big data, or build ML pipelines that don't fit in memory.

tomevault-io Bundle

Blog Planner

tomevault-io Bundle

Build zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence. Use when asked to "write migration", "schema change", "add column", "rename table", "drop column", or "migrate safely". Use when this capability is needed.

tomevault-io Bundle

Requirements for Outputs

tomevault-io Bundle

Language-specific standards and idioms for Python, TypeScript, and SQL. Load when reviewing, implementing, or debugging code to apply the right conventions for the language at hand. Use when this capability is needed.

tomevault-io Bundle

Genome Analytics

tomevault-io Bundle

Integrate digital health data sources (Apple Health, Fitbit, Oura Ring) and connect to WellAlly.tech knowledge base. Import external health device data, standardize to local format, and recommend relevant WellAlly.tech knowledge base articles based on health data. Support generic CSV/JSON import, provide intelligent article recommendations, and help users better manage personal health data. Use when this capability is needed.

tomevault-io Bundle

Optimize SQL queries, indexes, and identify N+1 problems. Use for database performance and migration review. Use when this capability is needed.

tomevault-io Bundle

Use whenever writing or editing any endpoint under backend/src/intric/api/** (and the services those endpoints call). Enforces Eneo's non-negotiable backend invariants — tenant_id filter on every query, audit entry on every mutation, Pydantic v2 response models, SQLAlchemy 2.0 style, structured logging, zero raw SQL. Load this skill before touching any FastAPI router so the patterns are in context.

tomevault-io Bundle

Database Architect skill. Use this when you need to modify the database schema, add tables, or seed data. This project uses RAW SQL SCRIPTS orchestrated by .NET Aspire, NOT Entity Framework Migrations. Use when this capability is needed.

tomevault-io Bundle

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance. Use when this capability is needed.

tomevault-io Bundle

Build Oxy workflows, SQL queries, and agents following best practices. Use when the user asks to create data pipelines, queries, or analysis agents. Enforces hierarchy - semantic queries first, then SQL/workflows, then agents. Use when this capability is needed.

tomevault-io Bundle

Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection. Activates for database design, optimization, and implementation tasks. Use when this capability is needed.

tomevault-io Bundle

Guidelines for data analysis and Jupyter Notebook development with pandas, matplotlib, seaborn, and numpy. Use when this capability is needed.

tomevault-io Bundle

Analyze data with DuckDB — an in-process analytical database that runs SQL directly on Parquet, CSV, JSON, and Arrow files with columnar speed. Use this skill whenever the user wants to query local files with SQL, run analytics without a database server, analyze Parquet or CSV data, or use DuckDB in Python/Node.js/Wasm. Trigger for "duckdb", "query parquet files", "in-process analytics", "fast local sql", or "duckdb python". Use when this capability is needed.

tomevault-io Bundle

Audits Python libraries for security vulnerabilities using Bandit, pip-audit, Semgrep, and detect-secrets. Identifies SQL injection, command injection, hardcoded credentials, weak cryptography, and insecure deserialization. Use when reviewing library security, setting up security scanning in CI, or implementing secure coding patterns. Use when this capability is needed.

tomevault-io Bundle

Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use this skill when building an executive SaaS metrics dashboard tracking MRR, churn, and LTV/CAC ratios; designing an operations center with live service health and request throughput; creating a cohort retention analysis view for a product team; or debugging a dashboard where metrics contradict each other due to inconsistent calculation methodology. Use when this capability is needed.

tomevault-io Bundle

Write efficient, secure database queries that prevent SQL injection, avoid N+1 problems, and optimize performance through proper indexing and caching strategies. Use this skill when writing SQL queries for PostgreSQL, MySQL, SQLite, or any SQL database; when using ORM query builders like Prisma, Sequelize, TypeORM, ActiveRecord, Django ORM; when implementing parameterized queries to prevent SQL injection; when optimizing query performance with proper indexing; when eager loading relationships to avoid N+1 queries; when selecting specific columns instead of SELECT *; when wrapping related operations in transactions for data consistency; when implementing query timeouts to prevent runaway operations; when caching expensive query results; or when working with database query optimization and performance tuning. Use when this capability is needed.

tomevault-io Bundle

Reviews JSON Schema files in iglu-central for common issues found in PR reviews. Checks field constraints, type definitions, warehouse compatibility, and consistency patterns. Use when reviewing schema files before PR submission or when validating changes to schemas in the schemas/ directory. Use when this capability is needed.

tomevault-io Bundle

Native Python execution via the local Python bridge. Use when the user asks about running Python locally, setting up the Python bridge, LibreOffice conversion, or troubleshooting Python connectivity. Use when this capability is needed.

tomevault-io Bundle

Data science and analytics expertise for statistical analysis, machine learning pipelines, data governance, business intelligence, predictive modeling, and analytics strategy. Use when building ML models, analyzing data, creating dashboards, or designing data architectures. Use when this capability is needed.

tomevault-io Bundle

SQL Database

tomevault-io Bundle

Database workflow with Postgres, Kysely, and Atlas migrations. Use when modifying database schema, creating migrations, generating TypeScript types, or troubleshooting database issues. Triggers on "schema change", "migration", "db-migrate", "kysely", "atlas", or when editing db/schema.sql. Use when this capability is needed.

tomevault-io Bundle

Convert PDF, DOCX, XLSX, and text files to clean, structured Markdown. CJK-friendly, table-friendly, privacy-first. Use when this capability is needed.

tomevault-io Bundle

Expert-level SQL database design, querying, optimization, and administration across PostgreSQL, MySQL, and SQL Server Use when this capability is needed.

tomevault-io Bundle

sql-splitter Skill

tomevault-io Bundle

Audits database data quality (nulls, duplicates, orphans, invalid ranges) and produces a short findings report with remediation queries. Use when debugging data issues, validating migrations, or verifying analytics correctness. Use when this capability is needed.

tomevault-io Bundle

Expert in Model Context Protocol (MCP) server development. Use when building MCP servers, creating tools for Claude, implementing resources, debugging MCP connections, or integrating databases with Claude Code. Use when this capability is needed.

tomevault-io Bundle

Writes and executes SQL queries from simple SELECTs to complex multi-table JOINs, aggregations, and subqueries. Use when the user asks to query a database, write SQL, run a SELECT statement, retrieve data, filter records, or generate reports from database tables. Use when this capability is needed.

tomevault-io Bundle

Use when automating browsers, scraping web data, executing SQL-like queries against web pages, managing proxy caching or request interception, or building any browser automation workflow with BrowserX MCP tools

tomevault-io Bundle

R data manipulation, formats, and database packages. Use for data wrangling with dplyr/data.table, reading files (CSV, Excel, JSON, Arrow), and database connections (SQL, MongoDB, Redis). Use when this capability is needed.

tomevault-io Bundle

AUTO-ACTIVATE on keywords (workflow, kanban, regras de negócio, transição, processo, estado, automação, patterns, agents, dashboard). Provides comprehensive knowledge and practical tools for developing the Kanban-Workflow system in VibeCForms v4.0. Covers workflow architecture, implementation phases, AI agents, pattern analysis, visual editors, business rules, auto-transitions, and analytics. Use when user mentions workflow-related concepts or business logic. Use when this capability is needed.

tomevault-io Bundle

Intent-based code interpretation across all languages — SQL, Python, JS, YAML, Bash, and beyond Use when this capability is needed.