lakebase-provisioned

Name: lakebase-provisioned
Availability: InStock
Author: laurentprat-db

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

Ready to run

npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill lakebase-provisioned-laurentprat-db

💬 Prompt for ChatGPT / Claude Chat▼

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.