How do I connect the SQL agent to a Supabase database for proper querying?

Make sure you’re using the proper connection details for your Supabase project. Here’s what you should do:

1. Get the Connection String

   • Log into your Supabase Dashboard and select your project.
   • Navigate to Database settings.
   • Under Connection string, ensure that Use connection pooling is enabled (unless you specifically need the direct connection string with pooling disabled).
   • Copy the URI and replace the password placeholder with your actual database password.

2. Use the URI in Your SQL Agent
   Rather than using any other connection settings, point your SQL agent to this exact connection string. This ensures you’re connecting to your live Supabase database and not to any sample or default database.

For example, your environment variable might look like this:

BASHCopied
export DATABASE_URL=postgres://postgres.your_project:your_actualpassword@yourproject.pooler.supabase.com:5432/postgres

3. Verify Sample Data Issue
   If you’re still seeing sample data:
   • Double-check that you’re not connecting to a default database created by a different project.
   • Confirm that the actual data exists in your project’s tables (using the Supabase Dashboard to inspect your tables can help).

Following these steps should establish the correct connection between your SQL agent and your Supabase database, giving you access to the actual data.