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

lakebase-provisioned

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

Updated Mar 10, 2026
Search Tags:#database#postgresql#managed service#databricks#oltp#lakebase#reverse etl
One-click install
npx skills add https://github.com/slysik/databricks-claude-coding --skill lakebase-provisioned-slysik
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lakebase-provisioned
Source: https://github.com/slysik/databricks-claude-coding/tree/main/.agents/skills/lakebase-provisioned
Command: npx skills add https://github.com/slysik/databricks-claude-coding --skill 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 simplifies the process of provisioning, connecting to, and managing Databricks' managed PostgreSQL instances (Lakebase Provisioned) for transactional workloads.

Core Features & Use Cases

  • Managed PostgreSQL: Provides a fully managed PostgreSQL-compatible database integrated with Unity Catalog.
  • OAuth Authentication: Supports secure, token-based authentication with automatic token refresh.
  • Reverse ETL: Enables syncing data from Delta Lake tables to PostgreSQL for OLTP access.
  • Use Case: You are building a Databricks App that requires a persistent, transactional data store for user preferences and session data. This Skill allows you to easily set up and connect to a Lakebase Provisioned instance to serve this purpose.

Quick Start

Use the lakebase-provisioned skill to create a new database instance named 'my-app-db' with 'CU_1' capacity.

Frequently Asked Questions about lakebase-provisioned

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

FAQPage Schema
How do I connect a Databricks App to a managed PostgreSQL database?▼

To connect a Databricks App to managed PostgreSQL, use the Lakebase Provisioned service to create an instance and connect via OAuth token authentication using psycopg or SQLAlchemy for persistent transactional state.

What is reverse ETL from Delta Lake to PostgreSQL used for?▼

Reverse ETL from Delta Lake to PostgreSQL syncs data from Delta tables to an OLTP database, enabling transactional access to lakehouse data for production applications requiring persistent state or LangChain agent memory.

How do I set up OAuth token generation and refresh for a PostgreSQL instance on Databricks?▼

OAuth token generation and refresh for PostgreSQL on Databricks is handled natively by the Lakebase Provisioned service, providing secure token-based authentication for connections via psycopg and SQLAlchemy.

Can I register a managed PostgreSQL instance with Unity Catalog?▼

Yes, Lakebase Provisioned managed PostgreSQL instances integrate directly with Unity Catalog, allowing you to register the database for unified governance alongside your Delta Lake data assets.

Does Lakebase Provisioned support production-grade OLTP workloads?▼

Yes, Lakebase Provisioned supports production-grade OLTP workloads by providing a fully managed PostgreSQL-compatible database with defined capacity units like CU_1 for transactional applications.

What is the best way to use PostgreSQL for LangChain agent memory in Databricks?▼

The best way to use PostgreSQL for LangChain agent memory in Databricks is provisioning a Lakebase instance to serve as a persistent, transactional data store for session data via SQLAlchemy or psycopg.

Related Skills

Explore More Software Engineering Skills→
aaronachermannaaronachermann

databricks-lakebase-provisioned

Provision Lakebase Provisioned PostgreSQL instances and integrate Databricks Apps with OAuth authentication.

Community
Advanced
juanlamadrid20juanlamadrid20

databricks-lakebase-provisioned

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

Community
Intermediate
alessandro9110alessandro9110
4

databricks-lakebase-provisioned

Manage Databricks Lakebase Provisioned PostgreSQL instances with Unity Catalog integration.

Community
Advanced
lucaslessachaveslucaslessachaves
1

databricks-lakebase-provisioned

Provision and manage Lakebase Provisioned PostgreSQL instances with OAuth and Unity Catalog.

Community
Advanced