Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
Lakebase Autoscaling is in Beta in the following regions: eastus2, westeurope, westus.
Lakebase Autoscaling is the latest 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 database using various clients and authentication methods. For managing Lakebase infrastructure (creating projects, branches, computes), see Project permissions.
Getting started
| Topic | Description |
|---|---|
| Quickstart | Quickstart guide for connecting with OAuth or Postgres passwords. |
| Connection strings | Connection string formats, components, and network configuration. |
| Framework examples | Code examples for Python, JavaScript, .NET, Go, and other languages. |
| Authentication | OAuth tokens, Postgres passwords, token rotation, and connection timeouts. |
Roles and permissions
Set up database access by creating Postgres roles and granting permissions:
| Topic | Description |
|---|---|
| Manage Postgres roles | Create OAuth and password-based Postgres roles for database access. |
| Manage permissions | Grant database permissions to Postgres roles using SQL GRANT commands. |
Note
Postgres roles control database access (who can query data). For project permissions (who can manage infrastructure), see Manage project permissions.
Postgres clients
Connect to your database using standard PostgreSQL client tools:
| Client | Description |
|---|---|
| psql | PostgreSQL's built-in command-line client for interactive database access. |
| pgAdmin | Graphical administration tool for managing databases and running queries. |
| DBeaver | Universal database tool supporting multiple database types. |
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 |
|---|---|
| SQL Editor | Run queries and manage database objects using the web-based SQL editor. |
| Tables editor | View, edit, and manage data and schemas through a visual interface. |
Private connectivity
| Topic | Description |
|---|---|
| Configure Inbound Private Link | Connect securely through Front-end PrivateLink (beta). |