# Oracle Database — MCP Server

> Query schemas, run SQL and inspect metadata on Oracle with an AI agent.

**Source:** https://mcpplaygroundonline.com/mcp-servers/oracle  
**Transport:** stdio  
**Requires auth:** Yes

---

## What it does

The SQLcl MCP server exposes Oracle's command-line client as a set of MCP tools. Models can list the saved connections, run SQL and PL/SQL against a chosen connection, inspect schema objects (tables, views, indexes, constraints), and read data-dictionary metadata. Because it runs through SQLcl on your machine, it uses your existing named connections and wallet — no connection string is pasted into the agent, and Oracle states no data is sent to Oracle services. A common read-only alternative wraps an Oracle JDBC connection for schema, query and metadata access. It is the go-to for chatting with enterprise Oracle databases without hand-writing SQL.

## Tools exposed

- list-connections — enumerate the saved SQLcl named connections
- connect — open a session against a named connection or wallet
- run-sql — execute a SQL or PL/SQL statement and return rows
- describe-schema — inspect tables, views, indexes and constraints
- read-metadata — query the Oracle data dictionary for object metadata

## Example queries you can run

- "List the tables in the HR schema and tell me which ones look like fact tables."
- "Retrieve all employees hired in the last 30 days from the HR schema."
- "Show me the indexes on the ORDERS table and flag any that look redundant."
- "Summarise the columns and data types of the CUSTOMERS view and flag any PII."

## Details

- **Recommended model:** anthropic/claude-sonnet-4.5 — Claude Sonnet 4.5 writes correct Oracle SQL and PL/SQL and reasons over schema metadata reliably. Use Haiku 4.5 for simple read queries to keep costs low.
- **Transport:** stdio
- **Authentication:** Required — A named SQLcl connection (username, password/wallet and TNS or connect string). Use a read-only database user scoped to the schemas the agent needs. Data stays local via SQLcl.
- **Official source:** [Oracle SQLcl MCP Server — official docs](https://docs.oracle.com/en/database/oracle/sql-developer-command-line/25.2/sqcug/using-oracle-sqlcl-mcp-server.html)

## Frequently asked questions

### What is the Oracle Database MCP server?

It is Oracle's built-in MCP server, shipped inside SQLcl 25.2 and later. It lets AI models query and inspect an Oracle database through natural language by translating requests into SQL and running them through a named SQLcl connection on your machine.

### Does my Oracle data get sent to a third party?

No. The SQLcl MCP server runs locally and executes SQL against your database through your existing named connections. Oracle states that no data is sent to Oracle services — data sovereignty is maintained on your machine.

### What versions of Oracle tooling do I need?

You need SQLcl 25.2 or later, which includes the built-in MCP server. It connects to your Oracle Database using named connections or a wallet, and works with any MCP-capable client such as Claude Desktop, Cline or MCP Agent Studio.

### Is it safe to give an AI agent access to my Oracle database?

Use a dedicated database user with read-only privileges scoped to only the schemas the agent needs, and never connect as SYS or SYSTEM. For exploration, point the agent at a non-production database or a read replica during setup.

### How does Oracle MCP compare to the Postgres MCP server?

Both let AI models query a relational database in natural language. Oracle MCP runs through SQLcl and speaks Oracle SQL and PL/SQL against named connections, while Postgres MCP connects via a standard connection string and generates PostgreSQL SQL. Choose based on which database you run.

---

_Test this server across 40+ models on MCP Playground: https://mcpplaygroundonline.com/mcp-servers/oracle — free, no install._