Connection URI (recommended)
The easiest way to connect is by using the connection string (URI) method. In Basedash, press Command + K and paste your connection string to start the connection flow immediately. Example (Transaction Pooler):Note: The password is not visible in the Supabase dashboard. Make sure you have access to it—this may be stored in a password manager like 1Password or LastPass, or you may need to contact a teammate who has the credentials.
Tip: Labels and connection methods may differ depending on your hosting provider (GCP, AWS, DigitalOcean, etc.). Always check your provider’s documentation for the latest info.After clicking the “Connect” button in your Supabase project dashboard, you’ll see options for Direct connection, Transaction pooler, and Session pooler. Always use the Transaction Pooler (port 6543) for best performance and compatibility with Basedash.
Manual connection details
If you prefer to enter credentials manually, use the following details (from the Transaction Pooler section):- Go to your Supabase project dashboard
- Click on the “Connect” button in the header
- In the Transaction Pooler section, use these details:
- Host:
[your-project-id].supabase.co
- Port:
6543
(Transaction Pooler port) - Database name:
postgres
- Username: Your database username
- Password: Your database password
- Host:
Important: Always use the Transaction Pooler connection method (port 6543) instead of direct connection (port 5432). The Transaction Pooler provides better connection management and performance for your database queries.
Security
- Basedash encrypts all database credentials and connection information
- All queries are executed through secure, encrypted connections
- You can create a read-only user in Supabase for added security
Next steps
After connecting your Supabase database, you can:- Create charts and dashboards
- Query your data using natural language
- Set up automated reports
- Share insights with your team