PostgreSQL

PostgreSQL Driver

Use the PostgreSQL driver when you want streaming query results, schema browsing, and PostgreSQL-aware autocomplete inside VS Code.

Default connection fields

Field	Default	Description
Host	Required	PostgreSQL host
Port	5432	Standard PostgreSQL port
Database	Optional but recommended	Default database for the connection
Schema	Optional	Default schema, often public or an app-specific schema
User	Optional	PostgreSQL user name
Password	Optional	Stored in VS Code SecretStorage
SSL / TLS	false	Turn on when your endpoint requires TLS
Verify server certificate	true	Keep enabled for normal production use
Max pooled connections	Driver default	Optional pool cap
Timeout	Inherits global default	Per-connection timeout override in seconds

Recommended setup

• Set the default database so DBeagle can open with the right context.
• Set the default schema if your day-to-day work lives outside public.
• Use Select Active Schemas after connecting if you want autocomplete and tree browsing to focus on a narrower subset.

How PostgreSQL appears in DBeagle

Internally, DBeagle maps the connected PostgreSQL database into its shared catalog slot and keeps schemas as-is. In practice, the tree feels natural:

• database
• schema
• table or view
• column

Notes

• PostgreSQL uses streaming query execution for large result sets.
• Query cancellation and timeout handling map cleanly into the shared DBeagle execution flow.
• Schema selection affects both tree browsing and metadata-backed autocomplete.