skills.rest
Paldom
PaldomCOMMUNITY
Explore all skills by this author →
GitHub

lakebase-provisioned

Manage Databricks Lakebase Provisioned PostgreSQL instances with OAuth and reverse ETL.

1|1|Updated Nov 9, 2025
Search Tags:#database#postgresql#databricks#lakebase#reverse etl#olt p
One-click install
npx skills add https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter --skill lakebase-provisioned-paldom
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lakebase-provisioned
Source: https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter/tree/main/.agents/skills/lakebase-provisioned
Command: npx skills add https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter --skill lakebase-provisioned-paldom

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the need for a managed, PostgreSQL-compatible relational database within the Databricks ecosystem, enabling transactional workloads and data synchronization from the lakehouse.

Core Features & Use Cases

  • Managed PostgreSQL: Provides a fully managed PostgreSQL database service.
  • OAuth Authentication: Supports secure, token-based authentication with automatic refresh.
  • Reverse ETL: Enables syncing data from Delta Lake tables into PostgreSQL.
  • Use Case: Integrate a transactional database for your Databricks App, store chat history for LangChain agents, or implement reverse ETL to feed operational dashboards from your Delta tables.

Quick Start

Create a new Lakebase Provisioned instance named 'my-lakebase-instance' 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 provision a managed PostgreSQL database for Databricks OLTP workloads?▼

You can provision a managed PostgreSQL database for Databricks OLTP by creating a Lakebase Provisioned instance. This facilitates transactional workload creation and connection directly within the Databricks ecosystem.

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

Yes, reverse ETL enables syncing data from Delta Lake tables directly into PostgreSQL. This allows you to feed operational dashboards and serve transactional data from your lakehouse.

Does this managed PostgreSQL service support OAuth token generation and refresh?▼

Yes, the managed PostgreSQL service supports secure OAuth token generation and automatic refresh. This ensures secure, token-based authentication for accessing your Databricks Lakebase instances.

How do I integrate a transactional database with my Databricks App?▼

You can integrate a transactional database with your Databricks App by provisioning a PostgreSQL instance. It also supports storing chat history for LangChain agents and Unity Catalog integration.

What is the best way to declare MLflow model resources for a PostgreSQL instance?▼

The best way to declare MLflow model resources is through the Lakebase Provisioned instance management capabilities. This supports MLflow model resource declarations alongside Unity Catalog integration.

Can I use Unity Catalog with a provisioned PostgreSQL database in Databricks?▼

Yes, you can use Unity Catalog with a provisioned PostgreSQL database. The service supports Unity Catalog integration to govern your data alongside secure OAuth access and reverse ETL processes.

Related Skills

Explore More Software Engineering Skills→
thbehthbeh

databricks-lakebase-provisioned

Manage PostgreSQL OLTP workloads in Databricks with Unity Catalog governance.

Community
Advanced
slysikslysik

lakebase-provisioned

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

Community
Advanced
JingyiWngJingyiWng

databricks-lakebase-provisioned

Provision and manage Lakebase PostgreSQL databases with OAuth token authentication.

Community
Advanced
LaurentPRAT-DBLaurentPRAT-DB

lakebase-provisioned

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

Community
Intermediate