Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables

Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation

This skill should be used when the user asks to "research code", "how does X work", "where is Y defined", "who calls Z", "trace code flow", "find usages", "review a PR", "explore this library",...

Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention policies, and continuous aggregates. Instructions for selecting:...

Configure LLM providers, use fallback models, handle streaming, and manage model settings in PydanticAI. Use when selecting models, implementing resilience, or optimizing API calls.

Find unused functions and dead code in the codebase

Store a learning, pattern, or decision in the memory system for future recall

Code quality checks, formatting, and metrics via qlty CLI

Resume work from handoff document with context analysis and validation

Choose the right search tool for each query type

Async REPL Protocol

Deterministic router for math cognitive stack - maps user intent to exact CLI commands

Spawn Agentica multi-agent patterns

Environment Triage

Scrape web pages and extract content via Firecrawl MCP

TDD workflow for migrations - orchestrate agents, zero main context growth

Search Tool Hierarchy

Guide to the math cognitive stack - what tools exist and when to use each

Goal-based workflow orchestration - routes tasks to specialist agents based on user goals

Computational geometry with Shapely - create geometries, boolean operations, measurements, predicates