Data & Analytics

tomevault-io Bundle

XLSX Skill

tomevault-io Bundle

IPA「安全なウェブサイトの作り方 改訂第7版」「安全なSQLの呼び出し方」「ウェブ健康診断仕様」「セキュリティ実装チェックリスト」「安全なウェブサイトの運用管理に向けての20ヶ条」に基づき、ソースコードを静的に検査して脆弱性候補を検出する。発見した問題には IPA 原典の出典 (文書名・章・ページ・URL) を必ず付与する。 Use when this capability is needed.

tomevault-io Bundle

Logging best practices focused on wide events (canonical log lines) for powerful debugging and analytics Use when this capability is needed.

tomevault-io Bundle

Run MySQL queries via mysql client using a prefix + env file convention. Use when this capability is needed.

tomevault-io Bundle

SQL Guide

tomevault-io Bundle

Expert in database design, SQL optimization, ORM patterns, migrations, and data modeling. Use when this capability is needed.

tomevault-io Bundle

Run PostgreSQL queries for testing, debugging, and performance analysis. Use when you need to query the database directly, run EXPLAIN ANALYZE, compare query results, or test SQL optimizations. Always uses read-only connections unless explicitly directed otherwise. Use when this capability is needed.

tomevault-io Bundle

Generate a Windows Claude Desktop `claude_desktop_config.json` (and a parallel Claude Code CLI MCP file) from the stdio MCP server configs in `~/.claude/mcp/*.json`. Each WSL command is wrapped as `wsl.exe -d <distro> -- bash -lc 'exec …'`, paths are translated from `~` to `/home/ctodie`, and secret-named env vars are replaced with placeholders + a warning. Use when the user says "set up MCP on Windows", "bridge my WSL MCP servers", "regenerate claude_desktop_config", or after adding/removing a server in `~/.claude/mcp/`. Args — `--source <dir>` (default `~/.claude/mcp/`), `--out <path>` (default `~/configs/mcp-bridge/claude_desktop_config.json`), `--wsl-distro <name>` (default auto-detect via `wsl.exe -l -v` or `Ubuntu`), `--include <csv>`, `--exclude <csv>`, `--print` (stdout instead of write), `--dry-run`. Use when this capability is needed.

tomevault-io Bundle

Comprehensive cheat sheet for using the Pathling Python API. Use this skill when working with FHIR data in Python, running SQL on FHIR queries, using terminology functions, encoding FHIR resources, or any other Pathling Python operations. Trigger keywords include "pathling", "pathling python", "fhir encoding", "sql on fhir python", "terminology functions", "member_of", "translate", "subsumes", "PathlingContext". Use when this capability is needed.

tomevault-io Bundle

Read, write, analyze, and format Excel spreadsheets (.xlsx). Use when the user needs to create Excel files, extract data from spreadsheets, apply formulas, format cells, or generate Excel reports from data. Supports multiple sheets, charts, and conditional formatting. Use when this capability is needed.

tomevault-io Bundle

Sheet Model — Headless Spreadsheet for Agents

tomevault-io Bundle

Master metrics definition, KPI tracking, dashboarding, A/B testing, and data-driven decision making. Use data to guide product decisions. Use when this capability is needed.

tomevault-io Bundle

Use when an OpenClaw user clearly wants a local Office or image artifact such as a PPTX, DOCX, XLSX, Report, or IMG, and route the request through officecli agent-bridge instead of parsing human CLI output.

tomevault-io Bundle

Capable of converting raw SQL queries into type-safe Kysely TypeScript code. Knows how to handle various SQL dialects and complex query structures. Use when this capability is needed.

tomevault-io Bundle

Use when writing raw SQL queries with GRDB, complex joins, ValueObservation for reactive queries, DatabaseMigrator patterns, query profiling under performance pressure, or dropping down from SQLiteData for performance - direct SQLite access for iOS/macOS

tomevault-io Bundle

Golang Expert

tomevault-io Bundle

Master AI-powered natural language data exploration with Lumen AI. Use this skill when building conversational data analysis interfaces, enabling natural language queries to databases, creating custom AI agents for domain-specific analytics, implementing RAG with document context, or deploying self-service analytics with LLM-generated SQL and visualizations. Use when this capability is needed.

tomevault-io Bundle

Search, query, and manage Weaviate vector database collections. Use for semantic search, hybrid search, keyword search, natural language queries with AI-generated answers, collection management, data exploration, filtered fetching, data imports from PDF/CSV/JSON/JSONL files, create example data and collection creation. Use when this capability is needed.

tomevault-io Bundle

Data file processing utilities for CSV, JSON, and text files. Provides helpers for reading, transforming, and validating structured data. Use when this capability is needed.

tomevault-io Bundle

Reference for building apps with gtfs-sqljs — a TypeScript library for loading GTFS transit data into a pluggable SQLite database (sql.js / better-sqlite3 / op-sqlite / expo-sqlite). Covers installation, adapter choice, Web Worker + Comlink usage, async query methods, GTFS-RT feeds, and caching. Use when this capability is needed.

tomevault-io Bundle

Generate comprehensive lab member rosters in both markdown and CSV formats. Analyzes member profiles, git history, and alumni information to create detailed rosters with role transitions, team assignments, and career tracking. Use when user mentions roster, team list, lab members, or updating member information. Use when this capability is needed.

tomevault-io Bundle

Write optimized JPA queries, JPQL, Spring Data specifications, and raw SQL for Spring Boot applications. Use this skill whenever the user needs to write database queries, optimize slow queries, design JPA entities with relationships, write Criteria API or Specifications, or says things like "write a query for X", "how do I join these entities", "optimize this query", "create a JPA repository method", "write a Specification for filtering", "design the entity relationships", "fix this N+1 problem". Always use this skill for any database/JPA/SQL task in Spring Boot. Use when this capability is needed.

tomevault-io Bundle

Databricks SQL SDK

tomevault-io Bundle

Use when writing, reviewing, or debugging Go code that talks to a SQL database (PostgreSQL, MySQL, MariaDB, SQLite). Covers library choice (database/sql, sqlx, sqlc, pgx, GORM trade-offs), parameterized queries, context propagation, NULL handling, scanning, transactions and isolation, connection pool tuning, and migration tooling. Apply when adding repository code, refactoring SQL, or auditing for missing rows.Close()/QueryContext.

tomevault-io Bundle

Monitor and analyze Plex Media Server usage via Tautulli analytics API. Use when the user asks to "check Tautulli", "Plex analytics", "watch statistics", "current streams", "who's watching", "Plex history", "most watched", "user activity", "library stats", or mentions Tautulli/Plex monitoring. Use when this capability is needed.

tomevault-io Bundle

Generate comprehensive database schemas with proper relations, migrations, and ORM/ODM models for PostgreSQL, MongoDB, and SQLite. Use when creating database schemas that integrate with FastAPI applications, including SQLAlchemy models for SQL databases, PyMongo/ODMantic models for MongoDB, Alembic migrations, and proper relationship definitions. Use when this capability is needed.

tomevault-io Bundle

Fast DataFrame library (Apache Arrow). Select, filter, group_by, joins, lazy evaluation, CSV/Parquet I/O, expression API, for high-performance data analysis workflows. Use when this capability is needed.

tomevault-io Bundle

Run ClickHouse queries for analytics, metrics analysis, and event data exploration. Use when you need to query ClickHouse directly, analyze metrics, check event tracking data, or test query performance. Read-only by default. Use when this capability is needed.

tomevault-io Bundle

Semantic search and summarisation across a document corpus (markdown, PDF, DOCX, XLSX). Use when needing to find information across many files, build timelines, aggregate knowledge, or answer questions about content. Trigger on phrases like "search brain", "find in my notes", "what do I know about", "summarise", "timeline of", "aggregate". Use when this capability is needed.

tomevault-io Bundle

No API KEY needed for free tier. Professional-grade cryptocurrency and stock market data integration for real-time prices, company profiles, and global analytics. Powered by Node.js with zero external dependencies. Use when this capability is needed.

tomevault-io Bundle

Architectural pattern enforcer that prevents technical debt. Use when editing code to check for anti-patterns, hardcoded secrets, SQL injection, inline styles, and other code quality issues. Automatically blocks critical violations and logs debt scores. Use when this capability is needed.

tomevault-io Bundle

Django security best practices, authentication, authorization, CSRF protection, SQL injection prevention, XSS prevention, and secure deployment configurations. Use when this capability is needed.

tomevault-io Bundle

Use this skill when the user wants to convert JSON Schema to SQL CREATE TABLE statements, transform schema definitions to database DDL, create SQL tables from JSON Schema files, or generate database schemas from API specifications. Triggers include "json schema to sql", "convert schema to sql", "create table from json schema", "json schema ddl", "schema conversion", or when working with OpenAPI, JSON Schema, or API specifications that need database tables.

tomevault-io Bundle

SQL Injection testing methodology with payloads for union, blind, time-based, and error-based attacks Use when this capability is needed.

tomevault-io Bundle

Python SQL toolkit and Object Relational Mapper (ORM). Use when working with databases in Python, defining models, building queries, managing sessions, or interacting with SQL databases using Python objects. Use when this capability is needed.

tomevault-io Bundle

Write optimized SQL for your dialect with best practices Use when this capability is needed.