databricks-lakebase-provisioned

Provision Databricks-managed PostgreSQL instances and generate OAuth tokens.

Updated Mar 19, 2026
One-click install
npx skills add https://github.com/Blackkadder/databricks-apps-and-agents-workshop --skill databricks-lakebase-provisioned-blackkadder
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-lakebase-provisioned
Source: https://github.com/Blackkadder/databricks-apps-and-agents-workshop/tree/main/.claude/skills/databricks-lakebase-provisioned
Command: npx skills add https://github.com/Blackkadder/databricks-apps-and-agents-workshop --skill databricks-lakebase-provisioned-blackkadder

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides patterns and operational guidance to provision and connect Databricks-managed PostgreSQL instances so applications and notebooks can securely use a low-latency OLTP store.

Core Features & Use Cases

  • Instance lifecycle management: Create, start, stop, and delete Lakebase Provisioned instances with recommended capacity sizing.
  • Secure OAuth authentication: Generate short-lived tokens for notebook and app connections with patterns for automatic token refresh.
  • Reverse ETL & App integration: Configure synced tables from Unity Catalog to Lakebase for low-latency app queries and persist agent/chat memory for LangChain applications.
  • Use Case: Sync a Unity Catalog Delta table to a provisioned Lakebase instance for a web application product catalog with continuous or triggered updates and token-managed app access.

Quick Start

Create a Lakebase Provisioned instance named "my-lakebase-instance", return its read_write_dns, and generate an OAuth token to connect from a notebook.

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 a managed PostgreSQL instance on Databricks for OLTP workloads?▼

You can provision a managed PostgreSQL instance on Databricks by creating and starting a Lakebase Provisioned instance with recommended capacity sizing. This returns a read_write_dns endpoint for connecting your notebooks and applications to the low-latency OLTP store.

How do I get an OAuth token to connect my Databricks notebook to a PostgreSQL database?▼

You generate a short-lived OAuth token to securely connect your Databricks notebook to a PostgreSQL database. The setup includes patterns for automatic token refresh to maintain continuous access using one-hour credentials.

Can I sync a Unity Catalog Delta table to PostgreSQL for low-latency app queries?▼

Yes, you can configure reverse ETL to sync a Unity Catalog Delta table to a provisioned PostgreSQL instance. This enables low-latency application queries against synced tables with continuous or triggered updates and token-managed access.

Does Databricks managed PostgreSQL work with LangChain agent memory storage?▼

Yes, Databricks managed PostgreSQL supports LangChain applications by providing a low-latency OLTP store. You can persist agent and chat memory securely using OAuth tokens generated for your application connections.

What are the connection requirements for Databricks managed PostgreSQL instances?▼

Connections to Databricks managed PostgreSQL instances require SSL and use OAuth tokens for secure authentication. You must register the instance with Unity Catalog and implement periodic token refresh for one-hour credentials.

How do I manage the lifecycle of a PostgreSQL instance on Databricks?▼

You manage the full lifecycle of a PostgreSQL instance on Databricks by creating, starting, stopping, and deleting Lakebase Provisioned instances. This includes recommended capacity sizing and Unity Catalog registration for secure application access.