Databases

Oracle Database integrations

Connect Oracle Database to any other app, or use it from your AI client over MCP. Connect directly to an Oracle database and run SQL statements from your automations. Requires Oracle Database 12.1 or newer: the ready-made row operations (add, find, update and delete a row), the two polling triggers, and the table and column pickers all refuse to run against an older server such as 11g. On 11g only the custom-query operations are available.

Connects with an API keyoracle.com

What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.

Build solutions, not workarounds.

What do you want to automate with Oracle Database?

Ask the assistant

You'll sign in before anything runs. What you typed comes with you.

Connect your AI client

Give your AI client this address.

https://mcp.apiant.ai

One connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.

Set it up in your client
Claude Code

Run this in the directory you want to work in.

claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai

Start Claude Code there, approve the server, and sign in in the browser page it opens.

Claude Code guide (opens in a new tab)
Claude, web and desktop

Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.

Setup guide (opens in a new tab)
Cursor

Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.

Setup guide (opens in a new tab)
Zed

Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.

Setup guide (opens in a new tab)
Codex and the ChatGPT desktop app

Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.

Setup guide (opens in a new tab)
Any other MCP client

Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.

Setup guide (opens in a new tab)

Pair it

Connect Oracle Database with another app

What your agent can do with Oracle Database

Triggers and actions 5 triggers · 7 actions

  • Trigger
    New Column

    Fires when a new column appears on an Oracle table you choose.

  • Trigger
    New or Updated Row

    Triggers when a new row is added or modified.

  • Trigger
    New or Updated Row (Custom Query)

    Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.

  • Trigger
    New Row

    Triggers when you add a new row.

  • Trigger
    New Table

    Fires when a new table appears in the connected Oracle user's own schema.

  • Action
    Add Row

    Add one row to a table on the connected Oracle database.

  • Action
    Delete Row

    Delete the rows in a table whose chosen column equals a value.

  • Action
    Find Row

    Find the first row in a table whose chosen column matches a value.

  • Action
    Find Rows via Custom Query

    Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

  • Action
    Find Row via Custom Query

    Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

  • Action
    Run Custom Statement

    Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

  • Action
    Update Row

    Change column values on every row of a table whose chosen column matches a value.

Related apps

More in Databases

Reviews

What our customers say

Questions

Oracle Database, answered

Is there a Oracle Database MCP server?

APIANT's MCP server at https://mcp.apiant.ai works with Oracle Database. Add that address to any AI client that takes a remote MCP server and sign in once in your browser. Your client can then run Oracle Database actions on demand, or have APIANT build, test and run automations that use Oracle Database. Nothing to install.

What can start an automation from Oracle Database?

Any of Oracle Database's 5 triggers in the catalog, including New Column, New or Updated Row, New or Updated Row (Custom Query) and New Row. Describe the moment in plain language and your agent picks the right one.

What can your agent do in Oracle Database?

Any of Oracle Database's 7 actions, including Update Row, Add Row, Find Row and Find Rows via Custom Query. Your agent maps the data both ways and tests every scenario before it ships.

Can I use Oracle Database directly from Claude, ChatGPT or Cursor?

Yes. Connect your AI client to APIANT once and it works with Oracle Database two ways. Ask it to do something in Oracle Database once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running on its own. A one-off action uses your plan's tasks the same way an automation step does.

Do I need to write code against the Oracle Database API?

No. APIANT connects to the Oracle Database API for you, with your Oracle Database API key. Describe what you want in plain language and your agent builds it on the Oracle Database triggers and actions in the catalog. If you need an endpoint that is not there yet, your agent reads the Oracle Database API documentation and adds it.

Which apps can Oracle Database connect to?

Any app in the catalog; the list on this page pairs Oracle Database with each of them. If the other app is missing, point your agent at its API documentation and it builds the connector.

What happens when something fails?

Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.

Is there a free plan?

Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.