Devart MCP Server for Oracle (ADO.NET) — Claude Code MCP server
Connects AI clients to Oracle databases using Devart dotConnect ADO.NET. Generates structured queries and pulls records using plain language prompts.
Open on GitHubWhat Devart MCP Server for Oracle (ADO.NET) does
The server acts as a bridge between an AI assistant and an Oracle instance. When a prompt asks for information, the server translates that intent into database queries, runs them through the dotConnect data provider, and hands structured records back to the agent. It handles read and write requests while honoring the underlying database schema.
Building the server requires the .NET 8 SDK. Running dotnet publish on Devart.AI.McpServer.AdoNet.Oracle.csproj fetches the required NuGet package automatically during compilation. Connection parameters reside in mcpserver.json, which supports both stdio and http transport modes.
The ADO.NET connection string demands a valid License Key alongside database host details. Without that key, dotConnect refuses to establish the connection.
What it helps with
- query Oracle tables using conversational prompts
- extract database metrics without writing raw SQL queries
- connect coding assistants to Oracle via stdio or http transports
Example prompts for the agent
- List recent transactions from the
ORDERStable for this week. - Inspect the
CUSTOMERStable schema and report columns that allow nulls. - Calculate total revenue by department from our Oracle instance.
How to install Devart MCP Server for Oracle (ADO.NET)
Install
The MCP registry has no launch command for it: see the repository README
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Devart MCP Server for Oracle (ADO.NET)
How to install and build Devart MCP Server for Oracle?
Clone the repository and compile it with dotnet publish Devart.AI.McpServer.AdoNet/Devart.AI.McpServer.AdoNet.Oracle/Devart.AI.McpServer.AdoNet.Oracle.csproj -c ReleaseOracle /p:TargetFramework=net8.0. Next, configure database credentials in mcpserver.json and point your client configuration to the generated executable.
What does this MCP server do?
It enables AI tools to run read and write operations against Oracle databases through Devart dotConnect. The tool handles translation from natural prompts into structured queries and returns clean output to the assistant.
What prerequisites are required for the ADO.NET build?
You need the .NET 8 SDK installed on your machine. In addition, your mcpserver.json connection string must include a valid License Key to authorize the dotConnect provider.
