lakebase-provisioned

Provision Lakebase Provisioned PostgreSQL instances and connect via psycopg or SQLAlchemy.

Updated Mar 10, 2026

Search Tags:#database #postgresql #managed service #databricks #oltp #lakebase #reverse etl

Ready to run

npx skills add https://github.com/slysik/databricks-claude-coding --skill lakebase-provisioned-slysik

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: lakebase-provisioned
Source: https://github.com/slysik/databricks-claude-coding/tree/main/.agents/skills/lakebase-provisioned
Command: npx skills add https://github.com/slysik/databricks-claude-coding --skill lakebase-provisioned-slysik

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires databricks-sdk, psycopg, sqlalchemy, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the process of provisioning, connecting to, and managing Databricks' managed PostgreSQL instances (Lakebase Provisioned) for transactional workloads.

Core Features & Use Cases

Managed PostgreSQL: Provides a fully managed PostgreSQL-compatible database integrated with Unity Catalog.
OAuth Authentication: Supports secure, token-based authentication with automatic token refresh.
Reverse ETL: Enables syncing data from Delta Lake tables to PostgreSQL for OLTP access.
Use Case: You are building a Databricks App that requires a persistent, transactional data store for user preferences and session data. This Skill allows you to easily set up and connect to a Lakebase Provisioned instance to serve this purpose.

Quick Start

Use the lakebase-provisioned skill to create a new database instance named 'my-app-db' with 'CU_1' capacity.

Frequently Asked Questions about lakebase-provisioned

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

FAQPage Schema

How do I connect a Databricks App to a managed PostgreSQL database?▼

To connect a Databricks App to managed PostgreSQL, use the Lakebase Provisioned service to create an instance and connect via OAuth token authentication using psycopg or SQLAlchemy for persistent transactional state.

What is reverse ETL from Delta Lake to PostgreSQL used for?▼

Reverse ETL from Delta Lake to PostgreSQL syncs data from Delta tables to an OLTP database, enabling transactional access to lakehouse data for production applications requiring persistent state or LangChain agent memory.

How do I set up OAuth token generation and refresh for a PostgreSQL instance on Databricks?▼

OAuth token generation and refresh for PostgreSQL on Databricks is handled natively by the Lakebase Provisioned service, providing secure token-based authentication for connections via psycopg and SQLAlchemy.

Can I register a managed PostgreSQL instance with Unity Catalog?▼

Yes, Lakebase Provisioned managed PostgreSQL instances integrate directly with Unity Catalog, allowing you to register the database for unified governance alongside your Delta Lake data assets.

Does Lakebase Provisioned support production-grade OLTP workloads?▼

Yes, Lakebase Provisioned supports production-grade OLTP workloads by providing a fully managed PostgreSQL-compatible database with defined capacity units like CU_1 for transactional applications.

What is the best way to use PostgreSQL for LangChain agent memory in Databricks?▼

The best way to use PostgreSQL for LangChain agent memory in Databricks is provisioning a Lakebase instance to serve as a persistent, transactional data store for session data via SQLAlchemy or psycopg.