Connector guide2-minute read5 MCP tools7 languages

How to Connect Oracle Database to Cursor — via MCP

Query an Oracle database directly: list tables, describe columns and run read-only SQL. Installs read-only; credentials are held encrypted rather than in the connection string.

HCBy HelpCode teamUpdated 2 min read Open-source on GitHub

No credit card · 7-day trial · Self-host alternative available

Oracle Database

Oracle Database

Query an Oracle database directly: list tables, describe columns and run read-only SQL. Installs read-only; credentials are held encrypted rather than in the connection string.

tools

5

Region

INTL

Category

Databases

Authentication

Connection string

Required env vars

ORACLE_HOSTORACLE_PORTORACLE_DATABASEORACLE_USERORACLE_PASSWORD
Install in one click on Cloud

7-day free trial · No credit card

  • 7-day free trial
    No credit card required
  • GDPR & SOC 2 ready
    EU data residency, audit logs
  • Open-source on GitHub
    Open source · AGPL-3.0
  • Works with ChatGPT, Claude, Gemini
    Any MCP-compatible client

Skip the install. Get this working in under 2 minutes.

Start a free trial on cloud.anythingmcp.com, add the Oracle Database in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.

Start free trial

Summary

Query an Oracle database directly: list tables, describe columns and run read-only SQL. Installs read-only; credentials are held encrypted rather than in the connection string.

Try asking

Example prompts for Oracle Database

Click any prompt to copy it. Paste into Claude, ChatGPT, Cursor, Gemini, Copilot or OpenClaw to run it against this connector.

Oracle Database · live via MCP
Share
Opus 4.7

Claude is AI and can make mistakes. Please double-check responses.

💡 No install? Use cloud.anythingmcp.com directly. Sign in, click Connectors → Oracle Database, paste your credentials, mint an MCP API key — done. No Docker, no git clone, no local server.

Oracle Database + Cursor

Query an Oracle database directly: list tables, describe columns and run read-only SQL. Installs read-only; credentials are held encrypted rather than in the connection string.

Prerequisites

See the full setup instructions baked into the connector (visible in the in-app store when you select the connector). The required environment variables for this connector are:

ORACLE_HOST, ORACLE_PORT, ORACLE_DATABASE, ORACLE_USER, ORACLE_PASSWORD

Step 1 — Get credentials

Setup

  1. Create a user with only CREATE SESSION and the SELECTs it needs:
    CREATE USER amcp_reader IDENTIFIED BY "change-me";
    GRANT CREATE SESSION TO amcp_reader;
    GRANT SELECT ON sales.orders TO amcp_reader;
    -- or, for a whole schema, a read-only role you maintain
    
  2. Set ORACLE_HOST, ORACLE_PORT (1521), ORACLE_DATABASE — the service name (e.g. ORCLPDB1), not the SID — plus ORACLE_USER and ORACLE_PASSWORD.

The node-oracledb driver needs to be in thin mode or have Instant Client available. Thin mode covers Oracle 12.1 and newer with no client install; an older server needs Instant Client on the AnythingMCP host.

…(continued in the in-app connector instructions)

Step 2 — Install the adapter

curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d

Step 3 — Add the connector in Cursor

Your server URL: in AnythingMCP, open MCP Servers → the server this connector is on, and copy its URL (https://cloud.anythingmcp.com/mcp/…). Use it wherever this guide shows YOUR_SERVER_ID.

Cursor reads MCP servers from ~/.cursor/mcp.json. Add this entry:

{
  "mcpServers": {
    "anythingmcp": {
      "url": "https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID",
      "headers": { "X-API-Key": "YOUR_MCP_API_KEY" }
    }
  }
}
  1. Get your MCP API key from AnythingMCP → MCP Servers → your server → API keys.
  2. Save the file and restart Cursor.
  3. Open Cursor → Settings → MCP to verify Oracle Database is listed and "Connected".
  4. Start chatting — all Oracle Database tools are now invokable.

Available tools

ToolWhat it does
oracle_list_tablesList the tables and views in the database with their schema and, where the server tracks it, an approximate row count
oracle_describe_tableDescribe one table: every column with its data type, nullability and default
oracle_find_columnsFind columns across every table whose name matches a pattern — the fast way to locate where customer e-mail addresses, IBANs or order number
oracle_queryRun a read-only SQL statement against Oracle Database and return up to 1000 rows
oracle_query_examplesShow worked example queries for Oracle Database: how to list schemas, find large tables, inspect indexes and check what is running right now

FAQ

Does Cursor support custom MCP servers on the free tier? Yes — MCP is available on Hobby, Pro and Business plans.

Next steps

Was this guide helpful?

Your Oracle Database agent is one click away.

Install the connector, paste the key, prompt Cursor. Free for 7 days, no credit card.

Related guides