exploratory-data-analysis
Perform systematic exploratory data analysis to understand dataset structure, distributions, relationships, and anomalies before modeling.
Perform systematic exploratory data analysis to understand dataset structure, distributions, relationships, and anomalies before modeling.
Run read-only BigQuery SQL queries via CLI. Use when user needs to query BigQuery datasets, run SQL against Google BigQuery, or retrieve data from BigQuery tables.
Create, execute, and roll back versioned database schema migrations using tools like Alembic, Prisma Migrate, Flyway, and Knex.
Creates and modifies PostgreSQL database migrations for xmtpd using golang-migrate. Use when adding or altering tables, columns, indexes, functions, triggers, constraints, or partitions, or when the user mentions migrations or schema changes.
Create, schedule, and verify database backups with support for full, incremental, and point-in-time recovery strategies.
Design normalized database schemas with tables, relationships, indexes, and constraints for any application domain.
Analyze, diagnose, and optimize slow SQL queries using EXPLAIN plans, indexing strategies, query rewriting, and ORM tuning.
Generate optimized SQL queries from natural language requests, supporting SELECT, JOIN, GROUP BY, window functions, CTEs, and subqueries.
Run read-only SQL queries against a PostgreSQL database via CLI. Use when user needs to query, inspect, or retrieve data from a Postgres database.
Classify expenses by category, department, and tax deductibility from transaction data
Extract, validate, and categorize invoice data against purchase orders and GL codes
End-of-session ritual that syncs Claude Code session artifacts to an Obsidian vault. Chains breadcrumbs, retrospective, note creation, and daily driver into a single flow. Creates session notes, updates daily note, and leaves breadcrumbs. Activates on "sync to obsidian", "save session", "end session", or when user wraps up significant work in a vault-connected project.
Create text-based wireframes at low, mid, and high fidelity with component inventories, interaction annotations, and responsive breakpoint specifications.
RxJS patterns as used in the Nuclia frontend monorepo — covering Subject type selection, flattening operator decisions (switchMap vs concatMap vs mergeMap), combination operators (combineLatest vs forkJoin vs withLatestFrom), error handling, shareReplay placement, cleanup strategies, debounce conventions, Angular signal interop, and import hygiene. Activate this skill for ANY task that touches observable pipelines, service state streams, RxJS subscriptions, or operator choices in Angular apps or libs. Do not wait to be asked about "RxJS patterns" specifically — if the task writes or modifies a .pipe(), creates a Subject, adds a subscription in a service or component, uses catchError/switchMap/forkJoin, or asks "which operator should I use here?", this skill applies. Also use when debugging streams that never emit, emit multiple times unexpectedly, or cause memory leaks. This skill covers Angular libs and apps only; it does not cover search-widget (Svelte) or rao-widget (React).
Use when a task needs capabilities BEYOND basic tools (Read/Grep/Glob/Bash) - semantic search, AI analysis, research, image generation, etc.
Automate repetitive tasks and workflows using scripting, file watchers, scheduled jobs, CI triggers, and API polling to eliminate manual toil.
Define, deploy, and manage cloud infrastructure as code using tools like Terraform, Pulumi, CloudFormation, and CDK, ensuring consistency, repeatability, and version control.
Deploy, manage, and scale applications on Kubernetes clusters using manifests, Helm charts, and autoscaling configurations.
End-of-day ritual skill that reads Ian's daily Obsidian journal note, synthesizes the day, fills in the Day in Review section, advises on tomorrow, and keeps Today.md current. Trigger when Ian says things like: "wrap up my day", "daily wrap", "end of day", "let's review today", "help me close out today", "day in review", "how'd my day go", or any similar end-of-day journaling prompt. Also trigger if Ian says "update my Today note" or "update Today.md". This skill covers work AND personal life — prod incidents, vendor negotiations, relationship, health, home, mental state, all of it.
Create, edit, and export draw.io diagrams via CLI with real-time browser preview. Use when user needs to create flowcharts, diagrams, or edit mxGraphModel XML diagrams.