The server exposes the following tools to AI clients:
| Tool | Description |
|---|
| get_context | Get system context including event names, funnel guidance, and date hints |
| get_query | Generate business analytics queries for clickstream data (PageView, AddToCart, Purchase, etc.) |
| run_query | Execute SQL queries against AWS Athena |
| get_result | Retrieve query results (default 50 rows) |
| get_status | Check the status of a running Athena query |
| optimize_query | Auto-add smart defaults for date and application filters |
| get_query_cost | Get detailed cost information for a query execution |
| Tool | Description |
|---|
| list_tables | List tables and views in an Athena schema |
| describe_table | Get column names and data types for a table |
| discover_pipeline_schemas | Discover all pipeline schemas with columns, primary keys, and row counts |
| validate_pipeline_table | Validate if a pipeline table exists and contains data |
| get_pipeline_deduplication_hints | Get deduplication guidance for pipeline data |
| Tool | Description |
|---|
| fb_get_campaigns / fb_get_ad_sets / fb_get_ads | Facebook Ads campaign hierarchy with performance metrics |
| fb_get_insights / fb_get_audiences | Facebook Ads analytics and audience data |
| gads_get_campaigns / gads_get_ad_groups / gads_get_ads | Google Ads campaign hierarchy with performance metrics |
| gads_get_insights / gads_get_audiences | Google Ads analytics and audience data |
| tt_get_campaigns / tt_get_ad_groups / tt_get_ads | TikTok Ads campaign hierarchy with performance metrics |
| tt_get_insights / tt_get_audiences | TikTok Ads analytics and audience data |
| Tool | Description |
|---|
| commerce_get_products | Retrieve products from connected commerce store |
| commerce_list_orders / commerce_get_order | Query and retrieve order details |
| commerce_get_capabilities | Get supported capabilities of the connected commerce provider |
| shopify_get_products / shopify_get_order / shopify_list_orders | Shopify-specific product and order queries |
| Tool | Description |
|---|
| generate_dashboard | Generate interactive HTML dashboards from query results |
| send_email | Email dashboard or analytics reports to authenticated users |
| api_documentation | Generate API documentation in OpenAPI, Markdown, HTML, or Postman formats |
| get_applications | List applications configured in Blotout |
