Connect to your database
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.
Learn how to connect to your Lakebase Postgres database 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. |
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 |
|---|---|
Enable private network connectivity using AWS Service-Direct Front-end PrivateLink to keep database traffic within your private network. |
Next steps
- Query your data - Explore different ways to query your Lakebase database
- Manage Postgres roles - Create and manage roles for database access
- Manage permissions - Grant database permissions to Postgres roles