# Analytics

Schema, SQL, saved queries, dashboards, and published reports.

## Workflow

1. `bi_list_tables` — then `bi_describe_table` before writing SQL.
2. `bi_query` — SELECT only, with a LIMIT. Do not add a tenant filter; row-level security is applied on the server.
3. `bi_save_query` only when the operator asks to save.
4. `bi_create_dashboard` and `bi_add_widget` — or a published report: the `create_bi_report` prompt, then `bi_publish_report`.

## Topics

- `bi_help("sql-performance")` — indexes, FILTER counts, parameter filters.
- `bi_help("widget-parameters")` — dashboard parameters, two steps.
- `bi_help("saved-queries")` — save, modify, archive, favorite.
- `bi_help("dashboards")` — dashboard and widget CRUD.
- `bi_help("charts")` — chart types.
- `bi_help("windows")` — conversation windows in SQL.

Pass `project_id` on every call. Check `project.display_name` before a write. Details: `bi_help("projects")` on the HTTP MCP server.