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?
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
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
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
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
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
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
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
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.
Source: help.tableau.com/current/api/vizql-data-service/en-us/docs/vds_get_data_source_info.html · checked Oct 26, 2026 · quoted by Claude
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
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
Alteryx
Partly
Quoted from Alteryx’s docsLists measures for a dataset.
Source: help.alteryx.com/aac/en/agent-studio/alteryx-mcp-server/alteryx-mcp-server-toolsets.html · checked Oct 26, 2026 · quoted by Claude
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
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
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
Streamlit