OMD Powerhouse Tools
The OMD Powerhouse tool group gives the agent access to your BI dashboards, charts, and analytical data via Apache Superset and StarRocks.
Available tools
| Tool | Description |
|---|---|
get_superset_dashboards |
List all Superset dashboards (paginated) |
get_superset_dashboard_charts |
List all charts for a given dashboard |
get_superset_chart_data |
Fetch the data behind a specific chart, with optional extra filters |
sql_lab_query |
Execute a SQL query against StarRocks via Superset SQL Lab |
get_database_schema |
Retrieve the full database schema for a tenant (table names, columns, types) |
Dashboards and charts
The agent can retrieve and present dashboard and chart data in a conversational format. This is useful for:
- "What does the task completion rate look like this week?"
- "Show me the top 5 territories by visit count in Q2."
- "Pull the data from the Workforce Overview dashboard."
When fetching chart data, the agent can apply additional filters (e.g. date range, territory) on top of the chart's built-in filters.
SQL Lab queries
The sql_lab_query tool executes arbitrary SQL against the StarRocks analytical database for a given tenant. Supported tenants:
| Tenant | Identifier |
|---|---|
| Production (PPB) | ppb |
| Sandbox | sandbox |
| CWS | cws |
SQL queries are read-only. The tool returns up to 1000 rows by default (configurable via the limit parameter).
Database schema
The get_database_schema tool returns the full StarRocks schema for a tenant. This is used internally by the sql_bot workflow to give the LLM enough context to generate accurate SQL queries.
Example interactions
User: "How many tasks were completed in the Munich territory last month?"
The agent:
1. Calls get_database_schema to understand the data model.
2. Generates and executes a SQL query via sql_lab_query.
3. Presents the result conversationally.
User: "Open the Workforce Overview dashboard and show me the data for KW28."
The agent:
1. Calls get_superset_dashboards to find the dashboard ID.
2. Calls get_superset_dashboard_charts to list available charts.
3. Calls get_superset_chart_data with a KW28 date filter.
4. Summarises the results.