databricks-lakebase-autoscale

Configure Lakebase autoscaling, branching, and reverse ETL with Databricks SDK.

11|3|Updated Jun 10, 2025
One-click install
npx skills add https://github.com/Paldom/databricks-apps-fastapi-starter --skill databricks-lakebase-autoscale-paldom
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-lakebase-autoscale
Source: https://github.com/Paldom/databricks-apps-fastapi-starter/tree/main/.gemini/skills/databricks-lakebase-autoscale
Command: npx skills add https://github.com/Paldom/databricks-apps-fastapi-starter --skill databricks-lakebase-autoscale-paldom

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Lakebase Autoscaling patterns and best practices help teams design, implement, and operate scalable Postgres-backed workloads on Lakebase, covering autoscale Compute, branch workflows, and secure credential handling.

Core Features & Use Cases

  • Guidance for configuring autoscaling compute, scale-to-zero, and instant restore on Lakebase
  • Patterns for creating isolated database branches for dev/test and managing credentials via OAuth
  • Reverse ETL workflows using synced tables from Delta Lake to Lakebase for OLTP access

Quick Start

Review the patterns in this skill to implement Lakebase Autoscaling in your Databricks projects.

Frequently Asked Questions about databricks-lakebase-autoscale

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

FAQPage Schema
How do I configure autoscaling compute for Postgres databases on Databricks Lakebase?

Set up Lakebase autoscaling compute by applying scale-to-zero and instant restore patterns to dynamically provision scalable Postgres database resources. The Skill provides configuration guidance for optimizing compute allocation in Databricks Apps projects.

Can I create isolated database branches for dev and test environments in Lakebase?

Yes, you can create isolated database branches for dev/test workflows in Lakebase using dedicated branching patterns. These patterns manage credentials via OAuth and allow safe development and testing against isolated Postgres database copies.

What is reverse ETL and how does it work with Delta Lake and Lakebase?

Reverse ETL syncs tables from Delta Lake to Lakebase to enable OLTP access on Postgres databases. This workflow pattern bridges your data lakehouse and operational databases, allowing downstream applications to query synced Delta Lake data directly.

Do I need Unity Catalog and the Databricks SDK to implement OAuth credential workflows?

Yes, integrating with Delta Lake and Unity Catalog via the Databricks SDK is required to implement secure OAuth-based credential workflows. These security patterns ensure proper access control when configuring Lakebase branching and reverse ETL operations.

When should I use scale-to-zero patterns for Lakebase Postgres workloads?

Use scale-to-zero patterns for Lakebase Postgres workloads during intermittent or non-constant traffic periods to optimize compute costs. The Skill provides best practices for configuring instant restore alongside scale-to-zero to minimize latency on restart.