skills.rest
itsadijmbt
itsadijmbtCOMMUNITY
Explore all skills by this author →
GitHub

databricks-lakebase-provisioned

Provisions Datasabot Lakebase Provisioned instances and generates OAuth credentials for PostgreSQL access.

1|Updated Apr 24, 2026
Search Tags:#postgresql#databricks#lakebase#unity catalog#reverse etl#oauth token
One-click install
npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill databricks-lakebase-provisioned-itsadijmbt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-lakebase-provisioned
Source: https://github.com/itsadijmbt/SecureMCP-Servers/tree/main/TEST_SERVERS/PORTED_TO_SECUREMCP/databrickslab-mcp/ai-dev-kit/databricks-skills/databricks-lakebase-provisioned
Command: npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill databricks-lakebase-provisioned-itsadijmbt

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you set up and operate Databricks Lakebase Provisioned (managed PostgreSQL) so you can build low-latency OLTP systems on top of your Databricks data products.

Core Features & Use Cases

  • OAuth-based PostgreSQL access: generate short-lived tokens and connect using psycopg/SQLAlchemy with required SSL.
  • Unity Catalog governance: register Lakebase instances in a catalog/schema for managed access patterns.
  • Reverse ETL into PostgreSQL: sync Unity Catalog Delta tables into Lakebase using Snapshot, Triggered, or Continuous modes.

Real-world example: build an app that needs fast transactional reads and persistent state by creating a Lakebase Provisioned instance, generating OAuth credentials, and setting up reverse ETL from a Delta table into a PostgreSQL table that your application queries directly.

Quick Start

Create and connect to a Lakebase Provisioned instance by generating an OAuth token for your instance and using it as the PostgreSQL password with sslmode=require.

Frequently Asked Questions about databricks-lakebase-provisioned

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

FAQPage Schema
How do I provision and connect to managed PostgreSQL on Databricks Lakebase?▼

To provision and connect to Databricks Lakebase, use the Databricks SDK to create or get instances and generate OAuth tokens. Use the short-lived token as the PostgreSQL password and connect via psycopg or SQLAlchemy with sslmode=require.

What is the best way to sync Delta tables from Unity Catalog into PostgreSQL?▼

The best way to sync Delta tables into PostgreSQL is using reverse ETL. Databricks Lakebase supports Snapshot, Triggered, and Continuous sync modes to replicate Unity Catalog data directly into PostgreSQL tables for application querying.

How do I handle OAuth token expiration for long-running PostgreSQL connections on Lakebase?▼

For long-running PostgreSQL connections on Lakebase, implement token refresh logic in your application. Generate short-lived OAuth credentials using the Databricks SDK before connecting with SSL, then periodically refresh the token to maintain connectivity.

Can I use Databricks Lakebase Provisioned for low-latency OLTP workloads and application persistence?▼

Yes, Databricks Lakebase Provisioned is designed for low-latency OLTP workloads and application persistence. It registers managed PostgreSQL instances within a Unity Catalog schema for governed access and fast transactional reads.

Does connecting to Lakebase PostgreSQL require SSL and short-lived OAuth credentials?▼

Yes, connecting to Lakebase PostgreSQL requires SSL. You must generate short-lived OAuth credentials via the Databricks SDK to use as your database password, ensuring secure token-based connectivity for your application.

What are the limitations of using Databricks Lakebase Provisioned for reverse ETL?▼

A limitation of using Databricks Lakebase Provisioned for reverse ETL is that long-running processes require custom token refresh logic. Additionally, connections must enforce SSL, and instances must be registered in a Unity Catalog schema for access.

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
ice-droid-99ice-droid-99

databricks-lakebase-provisioned

Provision Databricks Lakebase Provisioned managed PostgreSQL instances with OAuth and SSL connections.

Community
Intermediate
thbehthbeh

databricks-lakebase-provisioned

Manage PostgreSQL OLTP workloads in Databricks with Unity Catalog governance.

Community
Advanced