Skip to main content
Watch: I Built an AI App Without Leaving Databricks

Databases - official Oracle server

ORDS MCP server

Authenticated streamable HTTP MCP endpoint built into Oracle REST Data Services that lets AI clients discover authorized database pools, inspect schema metadata and run SQL or PL/SQL. It runs locally with OAuth auth.

Last verified 3 tools2 sources

Install

Generic

JSON
{
    "mcpServers": {
       "ords-mcp": {
         "command": "npx",
         "args": [
           "mcp-remote@latest",
           "https://ords.example.com/mcp",
           "--allow-http"
         ]
       }
     }
    }

Tools

database_list
Lists the MCP database connections the caller is authorized to access.
schema_information
Returns schema metadata for an authorized MCP database.
sql_run
Executes SQL or PL/SQL for an authorized MCP database.

As documented on October 17, 2026. A running server reports its current list through tools/list.

Notes and caveats

  • Self-hosted: requires ORDS 26.2.0+ (JRE 17, 21 or 25), feature.mcp enabled and dedicated MCP database pools.
  • Clients need a JWT bearer token from an authorization server with the urn:oracle:dbtools:ords:mcpserver:all scope (OAuth discovery via /.well-known/oauth-protected-resource/mcp).
  • Supports MCP protocol versions 2025-06-18 and 2025-11-25. sql_run can modify data.

FAQ

What does the ORDS MCP server do?

Authenticated streamable HTTP MCP endpoint built into Oracle REST Data Services that lets AI clients discover authorized database pools, inspect schema metadata and run SQL or PL/SQL. The vendor documents 3 tools, including database_list, schema_information and sql_run.

How do I add the ORDS MCP server to an MCP client?

Oracle documents a Generic config; copy it from the Generic section of this page.

Does the ORDS MCP server need authentication?

Yes, OAuth. Transport: Streamable HTTP. Status: GA, last checked October 17, 2026.

Sources

Last verified against 2 Oracle pages, then re-checked independently.

Newsletter

New MCP servers, the week they ship

One email per week. New official MCP servers, the coding tools that support them and how developers wire them up.