Connect to your database
Lakebase Autoscaling is available in the following regions: us-east-1, us-east-2, eu-central-1, eu-west-1, eu-west-2, ap-south-1, ap-southeast-1, ap-southeast-2.
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
-
- 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:
-
- 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.
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:
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:
-
- 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
-
- Configure Inbound PrivateLink
- Connect securely through Front-end PrivateLink (beta).