OracleSQLDevAi — Oracle Ultimate MCP

AI control of Oracle Database + Oracle SQL Developer sync for Cursor.

Repository: github.com/thejanaloit/OracleSQLDevAi-

Control Oracle from Cursor chat: connections, SQL, schema, DDL/DML, and auto-sync into the SQL Developer desktop app.

Also compatible with Oracle's official SQLcl MCP (sql -mcp).

---

Features

• 28 MCP tools — connect, run SQL/PL/SQL, browse schema, DDL, explain plan
• SQL Developer sync — pushes connections to SQL Developer's connections.json
• SQLcl bridge — run commands via SQLcl
• Worksheets — AI writes .sql files you open in SQL Developer
• Portable — install on any Windows PC with Python 3.10+

---

Quick install

git clone https://github.com/thejanaloit/OracleSQLDevAi-.git
cd OracleSQLDevAi-
powershell -ExecutionPolicy Bypass -File install-ultimate.ps1

Set password (first time):

$env:ORACLE_MCP_PASSWORD = "your-password"
powershell -ExecutionPolicy Bypass -File install-ultimate.ps1

Or in Cursor after install:

oracle_save_connection(
  name="my_db",
  username="your_user",
  password="your_password",
  hostname="db-host",
  port=1521,
  service_name="YOUR_SERVICE"
)

---

Cursor MCP config

Add to %USERPROFILE%\.cursor\mcp.json (install script does this automatically):

{
  "mcpServers": {
    "oracle-ultimate": {
      "command": "python",
      "args": ["FULL_PATH/OracleSQLDevAi-/oracle_sqldev_mcp/server.py"],
      "env": {
        "PYTHONIOENCODING": "utf-8",
        "ORACLE_MCP_CONFIG_DIR": "C:/Users/YOU/.oracle-sqldev-mcp",
        "ORACLE_MCP_WORKSPACE": "C:/Users/YOU/.oracle-sqldev-mcp/worksheets",
        "TNS_ADMIN": "C:/Users/YOU/network/admin"
      }
    },
    "sqlcl": {
      "command": "FULL_PATH/sqlcl/bin/sql.exe",
      "args": ["-mcp"]
    }
  }
}

Restart Cursor → Settings → MCP → enable oracle-ultimate.

---

First use

oracle_setup_sqldeveloper
oracle_connect connection_name=my_db
oracle_run_sql sql="SELECT USER FROM dual"
oracle_query_table table_name=YOUR_TABLE

---

Architecture

Cursor AI  ←→  oracle-ultimate MCP  ←→  Oracle Database
                      ↓
              SQL Developer (connections sync)

SQL Developer GUI has no remote API. This MCP runs SQL directly and keeps the SQL Developer connections panel in sync.

---

Documentation

File	Description
README-ULTIMATE.md	Full guide
SQL_DEVELOPER_FEATURE_MAP.md	SQL Developer ↔ MCP mapping
.env.example	Optional install password

---

Requirements

• Python 3.10+
• pip install -r requirements.txt
• Oracle SQL Developer (optional GUI) — winget install Oracle.SQLDeveloper
• Oracle SQLcl (optional) — winget install Oracle.SQLcl

---

License

MIT — see LICENSE

---

Author

thejanaloit