Connect to your database
This feature is in Public Preview in the following regions: us-east-1, us-west-2, eu-west-1.
Lakebase Autoscaling is the new version of Lakebase with autoscaling compute, scale-to-zero, branching, and instant restore. For feature comparison with Lakebase Provisioned, see choosing between versions.
Learn how to connect to your Lakebase Postgres project using various clients and authentication methods.
Getting started
Topic | Description |
|---|---|
Understand connection strings, authentication methods, and how to connect from apps and frameworks. | |
Learn about OAuth tokens and Postgres password authentication, including token expiration and connection timeouts. | |
Grant and manage permissions to control who can access and manage project resources. |
Postgres clients
Connect to your database using standard PostgreSQL client tools:
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. |
For more information about using Postgres clients, see Postgres clients.
Built-in tools
Use Lakebase's built-in tools to query and manage your database:
Tool | Description |
|---|---|
Run queries, manage database objects, and explore your data using the web-based SQL editor. | |
View, edit, and manage data and schemas through a visual interface. |
Private connectivity
Topic | Description |
|---|---|
Lakebase Postgres Autoscaling supports connectivity through Databricks Front-end PrivateLink. Front-end PrivateLink support for Lakebase Postgres Autoscaling is currently in private preview. Contact your Databricks Account Team to enroll. |