Onboarding

Get started connecting your database on MyQuery in seconds

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

SQL Server

MySQL

PostgreSQL

MongoDB

SQLite

MariaDB

IBM Db2

Amazon Redshift

Snowflake

Google BigQuery

CockroachDB

Informix

Azure Synapse

Databricks SQL

ClickHouse

SingleStore

MotherDuck

Elasticsearch

Supabase

DuckDB

Google Sheets

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.