Point Claude at your database.

Try free
← Blog

Oracle MCP Server: Connect Claude to Oracle Database With SQLcl, Safely (2026)

Oracle's MCP server is built into SQLcl, and since May 2026 it starts with its command restrictions off. How to set it up for Claude Code and Claude Desktop, the read-only user to give it, the hosted options (Autonomous AI Database, OCI Database Tools, ORDS), and what our test on Oracle 26ai Free showed.

Fastero Dev TeamFastero Dev Team2026-11-12

Oracle's MCP server for Claude doesn't need installing separately: it's built into SQLcl, Oracle's free command-line tool. It has no read-only switch, its documentation and its changelog disagree about how locked down it starts, and its activity log quietly doesn't exist for the safest kind of login. We ran it against Oracle Database 26ai Free to check each of those.

The short answer: Oracle's MCP server for Claude is built into SQLcl, its free command-line tool (26.3.1, released 3 November 2026, Java 17, 21 or 25). Save a connection with conn -save claude_ro -savepwd user/password@//host:1521/service, then add claude mcp add --transport stdio sqlcl -- /path/to/sqlcl/bin/sql -R 4 -mcp to Claude Code, or the same command with the -mcp argument in Claude Desktop's config. SQLcl has no read-only switch, and since version 26.1.2 it starts unrestricted, so pass -R 4 and connect as a user with only CREATE SESSION and SELECT. For a hosted option, Oracle offers Autonomous AI Database, OCI Database Tools and ORDS MCP servers.

Fastero

Point Claude at your database.

Add Fastero to claude.ai or Claude Code. Claude builds the dashboard, deploys the app or publishes a live page, and your team opens it in Fastero.

Try free →

Which Oracle MCP server to use

Oracle lists three ways in: "SQLcl MCP Server for local stdio workflows, OCI Database Tools MCP Server for managed Oracle Cloud Infrastructure deployments, or the built-in ORDS MCP endpoint for secure HTTPS streaming", plus a fourth for Autonomous databases.

Option Runs where Works in Good for
SQLcl (sql -mcp) Your machine, free Claude Code, Claude Desktop Any Oracle database you can reach with SQLcl
Autonomous AI Database MCP Server Oracle Cloud, per database (since December 2025) Remote clients, via OAuth Autonomous Serverless databases, 26ai and 19c
OCI Database Tools MCP Server Oracle Cloud, managed (since May 2026) Remote clients Teams on OCI
ORDS /mcp Your ORDS server, 26.2 or later Remote clients Teams already running ORDS; "The MCP feature is disabled by default."
A hosted connector such as Fastero Hosted claude.ai, Claude Desktop, Claude Code Questions from claude.ai and results colleagues open

There's no Oracle connector in Claude's directory, and Oracle's GitHub reference servers say they're "not intended for production use".

Option A: SQLcl's MCP server

Set it up

SQLcl has run as an MCP server since 25.2 (July 2025). It uses connections you've saved, and "For a connection to be accessible to an MCP client, you must save its password." Save one for a read-only user (below), then add the server:

# once, in SQLcl: save a read-only connection with its password
sql /nolog
SQL> conn -save claude_ro -savepwd mcp_reader/<password>@//dbhost:1521/FREEPDB1
 
# Claude Code, macOS or Linux
claude mcp add --transport stdio sqlcl --env JAVA_HOME=/path/to/jdk -- /opt/sqlcl/bin/sql -R 4 -mcp

Oracle documents only Claude Desktop and Cline, not Claude Code. For Claude Desktop, "Replace PATH/bin/sql with the absolute path of your SQLcl installation":

{
  "mcpServers": {
    "sqlcl": {
      "command": "/opt/sqlcl/bin/sql",
      "args": ["-R", "4", "-mcp"],
      "env": { "JAVA_HOME": "/path/to/jdk", "TNS_ADMIN": "/path/to/wallet" }
    }
  }
}

TNS_ADMIN is only needed for a tnsnames.ora or an Autonomous wallet. Saved connections live in ~/.dbtools; since 25.4, -home points SQLcl at a separate folder, which keeps an agent's connections apart from yours.

Pass -R 4: it starts unrestricted

SQLcl's documentation says the server "defaults to the most restrictive level, that is , level 4". Its changelog for 26.1.2, in May 2026, says the opposite: "SQLcl MCP startup now defaults to unrestricted. This was previously set to restriction level 4". We checked on 26.3.1. Started without -R, a host command ran on our own machine through the MCP tool:

A terminal session with SQLcl's MCP server started without -R: it connects, reports AUTOCOMMIT is ON, counts 20 orders, runs host echo host-command-ran on the machine, and the DBTOOLS$MCP_LOG table lists each call

SQLcl 26.3.1 started with no restrict level: the host command ran.

Started with -R 4, the same call was refused:

The same session with SQLcl started with -R 4: the host command returns SP2-0738: Restricted command and not available

With -R 4: "SP2-0738: Restricted command".

Restrict levels limit SQLcl's own commands, such as host. They don't stop SQL: sql_run describes itself as destructive, and every session starts with "AUTOCOMMIT is ON", so a write commits at once. The database user is what keeps Claude to reading.

Give it a user that can only read

Oracle's own advice: "Configure the database user account used by the LLM with the absolute minimum permissions required for its tasks." This is what we ran as SYSTEM in our test database:

CREATE USER mcp_reader IDENTIFIED BY "<password>";
GRANT CREATE SESSION TO mcp_reader;
GRANT SELECT ON shop_owner.orders TO mcp_reader;
 
-- 23ai and 26ai: a READ ONLY user, with a grant that covers the schema's future tables too
CREATE USER mcp_ro IDENTIFIED BY "<password>" READ ONLY;
GRANT CREATE SESSION TO mcp_ro;
GRANT SELECT ANY TABLE ON SCHEMA shop_owner TO mcp_ro;

Both held. An INSERT as mcp_reader failed with "ORA-41900: missing INSERT privilege", and even after we granted INSERT to the READ ONLY user, Oracle refused it: "ORA-28194: Can perform read operations only". The table still had 20 rows. On 19c there are no READ ONLY users or schema-level grants, so use object grants, through a role for many tables.

The audit log isn't there for read-only users

Oracle says "The server automatically records the execution history of every request in the DBTOOLS$MCP_LOG table." It does, in the connected user's own schema, and only if that user can create tables: the log in our pictures above exists because that session ran as the table owner. For both read-only users, user_tables came back with "no rows selected": no log at all. With a properly locked-down login, use Oracle's own auditing on that user instead. SQLcl also tags each statement with a comment naming the model, for example /* LLM in use is ... */, which shows up in session monitoring.

Tool names and other gotchas

  • The documentation lists old tool names. It says list-connections, run-sql and skill_sync; 26.3.1 actually exposes ten tools named connections_list, connect, disconnect, sqlcl_run, sql_run, schema_information, skills_sync, context_retrieve, request_status and annotation_generate.
  • Claude Code once rejected the tools. In January 2026 Claude Code reported "tools.21.custom.input_schema: JSON schema is invalid." for SQLcl 25.4; Oracle fixed it in 25.4.1. Use a current SQLcl.
  • Windows. In our test, sql.exe crashed with Oracle JDK 25.0.5 while the bash launcher worked. On Windows, use sql.exe with JDK 17 or 21 and an absolute path.

Point Claude at your database.

Start free →

Option B: Oracle's hosted MCP servers

claude.ai in a browser can't launch SQLcl. Oracle's hosted options:

  • Autonomous AI Database MCP Server. Since 23 December 2025, "a managed, per-database MCP server" for Autonomous Serverless (26ai and 19c). Its tools are the Select AI Agent tools you define, and it "supports OAuth authentication through dynamic or static client registration."
  • OCI Database Tools MCP Server. Launched 12 May 2026, with "Remote MCP support: Works with MCP clients through Streamable HTTP transport."
  • ORDS MCP, at /mcp on ORDS 26.2 or later, off by default. Its sql_run tool "can run statements that modify database state", so the database user matters here too.

Oracle's Claude Desktop examples for these go through mcp-remote.

Option C: a hosted connector

To ask questions from claude.ai or a phone, and to share results with colleagues, use a hosted connector. Fastero is an AI and data platform where people and AI agents work together on a team's data. Add Oracle once from its connection form, with the read-only user, then add Fastero to Claude from its connector directory.

Claude can then list the tables, read the metric definitions your team has saved, and run SQL in Oracle's dialect. Fastero refuses any statement that could change data before it reaches the database, and returns at most 500 rows per query. Charts can go onto a Fastero dashboard that colleagues open with their own login and that refreshes on a schedule. More on SQL MCP servers, the SQL Server MCP server and connecting MCP servers to Claude Code.

Keep it safe: a checklist

  1. Start SQLcl with -R 4, whatever the documentation says the default is.
  2. Connect as a user with CREATE SESSION and SELECT only, or a READ ONLY user on 23ai and later.
  3. Remember AUTOCOMMIT is on: a write from any user with write rights commits immediately.
  4. Audit the MCP user with Oracle's auditing, because SQLcl's log table won't exist for it.
  5. Keep agent connections in their own folder with -home.

FAQ

Does Oracle have an official MCP server?

Yes. SQLcl, Oracle's free command-line tool, runs as one with sql -mcp. Oracle also offers hosted MCP servers in Autonomous AI Database, OCI Database Tools and ORDS.

How do I connect Oracle to Claude Code?

Save a connection in SQLcl with its password (conn -save name -savepwd ...), then run claude mcp add --transport stdio sqlcl -- /path/to/sqlcl/bin/sql -R 4 -mcp.

Can I make the SQLcl MCP server read-only?

There's no read-only switch. Connect as a user that can only SELECT, or a READ ONLY user on Oracle 23ai and later, and start SQLcl with -R 4 so it can't run operating-system commands.

What does -R 4 do in SQLcl?

It sets the most restrictive level, which turns off SQLcl commands such as host that reach your machine or its files. Since SQLcl 26.1.2 the MCP server starts unrestricted unless you pass it. It doesn't block SQL.

Where are SQLcl MCP activities logged?

In a DBTOOLS$MCP_LOG table in the connected user's schema, but only if that user can create tables. A read-only user gets no log, so use Oracle's database auditing for it.

Why does Claude Code reject the SQLcl MCP tools?

SQLcl 25.4 had a tool schema that Claude Code's strict validation rejected. Oracle fixed it in 25.4.1; update SQLcl.

Sources

Read on 11 November 2026; our test used SQLcl 26.3.1 and Oracle JDK 25.0.5 against Oracle AI Database 26ai Free in Docker, with invented data:

Point Claude at your database. Get a dashboard your team can open.

Sign in from claude.ai, or add one line to Claude Code, and ask for the dashboard. No credit card required.