skills.rest
alessandro9110
alessandro9110COMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/alessandro9110/Speech-To-Text-With-Databricks --skill databricks-lakebase-autoscale-alessandro9110
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
juanlamadrid20juanlamadrid20

databricks-lakebase-autoscale

Manage Databricks Lakebase Autoscaling projects, branches, compute, and credentials.

Community
Advanced
Zack2626-okZack2626-ok

databricks-lakebase-provisioned

Create managed PostgreSQL instances within Databricks Lakebase for OLTP workloads.

Community
Advanced
datasciencemonkeydatasciencemonkey
27

databricks-lakebase-autoscale

Configure Lakebase Autoscaling compute, branching, and instant restore for PostgreSQL-backed apps.

Community
Advanced
Aradhya0510Aradhya0510
3

databricks-lakebase-autoscale

Manage Databricks Lakebase autoscaling PostgreSQL projects via the Databricks SDK.

Community
Advanced