Shared definitions · Building and maintaining assets

Which BI tools let outside AI agents read the semantic layer?

13 of 15 tools do, according to their public docs, and 1 partly.

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

The question we asked: Can an outside coding agent read your shared definitions?

Prompt your agent about thisClaudeChatGPT
Grading standard

An agent can see what a field means, its description and business definition, rather than guessing from a column called REV_AMT.

Databricks

Yes
Quoted from Databricks’s docsThe following query returns the full YAML definition for a metric view, including measures, fields, joins, and agent metadata.
Source: docs.databricks.com/aws/en/uc-semantics/metric-views/query · checked Oct 26, 2026 · quoted by GPT
Claude partly · GPT yes · Gemini yes

Snowflake

Yes
Quoted from Snowflake’s docsSemantic view to YAML: Use the SYSTEM$READ_YAML_FROM_SEMANTIC_VIEW function to export any existing semantic view to YAML.
Source: docs.snowflake.com/en/user-guide/views-semantic/yaml-vs-ddl · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Omni

Yes
Quoted from Omni’s docsExplore and inspect semantic models, topics, views, and fields
Source: docs.omni.co/developers/agent-skills · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Hex

Yes
Quoted from Hex’s docsYou can author and manage context resources outside Hex and sync them to your workspace with the Hex CLI from any environment.
Source: learn.hex.tech/docs/agent-management/context-management/context-sync · checked Oct 26, 2026 · quoted by GPT
Claude nothing found · GPT yes · Gemini yes

Sigma

Yes
Quoted from Sigma’s docsExplore data sources and documents in Sigma by asking questions about column names, definitions, and descriptions.
Source: help.sigmacomputing.com/docs/use-sigma-mcp-server · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

BigQuery

Yes
Quoted from BigQuery’s docsOptional. The field description. The maximum length is 1,024 characters.
Source: docs.cloud.google.com/bigquery/docs/reference/mcp/tools_list/get_table_info · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Looker

Yes
Quoted from Looker’s docs- read your local LookML files
Source: cloud.google.com/looker/docs/ai-assisted-development-vscode · checked Oct 26, 2026 · quoted by GPT
Claude yes (preview) · GPT yes · Gemini yes (preview)

Tableau

Yes
Quoted from Tableau’s docsdescription: The description of the field (what appears under the Lineage tab for the data source) if you have enabled data catalog.
Claude yes · GPT yes · Gemini yes

Power BI

Yes
Quoted from Power BI’s docsAn AI agent can use the Power BI Authoring MCP server to read and write Power BI semantic models.
Source: learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview · checked Oct 26, 2026 · quoted by GPT
Claude yes (preview) · GPT yes · Gemini yes (preview)

Metabase

Yes
Quoted from Metabase’s docsThe Agent API is a REST API for building headless, agentic BI applications on top of Metabase's semantic layer, scoped to an authenticated user's permissions.
Source: www.metabase.com/docs/latest/ai/agent-api · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Alteryx

Partly
Quoted from Alteryx’s docsLists measures for a dataset.
Claude partly · GPT partly · Gemini yes

MotherDuck

Yespreview
Quoted from MotherDuck’s docsRead and write Guides — markdown documents that capture your org's metric definitions, join conventions, and domain context, so agents produce accurate SQL without repetitive prompting
Source: motherduck.com/docs/sql-reference/mcp · checked Oct 26, 2026 · quoted by Claude
Claude yes (preview) · GPT yes (preview) · Gemini yes

Mode

Yes
Quoted from Mode’s docsField descriptions can be added to Datasets to build shared understanding around business and logic definition.
Source: mode.com/developer/api-reference/analytics/dataset-field-descriptions · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Redshift

Yes
Quoted from Redshift’s docsTo view comments, query the PG_DESCRIPTION system catalog.
Source: docs.aws.amazon.com/redshift/latest/dg/r_COMMENT.html · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini nothing found

Streamlit

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