×

Connect Microsoft Copilot to your Oracle database

Microsoft Copilot queries your Oracle data through Myriade's MCP server: with business context, read-only, under each user's access rights.

Prerequisites

• A Myriade account on app.myriade.ai (or on your self-hosted instance).
• Network access from Myriade to Oracle, with a read-only account.
• Microsoft Copilot, on a plan that allows custom MCP servers (see the note in step 2).

1. Connect Oracle to Myriade

Myriade connects to Oracle with a host, a port (1521 by default) and a service name, or a SID for older databases. The Oracle client ships in the Myriade Docker image: nothing to install. A client-side query timeout can be set per connection.

Best practice: use a dedicated user with CREATE SESSION and SELECT on the useful tables or views only.

2. Add Myriade to Microsoft Copilot

Microsoft Copilot reaches MCP servers in two places: Copilot Studio agents and GitHub Copilot in VS Code.

1. 1Take the Myriade MCP address: https://app.myriade.ai/mcp.
2. 2Copilot Studio: in your agent, Tools → Add a tool → New tool → Model Context Protocol, then paste this URL. VS Code: declare the server in .vscode/mcp.json (snippet below).
3. 3Pick OAuth 2.0 with dynamic discovery in Copilot Studio; VS Code opens the OAuth sign-in in your browser.

{ "servers": { "myriade": { "type": "http", "url": "https://app.myriade.ai/mcp" } } }

On Copilot Business and Enterprise, an org admin must first enable the “MCP servers in Copilot” policy for VS Code. In Microsoft 365 Copilot, MCP servers are added by a developer, through a declarative agent.

Self-hosted Myriade (optional): replace app.myriade.ai with your instance's host.

3. Check the connection

Ask Microsoft Copilot a few questions:

• “Which tables describe customer orders in Oracle?” The assistant searches the Myriade catalog before writing SQL.
• “What was revenue by region last quarter?” Read-only SQL, run under your access rights, saved in Myriade.
• “Did any alert fire on our KPIs this week?” The assistant reads Myriade's checks and alerts.

What Myriade enforces

• INSERT, UPDATE, DELETE, DROP… blocked; a query that cannot be parsed is rejected
• Maximum duration per query and a cap on concurrent queries
• At most 50 rows returned to the assistant
• Database visibility, team rules on tables and columns
• Protected columns stay masked, including for the assistant

Frequently asked questions