Available Tools

Creates a new discovery to log a finding. A notification record is always created. Set notify to false to skip fanning out notifications through enabled delivery channels — notifications are sent by default.

Creates a new funnel insight. Returns the insight ID and slug.

Store insights, learnings, and procedures discovered during data analysis. Use episodic for analysis sessions/findings, semantic for data facts/patterns, procedural for query techniques/workflows. Higher importance decays slower.

Creates a new segmentation insight. Returns the insight ID and slug.

Creates a new semantic model-based insight. Returns the insight ID and slug.

Creates a new SQL-based insight. Returns the insight ID and slug.

Create a task to automatically monitor charts or dashboards on a recurring schedule.

Analyzes a DuckLake SQL query and returns execution plan information including table scan estimates and file statistics. Use this to understand query performance characteristics before execution.

Returns a markdown description of a lakehouse catalog (altertable database or external connection): physical schemas, tables, columns and semantic dimensions, semantic measures, and relations. Pass catalog_name from list_catalogs; the tool resolves connection vs database.

REQUIRED FIRST STEP: CALL THIS BEFORE ANY OTHER TOOL. Returns information about the current organization, environment, and knowledge-entry context the agent must use to decide what to do and how to behave. Skipping this risks acting on the wrong scope or missing mandatory specific guidance.

Lists all data catalogs in the current environment: external connections (Postgres, Snowflake, etc.) and Altertable databases. Each entry includes catalog_name (use with get_catalog), name, and engine. For full schema, tables, and columns, call get_catalog with that catalog_name.

Retrieves events along with statistics for a given time period. Returns aggregated event data including event names, counts, and metadata. Supports optional query filtering to search specific events.

Lists all insights (charts) in the organization. Insights are saved queries that can be SQL, semantic, segmentation, or funnel type. Supports optional query filtering to search by title or description. Returns insight metadata including slug, title, description, chart kind, and creation/update timestamps.

Retrieves available semantic models for the organization. Semantic models define data structures that can be queried using semantic insights. Optionally filters by connection slug to show models for a specific database connection. Returns model definitions with slugs, fully qualified table names, and schema definitions.

Retrieves user traits (attributes) data. Returns user attribute data that can be used for segmentation, personalization, and analysis. User traits include properties like email, name, subscription tier, and custom attributes.

Previews the results of an insight without creating a permanent insight. Dispatches on the kind field and expects the matching definition: funnel + funnel_definition, segmentation + segmentation_definition, retention + retention_definition, semantic + semantic_definition, or sql + sql_statement. Funnel, segmentation and retention kinds also require from, to, and interval. Useful for testing configurations before committing to creation.

Executes one or more SQL queries directly against the lakehouse database using DuckLake dialect. Returns query results as structured data with rows and column metadata.

Search the Altertable platform documentation for information about features, insight types, usage and best practices. Returns relevant documentation snippets with titles, content, and URLs.

Search for memories with relevance-based ranking (considers recency, access patterns, and importance). Supports both semantic (vector) and keyword search. Note: Each search increments access_count on returned memories. Tip: Use this tool proactively at the start of a workflow to auto-recall relevant context.

Find relevant Altertable agent skills for a task using semantic similarity. Returns the best-matching skills plus guidance on when to use them. Call this before starting work when you need to discover applicable agent capabilities.

Takes a screenshot of a dashboard or insight via its shared link. Returns an inline image for visual verification. Auto-creates a short-lived share token if none exists.

Validates whether a SQL statement is valid DuckDB dialect

Retrieves a dashboard by its slug. Returns title, description, tags, and ordered widgets (chart/text/section with grid positions). Includes a flat list of referenced insight slugs. Does NOT execute queries — use view_insight for that.

Executes an insight query and returns results. Works with SQL, semantic, segmentation, and funnel insights. For large results, summarize key findings rather than echoing raw data.

Fetch the 50 most popular pages for a given environment and time period.