--- id: video/qs1cg-GoDeQ type: video title: "What's new: MCP Server (2026 release wave 2)" summary: "Business Central MCP server data tools in the 2026 release wave 2: four system tools (find tables, table relations, table schema, data query) let an agent build and run AL queries on BC data within the user's permissions. Also covers the new server features configuration UI and a global security toggle. Feature status is not stated." tier: official language: en tags: - mcp server - data tools - query tool - agents - al queries - copilot studio - permissions - data analysis system: copilot review: state: reviewed by: opus at: "2026-10-07T22:42:52.132Z" flags: [] generated: at: "2026-10-09T00:29:02.995Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 00cbd25a1b54fe30741c230e750ad9d9f2358ca9047629e5f14df1d341632c5c evidence: - kind: video url: https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=50s title: "What's new: MCP Server (2026 release wave 2)" date: "2026-10-01T13:04:29.000Z" commit: null t: 50 quote: have your MCP host whatever that is copilot studio vs code or other have those LLMs construct your queries then we will compile and - kind: video url: https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=121s title: "What's new: MCP Server (2026 release wave 2)" date: "2026-10-01T13:04:29.000Z" commit: null t: 121 quote: with the data query tools uh it completely depends on the permissions that you already have the tables that you have access to in - kind: video url: https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=166s title: "What's new: MCP Server (2026 release wave 2)" date: "2026-10-01T13:04:29.000Z" commit: null t: 166 quote: It takes 30 steps. It takes 2 minutes. It's a good example of a longunning agent and it comes up with a very good - kind: video url: https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=257s title: "What's new: MCP Server (2026 release wave 2)" date: "2026-10-01T13:04:29.000Z" commit: null t: 257 quote: it also looked at table relations essentially understanding how is one table connected to other tables in business central because that's how you write - kind: video url: https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=278s title: "What's new: MCP Server (2026 release wave 2)" date: "2026-10-01T13:04:29.000Z" commit: null t: 278 quote: if it compiles a query and it fails, the compilation messages you get is directly from our compiler, right? - kind: video url: https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=305s title: "What's new: MCP Server (2026 release wave 2)" date: "2026-10-01T13:04:29.000Z" commit: null t: 305 quote: since this data is based on queries that also means that this tool can basically has the power of queries and the limitations of - kind: video url: https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=348s title: "What's new: MCP Server (2026 release wave 2)" date: "2026-10-01T13:04:29.000Z" commit: null t: 348 quote: there are also limitations in queries in business central on how much data can be returned and for how long the query can run links: learn: [] objects: [] features: - feature/573312 topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: qs1cg-GoDeQ channel: yt-microsoft source_name: Microsoft Dynamics 365 Business Central (YouTube) url: https://www.youtube.com/watch?v=qs1cg-GoDeQ published_at: "2026-10-01T13:04:29.000Z" duration_s: 483 captions: full audience: - administrator - developer - functional consultant - partner chapters: - t: 0 title: Introduction to MCP Server and agenda - t: 36 title: Query tools and four new system tools overview - t: 91 title: Demo setup and data analysis capabilities - t: 152 title: Agent workflow demonstration with customer data - t: 211 title: Query execution and compilation process - t: 278 title: Limitations and use cases for data tools - t: 364 title: New UX for MCP configurations and server features - t: 434 title: Security toggle and closing remarks features: - name: Find tables tool status: ga t: 76 verified: false status_source: roadmap roadmap_ids: - "573312" - name: Table relations tool status: ga t: 76 verified: false status_source: roadmap roadmap_ids: - "573312" - name: Table schema tool status: ga t: 76 verified: false status_source: roadmap roadmap_ids: - "573312" - name: Data query tool status: ga t: 76 verified: false status_source: roadmap roadmap_ids: - "573312" - name: Generic data analysis for agents status: unclear t: 104 verified: false status_source: video - name: Server features configuration UI status: unclear t: 364 verified: false status_source: video - name: MCP server security toggle status: unclear t: 434 verified: false status_source: video objects_mentioned: - query AL query quotes: - t: 50 text: have your MCP host whatever that is copilot studio vs code or other have those LLMs construct your queries then we will compile and check: exact - t: 121 text: with the data query tools uh it completely depends on the permissions that you already have the tables that you have access to in check: exact - t: 166 text: It takes 30 steps. It takes 2 minutes. It's a good example of a longunning agent and it comes up with a very good check: exact - t: 257 text: it also looked at table relations essentially understanding how is one table connected to other tables in business central because that's how you write check: exact - t: 278 text: if it compiles a query and it fails, the compilation messages you get is directly from our compiler, right? check: exact - t: 305 text: since this data is based on queries that also means that this tool can basically has the power of queries and the limitations of check: exact - t: 348 text: there are also limitations in queries in business central on how much data can be returned and for how long the query can run check: exact --- # What's new: MCP Server (2026 release wave 2) > Business Central MCP server data tools in the 2026 release wave 2: four system tools (find tables, table relations, table schema, data query) let an agent build and run AL queries on BC data within the user's permissions. Also covers the new server features configuration UI and a global security toggle. Feature status is not stated. [Watch on YouTube](https://www.youtube.com/watch?v=qs1cg-GoDeQ) · Microsoft Dynamics 365 Business Central (YouTube) · 2026-10-01 · 8:03 · tier official · reviewed (checked by Opus) ## Overview The video shows how the Business Central MCP server can support generic data analysis. The MCP host (Copilot Studio, VS Code or another) has an LLM construct queries, and Business Central compiles and runs them. Four system tools support this: find tables, table relations, table schema and a data query tool. The agent can search tables, see how they connect, read their fields and then run an AL query without needing an API. The demo has an agent work through customer data in about 30 steps and 2 minutes, as an example of a long-running agent. The presenter notes that access depends on the user's permissions and that the tools carry the limits of AL queries, including limits on returned data and query runtime. The video also shows a new configuration UI that separates server features (data tool, APIs) and a toggle on the Copilot and Agent capabilities page to turn the MCP server feature on or off. ## Key points - Four new system tools support data analysis: find tables, table relations, table schema and data query. Enabling the data tool server feature gives you these tools. - The MCP host (Copilot Studio, VS Code or other) has the LLM construct the queries, and Business Central compiles and runs them, so APIs are not needed. - What data the agent can reach depends on the user's existing permissions, the tables the user can access, and how well the agent writes AL queries. - In the demo, the agent searches for tables, reads their schemas and table relations, and can use the Microsoft Docs MCP to learn how to write AL queries. - When a query fails to compile, the agent gets the messages straight from the AL compiler and can often fix the query itself. - Limits: the tool can do only what AL queries can do, and queries have limits on how much data comes back and how long they run. - The new server features box in MCP configurations shows which system tools each enabled feature, such as the data tool, opens up. ## Chapters - [0:00](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=0s) Introduction to MCP Server and agenda - [0:36](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=36s) Query tools and four new system tools overview - [1:31](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=91s) Demo setup and data analysis capabilities - [2:32](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=152s) Agent workflow demonstration with customer data - [3:31](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=211s) Query execution and compilation process - [4:38](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=278s) Limitations and use cases for data tools - [6:04](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=364s) New UX for MCP configurations and server features - [7:14](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=434s) Security toggle and closing remarks ## Features | Feature | Status | At | |---|---|---| | Find tables tool | generally available (roadmap [Run data queries with MCP Server](../features/573312.md)), demoed | [1:16](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=76s) | | Table relations tool | generally available (roadmap [Run data queries with MCP Server](../features/573312.md)), demoed | [1:16](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=76s) | | Table schema tool | generally available (roadmap [Run data queries with MCP Server](../features/573312.md)), demoed | [1:16](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=76s) | | Data query tool | generally available (roadmap [Run data queries with MCP Server](../features/573312.md)), demoed | [1:16](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=76s) | | Generic data analysis for agents | status not stated, demoed | [1:44](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=104s) | | Server features configuration UI | status not stated, demoed | [6:04](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=364s) | | MCP server security toggle | status not stated | [7:14](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=434s) | A status with a roadmap link comes from the Microsoft 365 roadmap feature this part of the video covers (matched by Haiku; links Opus dropped are not used); other statuses need a status word in the video itself. ## AL objects mentioned As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named. - query "AL query" at [2:17](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=137s) Not found in BC28-30: query "AL query". ## Quotes - [0:50](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=50s) "have your MCP host whatever that is copilot studio vs code or other have those LLMs construct your queries then we will compile and" - [2:01](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=121s) "with the data query tools uh it completely depends on the permissions that you already have the tables that you have access to in" - [2:46](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=166s) "It takes 30 steps. It takes 2 minutes. It's a good example of a longunning agent and it comes up with a very good" - [4:17](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=257s) "it also looked at table relations essentially understanding how is one table connected to other tables in business central because that's how you write" - [4:38](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=278s) "if it compiles a query and it fails, the compilation messages you get is directly from our compiler, right?" - [5:05](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=305s) "since this data is based on queries that also means that this tool can basically has the power of queries and the limitations of" - [5:48](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=348s) "there are also limitations in queries in business central on how much data can be returned and for how long the query can run" ## Disclaimers in the video - [5:36](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=336s) subject-to-change: If you have data questions that will kind of result in a query that is not supported in the query or even optimal then of course that will not work. - [5:48](https://www.youtube.com/watch?v=qs1cg-GoDeQ&t=348s) subject-to-change: there are also limitations in queries in business central on how much data can be returned and for how long the query can run Presenters (as heard): Kenny Pontabidan, Pushad Dvidi, Porshad.