Supported databases
Target Audience: Non technical users & Developers
TL;DR
Toucan.ai connects to external PostgreSQL, MySQL, Google BigQuery, ClickHouse, Snowflake, and Oracle instances for read-only data extraction.
When to use it
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.
ClickHouse.
Snowflake.
Oracle.
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.
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).
Oracle specifics: Service-name connection (
host,port,user,password,service_name) via the Oracle 23 ODBC driver. When TLS is required, add a wallet ZIP (max 500 KB; files at the archive root or in one folder). Non-TLS instances do not need a wallet. Individual file upload, oversized ZIPs, and nested archive layouts are not supported.
Last updated
Was this helpful?