databricks-lakebase-provisioned

Manage Databricks Lakebase Provisioned PostgreSQL databases with Unity Catalog and reverse ETL.

Updated Mar 10, 2026

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

Ready to run

npx skills add https://github.com/robkisk/coding-agents-databricks-app --skill databricks-lakebase-provisioned-robkisk

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a managed PostgreSQL database solution within Databricks for transactional workloads, simplifying the integration of OLTP databases with your data lakehouse.

Core Features & Use Cases

Managed PostgreSQL: Fully managed, PostgreSQL-compatible database instances.
Unity Catalog Integration: Register databases for unified governance and access control.
Reverse ETL: Sync data from Delta Lake tables directly into PostgreSQL.
Use Case: Store chat history for a LangChain application or sync customer data from Delta Lake to a PostgreSQL database for a web application's backend.

Quick Start

Use the databricks-lakebase-provisioned skill to create a new Lakebase instance named 'my-oltp-db' with 'CU_1' capacity.

Frequently Asked Questions about databricks-lakebase-provisioned

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

FAQPage Schema

How do I sync data from Delta Lake to a PostgreSQL database for OLTP workloads?▼

You can sync data from Delta Lake to PostgreSQL using reverse ETL, which directly populates managed PostgreSQL database instances for transactional workloads within Databricks Lakebase.

What is Databricks Lakebase managed PostgreSQL used for?▼

Databricks Lakebase is a managed PostgreSQL service for OLTP workloads that simplifies integrating transactional databases with your data lakehouse for applications like web backends or chat history storage.

Can I use Unity Catalog to govern access to a managed PostgreSQL database in Databricks?▼

Yes, you can register your managed PostgreSQL databases with Unity Catalog to enable unified governance and secure access control over your transactional data.

How do I create a provisioned PostgreSQL instance in Databricks Lakebase?▼

You create a provisioned PostgreSQL instance by configuring a named Lakebase database with a specified compute capacity, such as 'CU_1', using OAuth token-based authentication.

Does Databricks Lakebase support OAuth token-based authentication for PostgreSQL?▼

Yes, Databricks Lakebase provisioned PostgreSQL supports OAuth token-based authentication to ensure secure data access and integration with Unity Catalog governance.

What are the limitations of using reverse ETL to sync Delta Lake to PostgreSQL?▼

Reverse ETL in this context focuses on syncing data from Delta Lake tables to PostgreSQL, but users must manage capacity configurations and ensure Unity Catalog integration for secure governance.