Docs

These guides describe QuackDB 1.0, the previous version. Screens and some features differ in the new native Mac version, which has its own guides.

Go to the new guidesGet the previous version
Docs/Database Connections (1.0)/Supabase

Connect QuackDB 1.0 to a Supabase database

Connect QuackDB 1.0 to the PostgreSQL database behind a Supabase project.

Supabase is an open-source Firebase alternative built on PostgreSQL. QuackDB provides native support for connecting to Supabase databases with automatic SSL configuration.

Connecting to Supabase in QuackDB

Getting Your Connection Details

1

Open Supabase Dashboard

Go to your project at app.supabase.com

2

Navigate to Database Settings

Go to Settings → Database in the sidebar

3

Copy Connection Info

Find the "Connection string" section and copy the details

Connection Settings

FieldValue
Hostdb.[project-ref].supabase.co
Port5432
Databasepostgres
Usernamepostgres
PasswordYour database password (set during project creation)
SSLRequired

Pooler vs Direct Connection

Supabase offers two connection modes. For desktop applications like QuackDB, we recommend the direct connection.

Direct Connection

Recommended for QuackDB

Port: 5432

Pooler (Transaction)

For serverless/edge functions

Port: 6543

Supabase-Specific Features

Access all PostgreSQL schemas (public, auth, storage, etc.)
Browse Supabase system tables
Full PostgreSQL 15 feature support
RLS policies visible in table properties

⚠️Password Security: If you've forgotten your database password, you can reset it in the Supabase dashboard under Settings → Database → Reset database password.

Your Supabase credentials are encrypted and stored securely using your OS keychain. They are never transmitted except to establish the database connection.

Need help?

Join our Discord community for support and discussions.

Join Discord