databricks-lakebase-provisioned

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

Updated May 20, 2026
One-click install
npx skills add https://github.com/ice-droid-99/BI-Dashboard-Generation-Agent-in-Databricks- --skill databricks-lakebase-provisioned-ice-droid-99
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-lakebase-provisioned
Source: https://github.com/ice-droid-99/BI-Dashboard-Generation-Agent-in-Databricks-/tree/main/.gemini/skills/databricks-lakebase-provisioned
Command: npx skills add https://github.com/ice-droid-99/BI-Dashboard-Generation-Agent-in-Databricks- --skill databricks-lakebase-provisioned-ice-droid-99

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Lakebase Provisioned patterns help you provision and connect Databricks managed PostgreSQL for transactional (OLTP) workloads without building bespoke infrastructure or brittle authentication flows.

Core Features & Use Cases

  • Lakebase Provisioned setup: Create and manage managed PostgreSQL instances (capacity sizing, regions, lifecycle) for persistent state use cases.
  • OAuth-secured connectivity: Generate short-lived OAuth tokens and connect using SSL with practical connection string patterns.
  • Production-ready token handling & integrations: Refresh tokens for long-running apps, wire Lakebase into Unity Catalog governance, and support reverse ETL from Delta to PostgreSQL for OLTP access patterns.

Quick Start

Ask: "Create a Lakebase Provisioned instance named my-lakebase-instance with capacity CU_1 and show how to generate an OAuth credential token for it."

Frequently Asked Questions about databricks-lakebase-provisioned

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

FAQPage Schema
How do I provision Databricks Lakebase PostgreSQL for OLTP workloads?

To provision Databricks Lakebase PostgreSQL for OLTP workloads, you create a managed instance by specifying a name and capacity size, such as CU_1. This provisions a managed PostgreSQL database for transactional application state.

How do I generate OAuth tokens for Lakebase PostgreSQL connections?

You generate short-lived OAuth tokens for Lakebase PostgreSQL connections that expire every 1 hour. Connections require SSL and must use these tokens for secure authentication instead of static passwords.

Can I sync Delta tables to PostgreSQL for reverse ETL using Lakebase?

Yes, Lakebase Provisioned supports reverse ETL by syncing Delta tables to PostgreSQL. This enables OLTP access patterns using synced tables with appropriate scheduling policies for data movement.

Does Lakebase Provisioned work with Unity Catalog for governance?

Yes, you can wire Lakebase Provisioned instances into Unity Catalog for governance. This registers the managed PostgreSQL resources within your existing Databricks data governance framework.

How do I handle token expiry for long-running apps connected to Lakebase?

For long-running apps connected to Lakebase, you must implement token refresh logic to handle the 1-hour OAuth token expiry. This ensures continuous connectivity without authentication interruptions.

When should I use managed Lakebase PostgreSQL instead of building my own OLTP database?

Use managed Lakebase PostgreSQL when you need persistent state for Databricks Apps, agent memory, or reverse ETL without building bespoke infrastructure or brittle authentication flows for your transactional workloads.