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

# Oracle

> Connect to Oracle using EZCONNECT or OCI Wallet (mTLS).

## **Security & Architecture Overview**

Before connecting your data, it is critical to understand how MyQuery interacts with your infrastructure:

* **Schema-Only Access:** MyQuery does **not** ingest or store your raw database records. We only read the metadata (table names, column types, and foreign key relationships) to build a semantic map for the AI.
* **Encrypted Storage:** All connection credentials and "maps" are encrypted at rest using industry-standard AES-256 encryption.
* **Whitelisting:** To allow MyQuery to reach your database, you must whitelist our outbound IP addresses in your firewall or cloud security groups (e.g., AWS Security Groups, Azure Firewall).

# Connect your database

Choose one of the following methods.

## Method A — (host:port/service)

Connect with a username/password and an EZCONNECT descriptor.

### Required fields

* **Host**: e.g., `localhost` or a server IP
* **Port**: `1521` (default)
* **Service name** (recommended): e.g., `XEPDB1` (Oracle XE 21c)
* **Username / Password**: read-only user

### Formats

* Service name: `host:port/service_name` → `localhost:1521/XEPDB1`
* Legacy SID: `host:port:SID` → `db.example.com:1521:ORCL`

### Steps

1. Open **Add Connection → Oracle → EZCONNECT**.
2. Enter **Host**, **Port**, and **Service name** (or **SID**).
3. Enter **Username** and **Password** (read-only privileges).
4. Click **Test Connection**, then **Save**.

## Method B — Oracle Cloud (OCI) via Wallet (mTLS)

Connect to Autonomous Database (ADB) using an Oracle Wallet (ZIP) and a TNS alias.

### Prerequisites

* Wallet ZIP downloaded from OCI Console\
  (contains: `tnsnames.ora`, `sqlnet.ora`, `cwallet.sso`, etc.)
* A read-only database user

> **Note**\
> **Wallet handling**: Wallet files are used *as provided* by the customer. No modifications or temporary copies.

### Steps

1. Open **Add Connection → Oracle → OCI Wallet**.
2. Upload the **Wallet ZIP**.
3. Select a **TNS alias** from `tnsnames.ora` (e.g., `MYADB_LOW`, `MYADB_MEDIUM`, `MYADB_HIGH`).
4. Enter **Username** and **Password** for the read-only user.
5. If the wallet is password-protected, provide the **wallet password**.
6. Click **Test Connection**, then **Save**.

### Example — `tnsnames.ora` aliases

```ini theme={null}
MYADB_LOW    = (description= ...)
MYADB_MEDIUM = (description= ...)
MYADB_HIGH   = (description= ...)
```