# Devart MCP Server for Oracle (ADO.NET)

Connects AI clients to Oracle databases using Devart dotConnect ADO.NET. Generates structured queries and pulls records using plain language prompts.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed
- Author: devart-ai-connectivity
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/devart-ai-connectivity/devart-mcp-server-oracle
- Updated: 2026-09-03
- HTML: https://affpapa.org/en/nevibecode/mcp/devart-mcp-server-for-oracle-adonet

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

## Requirements
- Environment variables: `DEVART_MCP_ORACLE_CONNECTION` — keys and tokens: ask the human for the values, never commit them or put them in shared files.

## Install

### Claude Code (native platform)

**Install**
- The MCP registry has no launch command for it: see the repository README

## When to use it
- 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
- List recent transactions from the `ORDERS` table for this week.
- Inspect the `CUSTOMERS` table schema and report columns that allow nulls.
- Calculate total revenue by department from our Oracle instance.

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89609
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89899
- [MCP Toolbox for Databases](https://affpapa.org/en/nevibecode/mcp/googleapis-mcp-toolbox-for-databases.md) — MCP server · ★ 16730
- [PostHog MCP Server](https://affpapa.org/en/nevibecode/mcp/posthog-mcp-server.md) — MCP server · ★ 40459
- [dbx](https://affpapa.org/en/nevibecode/mcp/dbx.md) — MCP server · ★ 27844
- [Metabase](https://affpapa.org/en/nevibecode/mcp/metabase.md) — MCP server · ★ 49863

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md