skills.rest
slysik
slysikCOMMUNITY
Explore all skills by this author →
GitHub

databricks-lakebase-provisioned

Provision and manage Databricks Lakebase Provisioned PostgreSQL instances with Python SDK.

Updated Mar 10, 2026
Search Tags:#postgresql#databricks#oltp#lakebase#reverse etl#managed database
One-click install
npx skills add https://github.com/slysik/databricks-claude-coding --skill databricks-lakebase-provisioned-slysik
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-lakebase-provisioned
Source: https://github.com/slysik/databricks-claude-coding/tree/main/.claude/skills/databricks-lakebase-provisioned
Command: npx skills add https://github.com/slysik/databricks-claude-coding --skill databricks-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 provides patterns and best practices for leveraging Databricks-managed PostgreSQL (Lakebase Provisioned) for Online Transaction Processing (OLTP) workloads, enabling persistent state and efficient data synchronization.

Core Features & Use Cases

  • Managed PostgreSQL: Fully managed, PostgreSQL-compatible database integrated with Unity Catalog.
  • OAuth Authentication: Secure, token-based authentication with Databricks SDK.
  • Reverse ETL: Sync data from Delta Lake to PostgreSQL.
  • Use Case: Integrate Lakebase Provisioned into a Databricks App to store chat memory for a LangChain application, ensuring persistent state for agent interactions.

Quick Start

Create and connect to a Lakebase Provisioned instance using the Databricks SDK for Python.

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 managed PostgreSQL for OLTP workloads on Databricks?▼

Lakebase Provisioned offers a fully managed PostgreSQL database integrated with Unity Catalog, designed specifically to handle OLTP workloads and persistent state within the Databricks ecosystem.

Can I sync data from Delta Lake to PostgreSQL using reverse ETL?▼

Yes, you can execute reverse ETL synchronization to sync data directly from Delta Lake to your managed PostgreSQL database, ensuring downstream transactional systems have current lakehouse data.

How does OAuth authentication work for Databricks managed PostgreSQL connections?▼

Yes, Lakebase Provisioned supports secure OAuth authentication via the Databricks SDK, utilizing token-based connection management with automated token refresh to maintain secure database access.

Can I integrate a managed PostgreSQL database with Databricks Apps for LangChain agent memory?▼

Yes, you can integrate Lakebase Provisioned into Databricks Apps to store chat memory for LangChain applications, providing persistent state for agent interactions.

Do I need the Databricks SDK to provision and manage a Lakebase PostgreSQL instance?▼

You need either the Databricks SDK for Python or the CLI to provision and manage the Lakebase PostgreSQL instance, alongside dependencies like psycopg and sqlalchemy for connectivity.

Related Skills

Explore More Software Engineering Skills→
LaurentPRAT-DBLaurentPRAT-DB

lakebase-provisioned

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

Community
Intermediate
ScottHMcKeanScottHMcKean

databricks-lakebase-provisioned

Manage Databricks Lakebase Provisioned PostgreSQL databases for OLTP workloads.

Community
Intermediate
teegin-gteegin-g

databricks-lakebase-provisioned

Provision Lakebase PostgreSQL instances and integrate them with Databricks apps.

Community
Advanced
Aradhya0510Aradhya0510
3

databricks-lakebase-provisioned

Configure Lakebase Provisioned PostgreSQL instances with OAuth and Unity Catalog.

Community
Intermediate