skills.rest
LaurentPRAT-DB
LaurentPRAT-DBCOMMUNITY
Explore all skills by this author →
GitHub

lakebase-provisioned

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

Updated Feb 27, 2026
Search Tags:#postgresql#databricks#oltp#lakebase#reverse etl#managed database
One-click install
npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill lakebase-provisioned-laurentprat-db
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lakebase-provisioned
Source: https://github.com/LaurentPRAT-DB/LPT_claude_config/tree/main/skills/lakebase-provisioned
Command: npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill lakebase-provisioned-laurentprat-db

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 a managed PostgreSQL database solution directly within Databricks, enabling efficient OLTP workloads and seamless integration with your data lakehouse.

Core Features & Use Cases

  • Managed PostgreSQL: Fully managed, PostgreSQL-compatible database instances.
  • Databricks Integration: Connects with Unity Catalog, supports OAuth authentication, and integrates with Databricks Apps.
  • Use Case: Use Lakebase Provisioned to add persistent state to your Databricks Apps, implement reverse ETL from Delta Lake to an operational database, or store chat/agent memory for LangChain applications.

Quick Start

Create and connect to a Lakebase Provisioned instance using the provided Python SDK example.

Frequently Asked Questions about lakebase-provisioned

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

FAQPage Schema
How do I run OLTP workloads with a managed PostgreSQL database on Databricks?▼

You can run OLTP workloads by using Lakebase Provisioned to deploy a managed PostgreSQL database directly on Databricks, enabling seamless integration with your data lakehouse for transactional applications.

What is reverse ETL from Delta Lake to an operational database?▼

Reverse ETL from Delta Lake to an operational database involves moving processed analytical data back to transactional systems. Lakebase Provisioned supports this by providing a managed PostgreSQL endpoint for your Databricks pipelines.

Can I use a managed PostgreSQL database to store chat memory for LangChain applications on Databricks?▼

Yes, you can use Lakebase Provisioned as a persistent state backend to store chat and agent memory for LangChain applications deployed within Databricks Apps, leveraging PostgreSQL for reliable session data.

How do I connect to a managed PostgreSQL instance on Databricks using Python?▼

You connect to a managed PostgreSQL instance on Databricks using the Databricks SDK for Python to handle OAuth authentication and the psycopg library to establish the actual database connection.

Does Lakebase Provisioned support Unity Catalog and OAuth authentication?▼

Yes, Lakebase Provisioned integrates directly with Unity Catalog for centralized governance and uses OAuth authentication to securely connect your managed PostgreSQL instances with Databricks Apps.

What are the limitations of using SQLAlchemy with a managed PostgreSQL database on Databricks?▼

When using SQLAlchemy with a managed PostgreSQL database on Databricks, limitations include relying on psycopg for underlying connectivity and ensuring OAuth tokens are properly managed for Databricks integration.

Related Skills

Explore More Software Engineering Skills→
thbehthbeh

databricks-lakebase-provisioned

Manage PostgreSQL OLTP workloads in Databricks with Unity Catalog governance.

Community
Advanced
leary-pokenleary-poken
1

databricks-lakebase-provisioned

Configure Lakebase Provisioned for OLTP workloads with Unity Catalog governance.

Community
Intermediate
juanlamadrid20juanlamadrid20

databricks-lakebase-provisioned

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

Community
Intermediate
robkiskrobkisk

databricks-lakebase-provisioned

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

Community
Advanced