databricks-lakebase-autoscale

Manage Databricks Lakebase Autoscaling projects, branches, compute, and credentials using the Databricks SDK for Python.

Updated Mar 10, 2026
One-click install
npx skills add https://github.com/slysik/databricks-claude-coding --skill databricks-lakebase-autoscale-slysik
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-lakebase-autoscale
Source: https://github.com/slysik/databricks-claude-coding/tree/main/.agents/skills/databricks-lakebase-autoscale
Command: npx skills add https://github.com/slysik/databricks-claude-coding --skill databricks-lakebase-autoscale-slysik

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill simplifies the management of PostgreSQL databases on Databricks by providing autoscaling compute, branching, and scale-to-zero capabilities, reducing operational overhead and optimizing costs.

Core Features & Use Cases

  • Autoscaling Compute: Dynamically adjusts compute resources (0.5-112 CU) based on workload.
  • Branching: Create isolated database environments for development and testing.
  • Scale-to-Zero: Suspends compute after inactivity to save costs.
  • Instant Restore: Point-in-time recovery up to 35 days.
  • Reverse ETL: Sync data from Delta Lake to PostgreSQL.
  • Use Case: A data engineering team needs to provide a PostgreSQL database for a new application that experiences variable load. They can use this skill to provision a Lakebase Autoscaling instance that automatically scales up during peak hours and scales down to zero during off-hours, minimizing costs while ensuring performance.

Quick Start

Use the databricks-lakebase-autoscale skill to create a new project named 'my-app' with display name 'My Application' using PostgreSQL version 17.

Frequently Asked Questions about databricks-lakebase-autoscale

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

FAQPage Schema
How do I set up autoscaling for PostgreSQL on Databricks?

To set up PostgreSQL autoscaling on Databricks, use this Skill to provision a Lakebase instance that dynamically adjusts compute resources between 0.5 and 112 compute units based on your workload demands.

Can I sync data from Delta Lake to a PostgreSQL database?

Yes, you can sync data from Delta Lake to PostgreSQL using the reverse ETL functionality, which utilizes synced tables to push your lakehouse data directly into your managed OLTP PostgreSQL database.

What is the best way to create isolated PostgreSQL environments for development?

The best way to create isolated PostgreSQL environments is by using Git-like branching capabilities, allowing you to spawn independent database branches for development and testing without provisioning new infrastructure.

Does Databricks Lakebase support scale-to-zero functionality for PostgreSQL?

Yes, Databricks Lakebase supports scale-to-zero functionality, automatically suspending your PostgreSQL compute resources after periods of inactivity to minimize operational costs during off-hours.

How does point-in-time recovery work for managed PostgreSQL?

Point-in-time recovery for managed PostgreSQL works by enabling instant restore capabilities up to 35 days, allowing you to revert your database to a specific state to recover from data loss or corruption.

Do I need the Databricks SDK for Python to manage Lakebase compute?

Yes, you need the Databricks SDK for Python to manage Lakebase compute, as it handles the core operations for project, branch, compute, and credential management within the autoscaling service.