---
id: post/mohana-blog/tag-blogger-com-1999-blog-1492436440038408053-post-693116706571215184--4c47cc37c6
type: post
title: "Data query tools in the Business Central MCP server: a hands-on test guide"
summary: 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.
tier: community
language: en
tags:
  - mcp server
  - data query tools
  - agents
  - al queries
  - api alternative
  - read-only access
  - ad hoc analysis
system: integration
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:46:09.790Z"
  flags: []
generated:
  at: "2026-10-07T22:42:12.892Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 97676c27e65c02a017a9a4214c6b2d25e97d49ddd99bb9c0d1a76264692f333c
evidence:
  - kind: blog
    url: http://mohana-dynamicsnav.blogspot.com/2026/10/data-query-tools-in-business-central.html
    title: "Data query tools in the Business Central MCP server: a hands-on test guide"
    date: "2026-10-07"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: http://mohana-dynamicsnav.blogspot.com/2026/10/data-query-tools-in-business-central.html
    title: "Data query tools in the Business Central MCP server: a hands-on test guide"
    date: "2026-10-07"
    commit: null
    t: null
    quote: With the data query tools, an agent can answer a question nobody built an object for, which describes most ad hoc analysis.
  - kind: blog
    url: http://mohana-dynamicsnav.blogspot.com/2026/10/data-query-tools-in-business-central.html
    title: "Data query tools in the Business Central MCP server: a hands-on test guide"
    date: "2026-10-07"
    commit: null
    t: null
    quote: The boundaries become the permissions the signed-in user already has and what an AL query can express.
  - kind: blog
    url: http://mohana-dynamicsnav.blogspot.com/2026/10/data-query-tools-in-business-central.html
    title: "Data query tools in the Business Central MCP server: a hands-on test guide"
    date: "2026-10-07"
    commit: null
    t: null
    quote: It is read-only, so nothing can be created, changed or deleted through it.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: tag:blogger.com,1999:blog-1492436440038408053.post-693116706571215184
source_id: mohana-blog
source_name: Mohana's Dynamics NAV & BC blog
url: http://mohana-dynamicsnav.blogspot.com/2026/10/data-query-tools-in-business-central.html
published_at: "2026-10-07T16:02:47.000Z"
author: Mohana Yadav
full_text: false
words: 1066
quotes:
  - text: With the data query tools, an agent can answer a question nobody built an object for, which describes most ad hoc analysis.
    why_it_matters: Highlights the practical value of eliminating the need for pre-built API pages for every possible query scenario
  - text: The boundaries become the permissions the signed-in user already has and what an AL query can express.
    why_it_matters: Clarifies that security and functionality constraints are determined by existing user permissions rather than new limitations
  - text: It is read-only, so nothing can be created, changed or deleted through it.
    why_it_matters: Establishes a fundamental safety characteristic that makes the feature suitable for analysis without data modification risks
code_objects_mentioned:
  - page Model Context Protocol (MCP) Server Configurations
systems:
  - integration
  - development
  - platform
versions_mentioned:
  - 2026 release wave 2
preview:
  embeddable: true
  frame_url: null
  image: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirzuPJ-PVX5SqJ4FF8StSnGJMTAV3X50PxZhWBSVwsbPDc_CEJJCyw0X_dmboxns8go1pYgng_-R05azj6OUnZ1eDVnbjhB2zfOdRql3sarCaSOt9ebZWBF7hbgV2czkdrWwamH42uiaSwRyH_O6Dy-8kpGW89YnFUiCHp2a5JD-2udNE-cgBAHjf9DWp0/w1200-h630-p-k-no-nu/image.png
  image_alt: null
  image_w: null
  image_h: null
  site_name: null
  favicon: https://mohana-dynamicsnav.blogspot.com/favicon.ico
  probed_at: "2026-10-07T21:11:56.818Z"
---

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

[Read the post](http://mohana-dynamicsnav.blogspot.com/2026/10/data-query-tools-in-business-central.html) · Mohana's Dynamics NAV & BC blog (Mohana Yadav) · 2026-10-07 · 1066 words · tier community · reviewed (checked by Opus)

> 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.

## 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.