skills.rest
juanlamadrid20
juanlamadrid20COMMUNITY
Explore all skills by this author →
GitHub

databricks-lakebase-provisioned

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

Updated Mar 12, 2026
Search Tags:#database#postgresql#databricks#oltp#lakebase#reverse etl
One-click install
npx skills add https://github.com/juanlamadrid20/coda --skill databricks-lakebase-provisioned-juanlamadrid20
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-lakebase-provisioned
Source: https://github.com/juanlamadrid20/coda/tree/main/.claude/skills/databricks-lakebase-provisioned
Command: npx skills add https://github.com/juanlamadrid20/coda --skill databricks-lakebase-provisioned-juanlamadrid20

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 OLTP workloads and persistent state for applications.

Core Features & Use Cases

  • Managed PostgreSQL: Fully managed, PostgreSQL-compatible database service.
  • Unity Catalog Integration: Register databases for governance and access control.
  • Reverse ETL: Sync data from Delta Lake to 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 PostgreSQL database 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 run OLTP workloads with a managed PostgreSQL database in Databricks?▼

You can run OLTP workloads by using Databricks Lakebase Provisioned to create and manage a fully managed PostgreSQL database instance directly within your Databricks environment.

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

Yes, reverse ETL from Delta Lake to PostgreSQL is supported, enabling you to sync data like customer records to a PostgreSQL backend for web applications.

Does Databricks Lakebase integrate with Unity Catalog for database governance?▼

Databricks Lakebase integrates with Unity Catalog, allowing you to register your managed PostgreSQL databases for centralized governance and access control.

How do I store persistent chat history for a LangChain application in Databricks?▼

You can store persistent chat history for LangChain applications by provisioning a managed PostgreSQL database via Databricks Lakebase, providing a reliable state backend.

What do I need to connect to a provisioned PostgreSQL instance in Databricks?▼

You need the databricks-sdk, psycopg, and sqlalchemy dependencies to facilitate creation, configuration, and connection to your provisioned PostgreSQL instances.

When should I use provisioned PostgreSQL instead of standard Databricks SQL?▼

Use provisioned PostgreSQL when your Databricks applications require OLTP workloads, persistent state, or a relational database backend rather than analytical SQL queries.

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
slysikslysik

lakebase-provisioned

Provision Lakebase Provisioned PostgreSQL instances and connect via psycopg or SQLAlchemy.

Community
Advanced
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