timescale

Enrich event booth-scan lead CSVs with Common Room firmographics, score them by ICP fit and conversation heat, flag Tiger Data customers, and produce a tiered xlsx for SDR follow-up. Use this skill when the user asks to enrich event leads, score booth scans,…

Run a structured 18-check QA review on a marketing or lifecycle email proof before it ships. Use this skill when the user asks to QA an email, review an email proof, check an email before sending, audit email quality, or validate a HubSpot proof. Also trigger…

Remove AI writing patterns ('slop') from text to make it sound natural and human-written. Use this skill when the user asks to 'de-slop', 'remove AI tells', 'remove LLM tells', 'make this sound less AI', 'make this sound less like an LLM', 'make this more…

Convert blog posts and Tiger Den content into native long-form articles for LinkedIn, X (Twitter), or both — with matching social posts. Produces platform-appropriate outputs: LinkedIn gets an SEO title, SEO description, article body with closing CTA, and a…

Verify factual claims in a finished SEO article draft via web search. Use after de-slop and before publishing. Produces a structured claim-check report file alongside the article — does not modify the article itself. Trigger when the seo-writer pipeline…

Write SEO-optimized articles from a brief with automated Tiger Docs verification, competitive fact-checking, internal link discovery, and auto-triggered content review. Use this skill when the user says 'SEO article', 'SEO content', 'GEO article', 'AEO…

Plan social media campaigns and draft individual posts for LinkedIn and X (Twitter), including repurposing existing content into platform-native social posts. Use this skill when the user asks to create a social media calendar, plan a LinkedIn content series,…

Plan and write complete event campaign briefs for Tiger Data -- event overview, full campaign copy (landing pages, emails, social posts, ads, banners, newsletters), and KPI tracking. Use this skill when the user asks to plan an event campaign, create an event…

Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases. **Trigger when user asks to:** - Test a schema migration before applying it to production - Add,…

Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. **Trigger when user asks to:** - Design or modify PostgreSQL tables, schemas, or data…

Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications

Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL -…

Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series…

Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with…

Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search. **Trigger when user asks to:** - Store or search vector embeddings in PostgreSQL - Set up semantic search, similarity search, or…

Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). **Trigger when user asks to:** - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval -…

Update workflow implementation from its embedded description. Use this after modifying workflow or node descriptions.

Collaborative workflow design - guides users through creating well-structured crayon workflows with embedded descriptions.

Generate integration nodes for external APIs (Salesforce, HubSpot, etc.). Creates typed function nodes with authentication and error handling.

Refine node definitions - determines HOW each node is implemented (SDKs, libraries, input/output structures, tools, guidelines).

How to trigger workflows and nodes. Covers MCP tools (run_workflow, run_node), HTTP webhooks (async/sync), authentication, and cron scheduling.

This skill lives in a dot-prefixed directory and must never be loaded by the local_collection loader.

First collection skill

Second collection skill

First test skill

Second test skill

Run this repo's checks (build, prose lint) and open a draft PR using the repo's PR template. Use when the user says "create a PR", "open a PR", "let's PR this", "submit this", or any variation of wanting to submit doc changes for review.

Pull recent content from Tiger Den (Tiger Data's marketing content hub), match it to docs pages, and draft learnMore right-rail cards on a review branch. Use for the recurring "add new external links to the docs" task, or when asked to refresh learnMore cards…

Write an integration guide for the Tiger Data Docs site following established conventions. Use when documenting how to connect a third-party tool (database client, BI tool, streaming platform, observability stack, ETL connector, etc.) to Tiger Cloud or…

Write a tutorial for the Tiger Data Docs site following established conventions. Use when creating a new tutorial, cookbook, or step-by-step guide for the /build/examples section — especially for database, search, AI, or data engineering topics.

Apply the constants from src/constants.ts to a docs page — scan the page, swap every literal that matches a constant value (PostgreSQL, Tiger Cloud, TimescaleDB, hypertable, chunk, columnstore, service, and so on) for its {C.X} constant in the correct MDX/JSX…

Run unit tests for one or all collection clients and report results

Static review of collection-client code against the UNS data contract in CLAUDE.md

Run end-to-end pipeline validation — query TimescaleDB after collection and report

Validate that a tutorial follows the write-tutorial format and that all code runs correctly. Use when reviewing, finalizing, or QA-ing a cookbook/tutorial before shipping. Checks README structure, file completeness, code runnability, and consistency.

Write a consistent, step-by-step technical tutorial. Use when creating a new cookbook, guide, or walkthrough — especially for database, search, or data engineering topics. Produces a README, supporting scripts, and a setup file following a proven structure.

Design a forecast store schema on Postgres/TimescaleDB — the tables, keys, defaults, and queries for storing forecasts with leakage-free backtesting, reproducible evaluation, and vintage history. Use when asked to store forecasts/predictions, backtest without…

Provision and operate a forecast store (the forecast-store convention) on Postgres/TimescaleDB — generate/apply the schema, register series, and run the canonical as-of and evaluation queries. Use for any work against a forecast store in this repo, including…

How to discover, read, write, and search data in a TigerFS-mounted PostgreSQL database using file tools.

Information and guidelines for building custom skills for the MCP server.

Author Sigma detection rules, correlation rules, filter rules, and processing pipelines from natural language descriptions. Covers the full Sigma v2.1.0 specification including logsource, detection blocks, field modifiers, condition expressions,…

Use the timecalc MCP server for reliable date, calendar, time-zone, instant, and duration calculations. Activate when a user asks about now or today, adds or subtracts dates or durations, calculates elapsed or calendar time, compares dates or instants,…