Query your data

Beta

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 query and work with data in your Lakebase Postgres database. Lakebase provides several methods to access and query your data, each suited for different use cases and workflows.

note

Before querying, make sure you've connected to your database and obtained an OAuth token for authentication.

Method	Description
Query your database from the Lakebase SQL Editor	Execute SQL queries directly in the Lakebase App with an integrated editor. Ideal for quick queries, data exploration, and development work.
Managing data with the Tables editor	Visually manage your data and schemas with an interactive interface. Add, edit, and delete records, manage schemas and tables, and export data in JSON or CSV format.
Postgres clients	Connect using Postgres clients like psql, DBeaver, and pgAdmin. Use when you prefer your existing tools and workflows.
Time travel	Query your database as it existed at any point in the past by creating branches with historical data. Use for analyzing data changes and recovering specific values from before recent modifications.