Data

Twitter X Search retrieves tweets, user profiles, followers, communities, spaces, and trends from Twitter/X via the twitterapi.io API. Use it when someone mentions Twitter, X, or tweets.

dbt Ingest maps dbt schema.yml and properties.yml models and sources into ktx semantic-layer overlays and column notes. It handles sources vs models, column data_tests, and resolves physical identifiers before writing semantic-layer sources.

Historic SQL Patterns identifies recurring cross-table analytical intents from historic SQL usage shards and emits typed pattern evidence for deterministic wiki projection. Use it when processing a patterns-input shard from the historic-sql adapter.

Historic SQL Table Digest converts a changed historic-SQL table usage bucket into typed table usage evidence for deterministic schema projection. Use it when a WorkUnit raw file is a tables/<schema>.<name>.json from the historic-sql adapter.

Ingest Triage classifies and resolves conflicts detected during data bundle ingest, including structural duplicates, definitional contradictions, near-duplicate clusters, re-ingest changes, and evictions. Use it before writes that could collide with existing artifacts in a semantic layer.

KTX Analytics queries a KTX-connected database using MCP tools for discovery, semantic-layer analysis, and raw read-only SQL to investigate metrics, explore tables, compare periods, and explain findings. Use it for any data-analysis request against a configured KTX connection.

Live Database Ingest creates or updates semantic-layer sources from a live database schema snapshot, preserving table and column comments. Use it when an ingest work unit contains raw database table JSON under raw-sources.

Looker Runtime Ingest extracts durable knowledge from Looker dashboards, Looks, and explores. Use it when WorkUnits contain raw files under explores/, dashboards/, or looks/ to derive semantic-layer contributions and wiki knowledge.

LookML Ingest maps LookML views, models, and explores into ktx semantic layer sources, covering overlays, standalones, provenance tagging, and decision rules. Use it when a task contains .lkml content or requires writing semantic layer sources from LookML.

Metabase Ingest converts Metabase questions, models, and metrics into ktx Semantic Layer source definitions. It maps result metadata to KSL column types, detects PK/FK relationships, deduplicates near-duplicates, decomposes pre-aggregations, and handles join-graph connectivity.

MetricFlow Ingest maps MetricFlow semantic_models and metrics into ktx semantic layer sources, flattening inheritance and translating metric types like derived, ratio, cumulative, and conversion. Use it when working with .yml/.yaml files containing top-level semantic_models or metrics.

Notion Synthesis reads staged Notion pages, databases, and evidence chunks to write durable wiki pages and semantic-layer sources for business knowledge. Use it when a WorkUnit contains Notion raw files or clustered Notion evidence.