skills.rest
robkisk
robkiskCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/robkisk/coding-agents-databricks-app --skill databricks-lakebase-provisioned-robkisk
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
teegin-gteegin-g

databricks-lakebase-provisioned

Provision Lakebase PostgreSQL instances and integrate them with Databricks apps.

Community
Advanced
Zack2626-okZack2626-ok

databricks-lakebase-provisioned

Create managed PostgreSQL instances within Databricks Lakebase for OLTP workloads.

Community
Advanced
juanlamadrid20juanlamadrid20

databricks-lakebase-provisioned

Create and configure managed PostgreSQL databases in Databricks with Unity Catalog integration.

Community
Intermediate
thbehthbeh

databricks-lakebase-provisioned

Manage PostgreSQL OLTP workloads in Databricks with Unity Catalog governance.

Community
Advanced