skills.rest
thbeh
thbehCOMMUNITY
Explore all skills by this author →
GitHub

databricks-lakebase-provisioned

Manage PostgreSQL OLTP workloads in Databricks with Unity Catalog governance.

Updated May 31, 2026
Search Tags:#postgresql#databricks#oltp#lakebase#unity catalog
One-click install
npx skills add https://github.com/thbeh/coding-agents-databricks-apps --skill databricks-lakebase-provisioned-thbeh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-lakebase-provisioned
Source: https://github.com/thbeh/coding-agents-databricks-apps/tree/main/.claude/skills/databricks-lakebase-provisioned
Command: npx skills add https://github.com/thbeh/coding-agents-databricks-apps --skill databricks-lakebase-provisioned-thbeh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires databricks-sdk[python], and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill solves the problem of using Lakebase Provisioned as a PostgreSQL database service in Databricks for OLTP workloads, providing a fully managed solution for transactional applications.

Core Features & Use Cases

  • OLTP Workload Support: Ideal for applications requiring a PostgreSQL database for transactional workloads.
  • Integrates with Unity Catalog: Ensures governance and compliance with data access permissions.
  • Reverse ETL: Offers seamless data syncing from Delta Lake to operational databases.
  • Apps Integration: Provides support in Databricks Apps for enhanced usability.
  • Use Case: If you are looking to create a dashboard or an application that needs real-time transactional data access in Databricks, this Skill is designed for you.

Quick Start

Create a Lakebase Provisioned instance with databricks database create-database-instance.

Frequently Asked Questions about databricks-lakebase-provisioned

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

FAQPage Schema
How do I set up a managed PostgreSQL database for OLTP workloads in Databricks?▼

You can provision a managed PostgreSQL database for OLTP workloads in Databricks by creating a Lakebase Provisioned instance using the command `databricks database create-database-instance`, which provides a fully managed solution for transactional applications.

What is the best way to sync data between Delta Lake and an operational PostgreSQL database?▼

The best way to sync data between Delta Lake and an operational PostgreSQL database is using Lakebase Provisioned, which performs reverse ETL to seamlessly sync data while leveraging Unity Catalog for governance and data access permissions.

Do I need OAuth authentication to use a PostgreSQL database service in Databricks?▼

Yes, you need OAuth authentication to interact with Lakebase Provisioned instances, alongside the Databricks SDK for Python, to securely access the managed PostgreSQL service for your transactional workloads.

Can I use Databricks Apps with a managed PostgreSQL service for real-time transactional data access?▼

Yes, Lakebase Provisioned integrates with Databricks Apps to provide support for applications and dashboards requiring real-time transactional data access, ensuring governance through Unity Catalog.

Does Lakebase Provisioned support data governance for operational databases?▼

Yes, Lakebase Provisioned integrates with Unity Catalog to ensure governance and compliance for operational PostgreSQL databases, managing data access permissions across your Databricks environment.

Related Skills

Explore More Software Engineering Skills→
JingyiWngJingyiWng

databricks-lakebase-provisioned

Provision and manage Lakebase PostgreSQL databases with OAuth token authentication.

Community
Advanced
LaurentPRAT-DBLaurentPRAT-DB

lakebase-provisioned

Create and connect to Lakebase Provisioned PostgreSQL databases on Databricks with Python SDK and psycopg.

Community
Intermediate
datasciencemonkeydatasciencemonkey
27

databricks-lakebase-provisioned

Provision Lakebase PostgreSQL instances with OAuth and Unity Catalog integration.

Community
Advanced
leary-pokenleary-poken
1

databricks-lakebase-provisioned

Configure Lakebase Provisioned for OLTP workloads with Unity Catalog governance.

Community
Intermediate