BC Observatoryunofficial, made by waldo
community postIntegration & APIscommunity - not Microsoftreviewed - checked by Opus

Data query tools in the Business Central MCP server: a hands-on test guide

The Data Query Tools feature on the Business Central MCP server enables agents to query tables, read schemas, and run AL queries without requiring pre-published API pages, expanding ad hoc analysis capabilities while maintaining read-only access based on user permissions.

Open in Claudetag-blogger-com-1999-blog-1492436440038408053-post-693116706571215184--4c47cc37c6.md

post Mohana's Dynamics NAV & BC blog

Mohana Yadav · 2026-10-07 · 1,066 words · about 5 min

"With the data query tools, an agent can answer a question nobody built an object for, which describes most ad hoc analysis."
Show the post hereRead on Mohana's Dynamics NAV & BC blog

Key points

  • Agents can discover tables, inspect their fields and relations, write AL queries, compile them, and execute them through four system tools
  • Eliminates the need for development requests and deployments for one-off queries by operating within user permissions and AL query constraints
  • Read-only access prevents data creation, modification, or deletion through the query interface
  • Available as a preview feature in 2026 release wave 2 for Business Central online
  • Setup requires creating an MCP server configuration with the Data Query Tools feature enabled and connecting it through VS Code or other MCP clients

Quotes

  • “With the data query tools, an agent can answer a question nobody built an object for, which describes most ad hoc analysis.” (Highlights the practical value of eliminating the need for pre-built API pages for every possible query scenario)
  • “The boundaries become the permissions the signed-in user already has and what an AL query can express.” (Clarifies that security and functionality constraints are determined by existing user permissions rather than new limitations)
  • “It is read-only, so nothing can be created, changed or deleted through it.” (Establishes a fundamental safety characteristic that makes the feature suitable for analysis without data modification risks)

AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

  • page “Model Context Protocol (MCP) Server Configurations”

Not found in BC28-30: page “Model Context Protocol (MCP) Server Configurations”.

Context

  • Features: Data Query Tools, bc_data_find_tables, bc_data_get_table_schema, bc_data_get_table_relations, bc_data_query, MCP server, OAuth 2.0 authentication, VS Code integration
  • Versions: 2026 release wave 2

Source: Mohana’s Dynamics NAV & BC blog, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.