List database connections in the Mode workspace.

Args: limit: Max number of results to return (default 50).

List spaces (collections) in the Mode workspace.

Args: limit: Max number of results to return (default 50).

List reports in a space. Archived reports are hidden unless include_archived.

Args: space_token: Space token (use list_spaces to find it). limit: Max number of results to return (default 50). include_archived: Also return archived reports (each has an archived flag).

Search for reports by name or description across all spaces.

Mode's REST API has no native report-search endpoint, so this fans out across every space and filters client-side (case-insensitive substring match on name and description). May be slow on large workspaces. Archived reports are skipped unless include_archived.

Args: query: Search term to match against report names and descriptions. limit: Max number of results to return (default 50). include_archived: Also return archived reports (each has an archived flag).

Get a report's details and its queries (SQL).

Args: report_token: The report token.

List recent runs for a report.

Args: report_token: The report token. limit: Max number of runs to return (default 10).

Create a new report in a space, optionally with initial SQL queries.

This is a write operation — it creates a report visible to the workspace. If any queries fail to add, the report is still created; inspect queries_added and queries_failed in the result.

Args: space_token: Space to create the report in (use list_spaces to find it). name: Report name. description: Optional report description. queries: Optional list of queries to add. Each dict should have: - raw_query (str): The SQL text. - data_source_id (int): Data source ID (use list_data_sources). - name (str, optional): Query name.

Update a report's name, description, or move it to a different space.

This is a write operation — it modifies an existing report.

Args: report_token: The report to update. name: New report name. Omit to leave unchanged. description: New description. Omit to leave unchanged. space_token: Move report to this space. Omit to leave in current space.

Archive a report, hiding it from view. Reversible with unarchive_report.

This is the safe alternative to delete_report.

Args: report_token: The report to archive.

Restore an archived report.

Args: report_token: The report to unarchive.

Add a SQL query to an existing report.

This is a write operation — it adds a new query to the report.

Args: report_token: The report to add the query to. raw_query: SQL query text. data_source_id: Data source ID (use list_data_sources to find it). name: Optional query name.

Update a SQL query in a report.

This is a write operation — it modifies an existing query.

Args: report_token: The report containing the query. query_token: The query to update (use get_report to find query tokens). raw_query: New SQL text. Omit to leave unchanged. name: New query name. Omit to leave unchanged. data_source_id: New data source ID. Omit to leave unchanged.

Get results from a report run. Defaults to the latest run.

Each query's rows are truncated to max_rows_per_query by default so a single call can't blow past the agent's context window. When a query was truncated, the result includes truncated: true and row_count: <total> so you know to re-call with a higher limit (or null) if you need all rows.

Args: report_token: The report token. run_token: Specific run token. If omitted, uses the latest succeeded run. max_rows_per_query: Max rows to return per query. Default 500. Pass null to fetch every row — can be very large (hundreds of MB) for dashboards with long time-series or wide cross-tabs.