> ## Documentation Index
> Fetch the complete documentation index at: https://docs.myrmex.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle Database

> Connect an Oracle Database to Myrmex — create a read-only audit user and add the integration.

import { Note, Steps, Step, CardGroup, Card, Tip } from '@mintlify/components';

Connect your **Oracle Database** so Myrmex can audit its hardening and compliance, check its operational health, explore its schema, and — with approval — run SQL for you. Myrmex reaches the database through the Oracle listener via a [Collector](/documentation/agent-endpoint-security/collector-mode) on your network. Operations run live and on demand through the [Integration Specialist](/documentation/multi-agent-system/integration-specialist-agent) agent — Myrmex reads only what you ask for and keeps none of your data on the Myrmex side.

## What Myrmex Can Do

<CardGroup cols={2}>
  <Card title="Compliance audit" icon="shield-halved">
    Run a [Security Posture](/documentation/security-posture/overview) audit and map findings to CIS, ISO 27001, NIST CSF, and BACEN [frameworks](/documentation/security-posture/frameworks).
  </Card>

  <Card title="Health checks" icon="heart-pulse">
    Review sessions, tablespace usage, wait events, and Data Guard status.
  </Card>

  <Card title="Explore tables" icon="table">
    List schemas and tables so you can see what the database holds.
  </Card>

  <Card title="Describe structure" icon="sitemap">
    Inspect columns, types, indexes, and constraints for any table.
  </Card>

  <Card title="Sensitive-data scan" icon="user-secret">
    Scan tables and columns for personal or sensitive data that needs protection.
  </Card>

  <Card title="Run SQL" icon="terminal">
    Execute read queries any time; write statements (DDL/DML) require your confirmation.
  </Card>
</CardGroup>

## Before You Start

* A **Collector** on a network that can reach the Oracle listener on its TCP port (default `1521`). See [Collector mode](/documentation/agent-endpoint-security/collector-mode).
* The Collector host must have the **Oracle Instant Client** (`libclntsh`) and **libaio** installed — the connector loads them at runtime.
* A **dedicated database user** for Myrmex (create it in Step 1).
* The connection uses the **service name** (e.g. `XEPDB1`, `ORCLPDB1`) as `host:port/service`.

## Step 1 — Create the Credential in Oracle

Create a dedicated, least-privilege user for auditing. `SELECT_CATALOG_ROLE` grants read access to the `V$` and `DBA_*` dictionary views the audit relies on.

```sql theme={null}
-- As a DBA
CREATE USER myrmex_audit IDENTIFIED BY "a-strong-password";
GRANT CREATE SESSION TO myrmex_audit;
GRANT SELECT_CATALOG_ROLE TO myrmex_audit;
```

<Tip>
  Keep the account read-only for auditing. Grant a write-capable user only if you want the agents to run write statements (DDL/DML) through **Run SQL**.
</Tip>

## Step 2 — Add the Integration in Myrmex

From the **Directory**, choose **Add Integration → Oracle Database**, then fill in:

| Field            | Description                                                                                                                         |
| ---------------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| **Name**         | A unique name for this database.                                                                                                    |
| **Description**  | Optional note to identify the instance.                                                                                             |
| **Host**         | Oracle listener host or IP.                                                                                                         |
| **Port**         | Listener TCP port (default `1521`).                                                                                                 |
| **Service Name** | Oracle service name / pluggable DB (e.g. `XEPDB1`, `ORCLPDB1`) — used as `host:port/service`.                                       |
| **Username**     | Audit user (`SELECT_CATALOG_ROLE`) or a write-capable user for operations.                                                          |
| **Password**     | Password (stored encrypted).                                                                                                        |
| **SSL Mode**     | TLS posture: `disable` unless the listener is configured for TCPS; `require` / `verify-full` / `verify-ca` for encrypted listeners. |
| **Collectors**   | The [Collector(s)](/documentation/agent-endpoint-security/collector-mode) that can reach this database.                             |

## Connect

Click **Connect** to validate the login and TLS settings. The database then appears under **Environment → Integrations** alongside your other [integrations](/documentation/integrations/overview), and you can start asking the AI about it in the Workspace.

## Notes

* **Read-only by default.** Auditing, health, schema exploration, and sensitive-data scans only need the read-only user. Provide a write-capable user only if you want confirmation-gated **Run SQL** writes.
* **Nothing is stored.** Every operation runs in real time through the Collector; results return to your Workspace and no database data is retained on the Myrmex side.
* **TLS.** Use `disable` for plain TCP listeners; switch to `require` or a verifying mode once the listener is configured for TCPS.