Skip to main content

​
Setting Up a Supabase Connection

Click 'Create new Data Connector'

On the Data Connectors page, click the “Create new Data Connector” button and select Supabase from the available options.

Configure Connection Details

You’ll see a form with several fields. For Supabase, the only required fields are: Connection Name, User, Password, Host, Port, and Database.
Fields marked with an asterisk (*) are required to establish a connection.
​
Connection Name
string
required
  • What it is: A friendly name to identify this connection in Julius
  • Example: “Production DB” or “Sales Database”
  • Tip: Choose a name that helps you remember which database this connects to
​
User
string
required
  • What it is: Your Supabase database username (the Postgres user for your Supabase project)
  • Technical note: This is the username that has permission to access the database you want to analyze
  • Security: Julius encrypts and securely stores this credential
​
Password
string
required
  • What it is: The password for your Supabase Postgres user account
  • Security: Your password is encrypted in transit and at rest for maximum security
​
Host
string
required
  • What it is: The server address where your Supabase PostgreSQL database is hosted (from your Supabase project settings)
  • Format: Can be an IP address (like 192.168.1.100) or domain name (like db.supabase.co)
  • For cloud databases: This is typically provided in the Database section of your Supabase project
​
Port
number
required
  • What it is: The network port your Supabase PostgreSQL database uses for connections
  • Default: Supabase typically uses port 5432
  • When to change: Only change this if you’ve configured a custom port for your Supabase project
​
Database
string
required
  • What it is: The specific database name within your Supabase PostgreSQL server that contains the data you want to analyze
  • Example: postgres (default) or a custom database name if you’ve created one

IP Whitelisting (If Required)

If your database has firewall restrictions, you’ll need to whitelist Julius’s IP address to allow connections.

Complete IP Whitelisting Guide

Visit our detailed IP Whitelisting guide for step-by-step instructions for AWS RDS, Google Cloud SQL, Azure, and more hosting environments.

Get Current Julius IP Address

Find the current Julius IP address for whitelisting in your Data Connectors settings.
If you’re unsure whether your database requires IP whitelisting, check with your database administrator or hosting provider.

Test and Save Connection

  1. Click “Add Connection” to test the connection
  2. Julius will attempt to connect to your database with the provided credentials
  3. If successful, your connector will be saved and ready to use
  4. If there’s an error, double-check your credentials and network settings
If the connection fails, common issues include:
  • Incorrect host or port
  • Database not allowing external connections
  • Julius IP not whitelisted (check your settings for the current IP)
  • Wrong username/password

​
Connection Pooler Required

For Supabase connections, you must use a connection pooler instead of the direct connection string.Use either:
  • Session mode – for persistent applications
  • Transaction mode – for serverless or edge functions
Learn more about Supabase connection pooling → Supabase docs

​
Security & Trust

Julius takes data security seriously:
  • SOC 2 Type 2 Certified: Julius meets strict security standards for handling sensitive data
  • Encryption: All credentials and data are encrypted both in transit and at rest
  • No Data Storage: Julius doesn’t permanently store your data - it only queries what you request
  • Access Control: Only you can access connections you create

Learn More About Security

Visit our Security & Trust Center to learn more about how Julius protects your data and maintains compliance standards.

​
Using Your Data Connector

Once your Supabase connector is set up:
  1. Start a new conversation or continue an existing one
  2. Ask Julius about your data using natural language:
    • “Show me all customers from the users table”
    • “What’s the average order value this month?”
    • “Create a chart of sales by region”
  3. Julius will automatically:
    • Connect to your database
    • Write and execute the appropriate SQL queries
    • Present the results in an easy-to-understand format
    • Create visualizations when requested
You don’t need to know SQL! Just ask Julius what you want to know about your data in plain English, and it will handle the technical details.

​
Troubleshooting Common Issues

  • Verify your host and port are correct
  • Check if your database allows external connections
  • Ensure your assigned Julius IP is whitelisted in your firewall
  • Confirm your database is running and accessible
  • Double-check your username and password
  • Verify the user has permission to access the specified database
  • Make sure the database name is spelled correctly
  • Confirm your user has read permissions on the tables you want to analyze
  • Check that you’re connected to the correct database (not just the Supabase PostgreSQL server)
  • Verify table names and schemas are accessible to your user account

​
Best Practices

  • Use read-only credentials when possible to prevent accidental data modification
  • Create a dedicated Julius user in your Supabase database with only the permissions needed for analysis
  • Test connections with non-production data first to ensure everything works correctly
  • Monitor database performance when running complex queries through Julius
Always coordinate with your database administrator when setting up data connectors to ensure proper security and performance guidelines are followed.
Reach out to team@julius.ai for support or to ask questions not answered in our documentation.