​
Welcome to MyQuery

Follow the steps below to connect your database.

​
Step 1: Define your schema name

Enter the schema (or list of schemas) you want MyQuery to index.
MyQuery reads metadata (tables, columns) to build the semantic layer; data is accessed only when you run a query.

​
Step 2: Choose your database type

MyQuery supports connecting to and managing data from multiple database types, including:

Oracle

Postgres

SQL Server

MySQL

MongoDB

NoSQL

​
Step 3: Connect your database

Provide the required connection details:
  • Host and Port
    Defaults: Oracle 1521, Postgres 5432, SQL Server 1433, MySQL 3306, MongoDB 27017.
  • Database / Service / SID (engine-specific)
  • Username / Password with read-only privileges (least-privilege recommended)
  • SSL/TLS (and wallet/cert files if your environment requires them)
Engine notes
  • Oracle: Use Service Name or SID. Wallet/mTLS if applicable.
  • Postgres: Database name required; SSL recommended on public networks.
  • SQL Server: Specify encryption settings as required by your server policy.
  • MySQL: Provide DB name; enable TLS if enforced.
  • MongoDB: Use standard or SRV URI format.
Firewall allowlist
Add this IP to your database allowlist to ensure connectivity:
62.171.190.236

​
Step 4: Save Connection

Click Save to test the connection and start schema sync.
Upon success, you can begin querying and building dashboards.