Supabase

Supabase Connection Setup Guide

Connect your Supabase project to AnalytAI. Supabase uses PostgreSQL, so you’ll need your database connection string.

Prerequisites

• Active Supabase project
• Database password (not just the API key)

Step 1: Get Your Supabase Connection String

1. Go to your Supabase Dashboard
2. Select your project
3. Go to Settings → Database
4. Scroll down to Connection string
5. Copy the “Session pooler” connection string (port 5432)
6. It will look like:

   postgresql://postgres:[YOUR-PASSWORD]@db.project.supabase.co:5432/postgres

Step 2: Replace the Password

Replace [YOUR-PASSWORD] with your actual database password:

-- Before:
postgresql://postgres:[YOUR-PASSWORD]@db.project.supabase.co:5432/postgres

-- After:
postgresql://postgres:your_actual_password@db.project.supabase.co:5432/postgres

Step 3: Get Your Database Password

If you don’t know your database password:

1. In Supabase Dashboard, go to Settings → Database
2. Scroll to Database password
3. Click Reset database password if needed
4. Use that password in the connection string

Step 4: Connect in AnalytAI

In the AnalytAI application:

1. Go to Data Sources → Supabase
2. Paste your complete connection string
3. Click Test Connection
4. Click Next to proceed with schema setup

Important Notes

Connection String Format

• Must use the Session pooler URL (port 5432)
• Do NOT use the Direct connection (port 5432) for production
• Format: postgresql://postgres:password@db.project.supabase.co:5432/postgres

Security

• Your database password is different from your Supabase API key
• Keep your connection string secure
• AnalytAI only needs read access to analyze your data

Troubleshooting

”Connection refused” or “Invalid password”

• Verify your database password is correct
• Make sure you’re using the Session pooler URL (not Direct connection)
• Check if your Supabase project is active

”Host not found”

• Verify the hostname in your connection string matches Supabase dashboard
• Make sure your project hasn’t been paused or deleted

---

That’s it! Supabase setup is complete. Just provide the connection string and AnalytAI will handle the rest. 🚀