lakebase-autoscale

Manage Lakebase Autoscaling PostgreSQL projects, branches, and compute via SDK and CLI.

Updated Feb 27, 2026
One-click install
npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill lakebase-autoscale
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: lakebase-autoscale
Source: https://github.com/LaurentPRAT-DB/LPT_claude_config/tree/main/skills/lakebase-autoscale
Command: npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill lakebase-autoscale

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the need for a scalable, cost-effective, and feature-rich PostgreSQL database solution within the Databricks environment, simplifying OLTP workloads.

Core Features & Use Cases

  • Autoscaling Compute: Dynamically adjusts compute resources (0.5-112 CU) based on load, optimizing cost and performance.
  • Branching: Enables Git-like database branching for isolated development, testing, and staging environments.
  • Scale-to-Zero: Suspends compute after inactivity, further reducing costs for non-critical workloads.
  • Use Case: Develop and deploy a web application requiring a PostgreSQL backend. Use branching to create a development environment for new features, test them in isolation, and then merge changes to production without impacting live users.

Quick Start

Create a Lakebase Autoscaling project named 'my-app' with PostgreSQL version 17.

Frequently Asked Questions about lakebase-autoscale

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How does PostgreSQL autoscaling work on Databricks Lakebase?

PostgreSQL autoscaling on Databricks Lakebase dynamically adjusts compute resources between 0.5 and 112 compute units based on load. This optimizes performance and cost for OLTP workloads by automatically scaling capacity up or down.

Can I create isolated PostgreSQL database branches for testing on Databricks?

Yes, you can create Git-like database branches on Databricks Lakebase. This enables isolated PostgreSQL development and testing environments, allowing you to test new features and merge changes to production without impacting live users.

How do I reduce PostgreSQL compute costs for inactive Databricks workloads?

You can reduce PostgreSQL compute costs on Databricks Lakebase using the scale-to-zero feature. It automatically suspends compute resources after periods of inactivity, significantly lowering costs for non-critical or idle workloads.

Does Databricks Lakebase support reverse ETL from Delta Lake to PostgreSQL?

Yes, Databricks Lakebase supports reverse ETL from Delta Lake to PostgreSQL. This allows you to serve OLTP workloads by moving transformed data directly from your data lakehouse into the managed PostgreSQL database.

How do I manage Lakebase PostgreSQL projects and compute via CLI or SDK?

You manage Lakebase PostgreSQL projects, branches, and compute resources using the provided CLI and SDK. This allows programmatic control over your managed database infrastructure, including project creation and compute scaling.

What are the limitations of using managed PostgreSQL on Databricks Lakebase?

Databricks Lakebase is tailored for OLTP workloads and offers scale-to-zero capabilities. While it provides instant restore and branching, its compute scaling limits range from 0.5 to 112 compute units, which may constrain extremely high-performance database demands.