Agent access · Context and connections
Which BI tools let agents list what exists?
14 of 15 tools do, according to their public docs.
Yes: Databricks, Snowflake, Omni, Hex, Sigma, BigQuery, Looker, Tableau, Power BI, Metabase, Alteryx, MotherDuck, Mode, Redshift.
The question we asked: Can an outside agent list what exists, dashboards, metrics, tables, without being told what to look for?
Grading standard
A documented way to enumerate objects, not just fetch one by id. Reading a named dashboard is a different row; this is finding out the dashboard is there.
Databricks
Yes
Quoted from Databricks’s docsList all dashboards.
Source: docs.databricks.com/aws/en/dev-tools/cli/reference/lakeview-commands · checked Oct 26, 2026 · quoted by Claude
Snowflake
Yes
Quoted from Snowflake’s docsList all tables in my current schema
Source: docs.snowflake.com/en/user-guide/cortex-code/cortex-code-claude-code · checked Oct 26, 2026 · quoted by Claude
Omni
Yes
Quoted from Omni’s docsReturns a list of available models and their IDs, which the MCP client uses to select which model to query.
Source: docs.omni.co/ai/mcp/tools · checked Oct 26, 2026 · quoted by Claude
Hex
Yes
Quoted from Hex’s docsList all viewable projects, sorted by most recently created first.
Source: learn.hex.tech/docs/api-integrations/api/reference · checked Oct 26, 2026 · quoted by Claude
Sigma
Yes
Quoted from Sigma’s docsBrowse and list collections of documents, helping you to quickly locate documents across large organizations.
Source: help.sigmacomputing.com/docs/use-sigma-mcp-server · checked Oct 26, 2026 · quoted by Claude
BigQuery
Yes
Quoted from BigQuery’s docsList table ids in a BigQuery dataset or BigLake namespace.
Source: docs.cloud.google.com/bigquery/docs/reference/mcp · checked Oct 26, 2026 · quoted by Claude
Looker
Yes
Quoted from Looker’s docsReturns an array of abbreviated dashboard objects.
Source: cloud.google.com/looker/docs/reference/looker-api/latest/methods/Dashboard/all_dashboards · checked Oct 26, 2026 · quoted by Claude
Tableau
Yes
Quoted from Tableau’s docsReturns the workbooks on a site.
Source: help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_workbooks_and_views.htm · checked Oct 26, 2026 · quoted by Claude
Power BI
Yes
Quoted from Power BI’s docsReturns a list of dashboards from the specified workspace.
Source: learn.microsoft.com/en-us/rest/api/power-bi/dashboards/get-dashboards-in-group · checked Oct 26, 2026 · quoted by Claude
Metabase
Yes
Quoted from Metabase’s docsThe MCP server gives your agent tools for searching, browsing, querying, and creating content in your Metabase.
Source: www.metabase.com/docs/latest/ai/mcp · checked Oct 26, 2026 · quoted by Claude
Alteryx
Yes
Quoted from Alteryx’s docsSearches cataloged Alteryx One asset types, such as workflows, datasets, macros, connections, plans, schedules, and folders. Supports free-text queries, entity-type restrictions, field filters, sorting, and pagination.
Source: help.alteryx.com/aac/en/agent-studio/alteryx-mcp-server/alteryx-mcp-server-toolsets.html · checked Oct 26, 2026 · quoted by Claude
MotherDuck
Yes
Quoted from MotherDuck’s docsExplore database schemas, tables, and columns
Source: motherduck.com/docs/sql-reference/mcp · checked Oct 26, 2026 · quoted by Claude
Mode
Yes
Quoted from Mode’s docsTo return a list of all reports in a given Collection, send a GET request to the reports resource.
Source: mode.com/developer/api-reference/analytics/reports · checked Oct 26, 2026 · quoted by GPT
Redshift
Yes
Quoted from Redshift’s docsList the tables in a database.
Source: docs.aws.amazon.com/redshift-data/latest/APIReference/API_ListTables.html · checked Oct 26, 2026 · quoted by Gemini
Streamlit