Connect to your database

Learn how to connect to your database using various clients and authentication methods. For managing Lakebase infrastructure (creating projects, branches, computes), see Project permissions.

Connection basics

• • Connection quickstart
  • Connect with OAuth or Postgres passwords.
• • Connection strings
  • Connection string formats, components, and network configuration.
• • Connection pooling
  • Reduce connection overhead with the built-in PgBouncer pooler.
• • 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.

note

Postgres roles control database access (who can query data). For project permissions (who can manage infrastructure), see Manage project permissions.

Connect an application

• • Build applications
  • Databricks Apps or external applications using Postgres drivers.
• • Data API
  • Access your database over HTTP using a PostgREST-compatible REST interface. No Postgres driver required.

Postgres clients

Connect to your database using standard PostgreSQL client tools:

• • 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:

• • 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.

Next steps

• Query your data
• Manage Postgres roles
• Manage permissions