Skip to main content

​
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

MYADB_LOW    = (description= ...)
MYADB_MEDIUM = (description= ...)
MYADB_HIGH   = (description= ...)