Saved content, sharing & reuse · Building and maintaining assets

Which BI tools let outside agents read dashboards?

9 of 15 tools do, according to their public docs, and 5 partly.

Yes: Databricks, Omni, Sigma, Looker, Tableau, Power BI, Metabase, MotherDuck, Mode. Partly: Snowflake, Hex, BigQuery, Alteryx, Streamlit.

The question we asked: Can an outside coding agent read the contents of existing BI content?

Prompt your agent about thisClaudeChatGPT
Grading standard

An outside agent can read the contents of existing BI content (its charts, queries and filters) through the vendor's interface. Analyst work only is partly. Listing what exists is the agent-discovery row.

Databricks

Yes
Quoted from Databricks’s docsThe Workspace Export API GET /api/2.0/workspace/export allows you to export the contents of a dashboard as a file.
Source: docs.databricks.com/aws/en/dashboards/tutorials/workspace-dashboard-api · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Snowflake

Partly
Quoted from Snowflake’s docsThese interfaces return metadata, not content.
Source: docs.snowflake.com/en/user-guide/snowflake-artifacts · checked Oct 26, 2026 · quoted by Gemini
Claude partly · GPT yes · Gemini partly

Omni

Yes
Quoted from Omni’s docsEach query's response also includes the field names it selects (fields) and already filters on (filterFields), so you can copy the exact field names a runSavedQuery filter override needs to target.
Source: docs.omni.co/ai/mcp/tools · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Hex

Partlypreview
Quoted from Hex’s docslist_cells: Read the cells in a project's draft version
Source: learn.hex.tech/docs/api-integrations/mcp-server · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT yes · Gemini partly (preview)

Sigma

Yespreview
Quoted from Sigma’s docsThe endpoint returns the workbook metadata, the documentVersion the representation was read from, and the code representation in the contents field.
Source: help.sigmacomputing.com/docs/manage-workbooks-as-code · checked Oct 26, 2026 · quoted by Claude
Claude yes (preview) · GPT yes (preview) · Gemini yes (preview)

BigQuery

Partly
Quoted from BigQuery’s docsTo manage BigQuery Studio saved queries by using the BigQuery API:
Source: docs.cloud.google.com/bigquery/docs/manage-saved-queries · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Looker

Yes
Quoted from Looker’s docsGet information about a dashboard
Claude yes · GPT yes · Gemini yes

Tableau

Yes
Quoted from Tableau’s docsThe Metadata API surfaces the content and assets that comprise your Tableau Cloud site or Tableau Server, the content and asset roles, and how the content and assets relate to each other.
Source: help.tableau.com/current/api/metadata_api/en-us/docs/meta_api_model.html · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Power BI

Yespreview
Quoted from Power BI’s docsThe Get Report Metadata tool retrieves the high-level schema of a Power BI report, including workspace information, semantic model details, pages, visual information, and filters.
Source: learn.microsoft.com/en-us/power-bi/developer/mcp/remote-mcp-server-get-started · checked Oct 26, 2026 · quoted by Claude
Claude yes (preview) · GPT yes (preview) · Gemini yes (preview)

Metabase

Yes
Quoted from Metabase’s docsmb logs in to a Metabase instance and lets you or an AI agent read and write content over the Metabase API: questions, dashboards, collections, transforms, and more.
Source: www.metabase.com/docs/latest/installation-and-operation/metabase-cli · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Alteryx

Partly
Quoted from Alteryx’s docsYou can work only with Designer workflows when you have access to them.
Claude partly · GPT yes · Gemini partly

MotherDuck

Yes
Quoted from MotherDuck’s docsRead a specific Dive by ID, including its full component code
Source: motherduck.com/docs/sql-reference/mcp/dives/read-dive · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Mode

Yes
Quoted from Mode’s docsYou can use this resource to either get a single Chart or list of all Charts for a given Report’s Query in your Mode Workspace.
Source: mode.com/developer/api-reference/analytics/charts · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Redshift

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Streamlit

Partly
Quoted from Streamlit’s docsThe provided class, AppTest, simulates a running app and provides methods to set up, manipulate, and inspect the app contents via API instead of a browser UI.
Source: docs.streamlit.io/develop/api-reference/app-testing · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly