skills.rest
itsadijmbt
itsadijmbtCOMMUNITY
Explore all skills by this author →
GitHub

databricks-lakebase-autoscale

Provision Lakebase Autoscaling PostgreSQL with autoscaling compute and OAuth credentials.

1|Updated Apr 24, 2026
Search Tags:#postgresql#branching#databricks#scale-to-zero#reverse etl#oauth tokens#lakebase autoscaling
One-click install
npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill databricks-lakebase-autoscale-itsadijmbt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-lakebase-autoscale
Source: https://github.com/itsadijmbt/SecureMCP-Servers/tree/main/TEST_SERVERS/PORTED_TO_SECUREMCP/databrickslab-mcp/ai-dev-kit/databricks-skills/databricks-lakebase-autoscale
Command: npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill databricks-lakebase-autoscale-itsadijmbt

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Lakebase Autoscaling knowledge gaps slow teams down when they need reliable managed PostgreSQL for OLTP workloads with autoscaling, scale-to-zero, and safe dev/test branching.

Core Features & Use Cases

  • Project, branch, compute, and credential patterns: Create and manage Lakebase Autoscaling projects, Git-like branches, autoscaling compute endpoints, and OAuth-based database credentials for app connectivity.
  • Operational workflows for dev/test isolation: Spin up expiring development branches or permanent environments, manage protection/TTL, and support rollback-style workflows.
  • Reverse ETL with synced tables: Sync Unity Catalog Delta tables into PostgreSQL via synced tables so applications can query operational data without building custom pipelines.
  • Real-world use cases: Build apps needing persistent PostgreSQL with cost savings (scale-to-zero), implement reverse ETL into OLTP schemas, and connect workloads securely using short-lived OAuth tokens.

Quick Start

Create a Lakebase Autoscaling project named my-app with PostgreSQL 17, then generate an OAuth token for the production endpoint and connect using psycopg with sslmode=require.

Frequently Asked Questions about databricks-lakebase-autoscale

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

FAQPage Schema
How do I provision managed PostgreSQL with scale-to-zero and autoscaling compute limits?▼

You can provision managed PostgreSQL with scale-to-zero by creating a Lakebase Autoscaling project using the Databricks SDK for Python, configuring autoscaling compute limits, and defining endpoints for app connectivity. This provides cost savings for OLTP workloads.

Can I create isolated dev/test PostgreSQL branches with TTL for development workflows?▼

Yes, you can create Git-like isolated PostgreSQL branches with configurable TTL for dev/test workflows. Using the Databricks SDK, you spin up expiring development branches or permanent environments, manage protection settings, and support rollback-style operations.

How do I connect to PostgreSQL using short-lived OAuth tokens and sslmode=require?▼

You connect to PostgreSQL by generating OAuth-based database credentials via the Databricks SDK and using token refresh strategies for 1-hour OAuth tokens. Applications then connect using psycopg with sslmode=require to ensure secure connectivity.

What is reverse ETL through Delta-to-Postgres synced tables in Unity Catalog?▼

Reverse ETL through Delta-to-Postgres synced tables syncs Unity Catalog Delta tables directly into managed PostgreSQL. This allows applications to query operational data from OLTP schemas without building custom data pipelines.

How do I handle long-running operations and endpoint host discovery when provisioning PostgreSQL?▼

You handle long-running operations and endpoint host discovery using the Databricks SDK for Python's w.postgres API. This manages the asynchronous provisioning process and retrieves the endpoint host required for establishing your sslmode=require connections.

Related Skills

Explore More Software Engineering Skills→
teegin-gteegin-g

databricks-lakebase-provisioned

Provision Lakebase PostgreSQL instances and integrate them with Databricks apps.

Community
Advanced
BlackkadderBlackkadder

databricks-lakebase-provisioned

Provision Databricks-managed PostgreSQL instances and generate OAuth tokens.

Community
Advanced
ice-droid-99ice-droid-99

databricks-lakebase-provisioned

Provision Databricks Lakebase Provisioned managed PostgreSQL instances with OAuth and SSL connections.

Community
Intermediate
ScottHMcKeanScottHMcKean

databricks-lakebase-autoscale

Manage Databricks Lakebase PostgreSQL autoscaling, branching, and scale-to-zero compute.

Community
Advanced