Copilot Studio → Agents → Create blank agent → Tools → Add a tool → Add new MCP Release 29.0 This document describes the steps required to connect an Ai2000 database to Microsoft Copilot Studio as a custom MCP (Model Context Protocol) connector. Once connected, an agent can query Ai2000 data in plain English directly from within Copilot Studio. The connection is read-only and runs only SELECT queries against the database.
The setup process requires the following:
Copilot Studio is not the same product as Copilot Chat (the Copilot icon found on the Windows taskbar). This guide applies only to Copilot Studio, which is the platform used for building custom agents.
The Ai2000 MCP connector enables Microsoft Copilot Studio agents to query Ai2000 data. Copilot is an artificial intelligence system and, like all AI systems, is not perfect. Output produced by a Copilot agent - including answers, summaries, calculations, reports, charts, and any other data interpretations may contain errors, omissions, or misrepresentations of the underlying data.
Ai2000 and GCS Software LLC make no warranty, express or implied, regarding the accuracy, completeness, or reliability of any output generated by Copilot. Ai2000 and GCS Software LLC accept no liability for any loss, damage, or business decision made in reliance on Copilot-generated output, including but not limited to incorrect figures, inaccurate calculations, misclassified records, or misleading summaries.
Users are solely responsible for verifying the accuracy of any output produced by Copilot before relying on it for business, financial, operational, or reporting purposes. Critical figures should always be crosschecked against the source data within Ai2000.
Use of the Copilot Studio integration constitutes acknowledgement and acceptance of these terms.
Navigate to
https://www.microsoft.com/en-us/microsoft-365-copilot/microsoft-copilot-studio