databricks-lakebase-autoscale

Manage Databricks Lakebase Autoscaling PostgreSQL projects via SDK and CLI.

4|2|Updated Feb 16, 2026

Search Tags:#database #postgresql #branching #autoscaling #databricks #oltp #reverse etl

Ready to run

npx skills add https://github.com/alessandro9110/Speech-To-Text-With-Databricks --skill databricks-lakebase-autoscale-alessandro9110

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: databricks-lakebase-autoscale
Source: https://github.com/alessandro9110/Speech-To-Text-With-Databricks/tree/main/.claude/skills/databricks-lakebase-autoscale
Command: npx skills add https://github.com/alessandro9110/Speech-To-Text-With-Databricks --skill databricks-lakebase-autoscale-alessandro9110

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a managed PostgreSQL database service on Databricks that automatically scales compute resources, offers branching for development workflows, and supports scale-to-zero for cost savings.

Core Features & Use Cases

Autoscaling Compute: Dynamically adjusts compute power (0.5-112 CU) based on load.
Branching: Create isolated database environments for development and testing.
Scale-to-Zero: Suspends compute after inactivity to reduce costs.
Instant Restore: Point-in-time recovery up to 35 days.
Reverse ETL: Sync data from Delta Lake to PostgreSQL.
Use Case: A development team needs to test a new schema change without impacting the production database. They can create a branch from production, make their changes on a dedicated compute, and merge back when ready.

Quick Start

Create a new Lakebase Autoscaling project named 'my-app' with 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 autoscaling PostgreSQL on Databricks, use Lakebase via the Databricks SDK or CLI to create a project specifying PostgreSQL version 16 or 17, enabling dynamic compute adjustments from 0.5 to 112 CU based on load.

How does database branching work for PostgreSQL development workflows?▼

Database branching creates isolated PostgreSQL environments from production using Lakebase, allowing you to test schema changes on dedicated compute and merge back when ready without impacting the primary database.

Can I sync Delta Lake data to PostgreSQL using reverse ETL?▼

Yes, you can sync Delta Lake data to PostgreSQL using the reverse ETL patterns provided by Lakebase Autoscaling, facilitating OLTP workloads directly from your Databricks lakehouse data.

Does managed PostgreSQL on Databricks support scale-to-zero?▼

Yes, Lakebase managed PostgreSQL supports scale-to-zero by suspending compute resources after inactivity, reducing costs while retaining instant restore capabilities for point-in-time recovery up to 35 days.

What is the compute sizing range for OLTP workloads in managed PostgreSQL?▼

Managed PostgreSQL on Databricks supports granular compute sizing for OLTP workloads ranging from 0.5 to 112 CU, dynamically adjusting resources through Lakebase to match application load requirements.