Supported databases

Target Audience: Non technical users & Developers

TL;DR

Toucan.ai connects to external PostgreSQL and Google BigQuery instances for read-only data extraction.

---

When to use this

Use this page to identify supported data sources and the network requirements for establishing a secure connection to your infrastructure.

---

Core Functionality

Database Connections enable Toucan.ai to read data from source systems. The platform performs the following actions:

• Discovers schemas and tables.

• Previews raw data.

• Analyzes metadata using AI.

• Powers charts, dashboards, and embedded analytics.

Constraint: Toucan.ai only performs read operations and does not write to the connected database.

---

Prerequisites

Before creating a database connection, ensure the following are available:

• Access to an active Toucan.ai organization.

• Valid credentials for the source database.

• Network visibility between Toucan.ai and the database.

---

Supported Connectors

The following database and warehouse connectors are currently available:

• PostgreSQL.

• Google BigQuery.

• MySQL

Future Support

The following connectors are not currently supported:

• Amazon Redshift, Snowflake, and ClickHouse.

---

Security & Network Configuration

• Access Model: Use a read-only database user to prevent unauthorized data modification.

• Network Allow-Listing: You must allow-list Toucan.ai static IP addresses in your firewall or security group settings.

• Cloud Static IP (EU): 51.15.216.216.

---

Connector Reference

---

Constraints

• Write Operations: Write access is not supported.

• Firewalls: Connection attempts will fail if network restrictions are not handled on the database side.

• Authentication: Every connector requires specific authentication formats (e.g., credentials vs. JSON keys).