Database Connections

Connecting a database lets you ask questions about your data using plain English. Skopx generates the SQL (or query) for you and returns results with citations.

PostgreSQL

  1. Go to Settings > Data Sources > Add Database.
  2. Select PostgreSQL.
  3. Enter your connection details: host, port (default 5432), database name, user, and password.
  4. Alternatively, paste a connection string: postgresql://user:password@host:5432/dbname
  5. Click Test Connection, then Save.

MySQL

Same flow as PostgreSQL. Default port is 3306. Connection string format: mysql://user:password@host:3306/dbname

MongoDB

  1. Select MongoDB from the database list.
  2. Paste your MongoDB connection string: mongodb+srv://user:password@cluster.mongodb.net/dbname
  3. Skopx will discover your collections automatically.

Snowflake

  1. Select Snowflake.
  2. Enter your account identifier (e.g. xy12345.us-east-1), warehouse, database, schema, user, and password.
  3. Click Test Connection to verify.

BigQuery

  1. Select BigQuery.
  2. Upload your Google Cloud service account JSON key.
  3. Choose the project and dataset.
  4. Click Save.

Best Practices

  • Use a read-only user. Skopx never writes to your database, so a read-only user is safest.
  • Allowlist our IP. Check the connection screen for the IP address to add to your firewall rules.
  • SSL is recommended. Skopx supports SSL connections for all database types.
  • Schema scanning. After connecting, Skopx scans your schema (tables, columns, types) to understand your data. This usually takes under a minute.
Supported IntegrationsSaaS Connections