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.