Postgres clients
Lakebase Postgres (Autoscaling Beta) is the next version of Lakebase, available for evaluation only. For production workloads, use Lakebase Public Preview. See choosing between versions to understand which version is right for you.
You can connect to your Lakebase database project using any standard PostgreSQL client or tool. This includes command-line tools like psql and GUI applications like pgAdmin and DBeaver.
Authentication
For the best experience with third-party Postgres clients, we recommend using native Postgres password authentication. This method uses traditional Postgres roles with database passwords that don't expire hourly, making them well-suited for client tools and long-running sessions.
Native Postgres passwords are widely supported across all Postgres tools and clients, and they're better suited for applications that cannot refresh credentials frequently. See Authentication overview for details about authentication methods.
To set up native Postgres password authentication, create a Postgres role with a password. See Manage Postgres roles for instructions.
Available clients
Choose the Postgres client that best fits your workflow:
Client | Description |
|---|---|
PostgreSQL's built-in command-line client. Provides direct, interactive access to your database with full Postgres functionality. | |
Open source graphical administration tool. Offers a visual interface for managing databases, running queries, and monitoring performance. | |
Universal database management tool. Supports multiple database types with a rich set of features for database administration. | |
Open source performance monitoring tool. Lightweight Docker-based dashboard for identifying slow queries and optimizing database performance. |
Connection details
All Postgres clients require the same basic Postgres database connection information, which you can obtain from the Lakebase App:
- Navigate to the Lakebase App and select your database project
- Click Connect to open the database connection modal
- Select the branch, compute, and database you want to connect to
- Select a Postgres role (we recommend using a native Postgres role with password authentication)
- Copy the connection details
The connection information includes:
- Host: Your compute endpoint hostname (e.g.,
ep-abc-123.databricks.com) - Port:
5432(default Postgres port) - Database: Your database name (e.g.,
databricks_postgres) - User: Your Postgres role name
- Password: Your Postgres role password
For more information about connection strings and authentication, see Connect to your database project.