Data Connectors Overview

Data Connectors Overview

Querri’s connector system allows you to seamlessly integrate external data sources into your AI-powered analytics workspace. Connect databases, cloud storage, business applications, and more—then query them naturally using AI.

What are Connectors?

Connectors are integrations that link Querri to your external data sources. Once connected, you can:

• Ask questions about your data in natural language
• Combine data from multiple sources in a single query
• Analyze data without writing SQL or code
• Access real-time data from connected systems

All connectors are managed from a central location: Settings → Connectors (/settings/connectors)

Security Recommendation: IP Whitelisting

For enhanced security when connecting to databases and external systems, we recommend whitelisting Querri’s IP address in your firewall or database configuration:

Querri IP Address: 18.189.33.77

This ensures that only Querri can access your data sources, providing an additional layer of security beyond username/password authentication.

Connector Types

Querri supports three types of connectors based on how they authenticate:

OAuth Connectors

OAuth connectors use secure, token-based authentication through a popup authorization flow. You grant Querri permission to access your data without sharing passwords.

OAuth connectors include:

• Google Drive
• BigQuery
• HubSpot CRM
• QuickBooks Online

How OAuth works:

1. Click “Connect” on the connector
2. A popup opens to the provider’s login page
3. Sign in and authorize Querri’s access
4. The popup closes and the connector is active

Credential-Based Connectors

Credential-based connectors require you to provide connection details directly, such as host, port, username, and password.

Credential connectors include:

• PostgreSQL
• MySQL
• Microsoft SQL Server
• Oracle Database (development)
• Snowflake (development)
• Amazon Redshift (development)
• Fluke eMaint

How credential authentication works:

1. Enter connection details (host, port, database name)
2. Provide authentication credentials
3. Test the connection
4. Save the connector configuration

Built-in File Connector

The Files connector is always available and requires no setup. Upload files directly through the Library interface.

Supported formats:

• CSV
• Excel (XLS, XLSX)
• JSON
• Parquet

Connector Categories

Connectors are organized into categories for easy discovery:

Database

Relational and data warehouse databases for structured data

• PostgreSQL, MySQL, Microsoft SQL Server
• BigQuery
• Oracle Database, Snowflake, Amazon Redshift (development)

Storage

Cloud storage providers for documents and files

• Google Drive

Accounting

Financial and accounting platforms

• QuickBooks Online

CRM

Customer relationship management systems

• HubSpot CRM

Business Applications / CMMS

Computerized maintenance management and business applications

• Fluke eMaint

Connecting Multiple Instances of the Same Service

You can add more than one connector for each service. This is one of Querri’s most powerful features.

Why Use Multiple Connectors?

Connect multiple instances of the same service to:

• Multiple databases: Production, staging, development, analytics warehouse
• Multiple accounts: Different Google Drive accounts (personal, work, client)
• Multiple organizations: Different QuickBooks companies or HubSpot portals
• Regional instances: Separate databases by region or department
• Environment separation: Keep production separate from testing

How It Works

1. Go to Settings → Connectors
2. Click Add Connector for a service you’ve already connected
3. Authenticate with the same or different account
4. Give it a unique, descriptive name
5. The new instance appears separately in your Library

Example Setup

You might have:

PostgreSQL - Production Orders DB
PostgreSQL - Analytics Warehouse
PostgreSQL - Development Database

Google Drive - Work Account
Google Drive - Personal Files

QuickBooks - Main Company
QuickBooks - Subsidiary LLC

HubSpot - US Sales Portal
HubSpot - European Sales Portal

Using Multiple Connectors

Each connector instance:

• Has its own configuration and credentials
• Appears separately in your Library
• Shows its own data sources (tables/files)
• Can be referenced independently in projects
• Has its own connection status

In your Library, sources are labeled with the connector name, so you can easily tell which “Orders” table comes from which database.

Custom Naming

When adding a connector, you can provide a custom display name that makes it easier to reference in conversations:

Default naming:

MySQL Connector

Custom naming:

Customer Orders Database
Sales Analytics DB
Product Inventory System

The AI will understand references to your custom names when you ask questions like:

“Show me the top customers from the Customer Orders Database”

Accessing Connectors

Navigate to your connectors from anywhere in Querri:

1. Click the Settings icon in the navigation
2. Select Connectors from the settings menu
3. You’ll see all available and connected integrations

From this page you can:

• View all available connector types
• See your active connections
• Add new connectors
• Edit or remove existing connections
• Test connection status

How Connectors Work with AI Chat

Once a connector is active, it becomes available to the AI assistant in your chat sessions.

Natural Language Queries

Simply ask questions about your data:

"What are my top 10 customers by revenue from PostgreSQL?"
"Show me Google Drive files modified this week"
"Compare HubSpot deals with QuickBooks invoices"

Automatic Source Selection

The AI automatically determines which connector(s) to use based on your question. You can also be explicit:

"Using the Production DB, show me active users"
"From my Google Drive, find the Q4 budget spreadsheet"

Cross-Source Analysis

Combine data from multiple connectors in a single query:

"Join customer data from PostgreSQL with deals from HubSpot"
"Compare uploaded CSV sales targets with actual sales from QuickBooks"
"Combine Google Drive spreadsheet data with PostgreSQL database records"

Data Operations

Beyond querying, you can ask the AI to:

• Clean data: Remove duplicates, handle missing values
• Enrich data: Add information from external sources
• Transform data: Reshape, aggregate, or convert formats
• Export results: Download query results in various formats

Next Steps

Ready to connect your data sources? Explore these guides:

• Connecting Databases - Set up PostgreSQL, MySQL, Microsoft SQL Server, BigQuery, and more
• Google Drive - Connect Google Drive with secure file selection
• Business Applications - Integrate HubSpot CRM, QuickBooks Online, and Fluke eMaint
• File Uploads - Upload CSV, Excel, JSON, and Parquet files
• Managing Connections - Edit, test, and troubleshoot connectors

Security and Privacy

Querri takes data security seriously:

• Encrypted credentials: All connection credentials are encrypted at rest
• Secure OAuth: Industry-standard OAuth 2.0 for third-party apps
• Minimal permissions: Connectors request only the access they need
• No data storage: Query results are processed in memory, not stored
• User control: Disconnect any connector at any time

Your data remains in your systems—Querri only accesses it when you make a query.