SQL Connectors

Use SQL connectors when your project should read directly from an existing database instead of uploaded files or sample data.

Supported sources

PostgreSQL
MySQL
Supabase

Choose the right connection method

use a direct connection when the database is already reachable from the network where AnalytAI connects
use the VPN workflow when the database is private, local, or hosted inside an office network

If your database should stay off the public internet, start with Secure Bridge (VPN).

Prepare a safe database user

Create a dedicated read-only user for AnalytAI. The account should have permission to connect and read the required schemas or tables, but it should not be able to change data.

PostgreSQL example

CREATE USER AnalytAI_user WITH PASSWORD 'YourSecurePassword123!';
GRANT CONNECT ON DATABASE your_database_name TO AnalytAI_user;
GRANT USAGE ON SCHEMA public TO AnalytAI_user;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO AnalytAI_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO AnalytAI_user;

MySQL example

CREATE USER 'AnalytAI_user'@'%' IDENTIFIED BY 'YourSecurePassword123!';
GRANT SELECT ON your_database_name.* TO 'AnalytAI_user'@'%';
FLUSH PRIVILEGES;

Connect the source in AnalytAI

Create a new project for the database source.
Select the database type.
Enter the host, port, database name, username, and password.
Test the connection.
Finish project creation and continue into setup or onboarding.

For Supabase, use the PostgreSQL-compatible connection details from the project and prefer the connection string or host details intended for application access.

After the connection succeeds

review Project Setup
run Project Onboarding if you want a stronger published catalog
inspect the source in Database Catalog Explorer
start asking questions in AI Chat