skills.rest
ice-droid-99
ice-droid-99COMMUNITY
Explore all skills by this author →
GitHub

databricks-lakebase

Manage Databricks Lakebase Postgres projects with Databricks CLI commands.

Updated May 20, 2026
Search Tags:#autoscaling#databricks#lakebase#data api#postgres connectivity#oAuth tokens#synced tables
One-click install
npx skills add https://github.com/ice-droid-99/BI-Dashboard-Generation-Agent-in-Databricks- --skill databricks-lakebase-ice-droid-99
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-lakebase
Source: https://github.com/ice-droid-99/BI-Dashboard-Generation-Agent-in-Databricks-/tree/main/.gemini/skills/databricks-lakebase
Command: npx skills add https://github.com/ice-droid-99/BI-Dashboard-Generation-Agent-in-Databricks- --skill databricks-lakebase-ice-droid-99

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you manage Databricks Lakebase Postgres so you can create autoscaling OLTP projects, configure connectivity, and operationalize synced tables without getting stuck on setup details or CLI discovery.

Core Features & Use Cases

  • Lakebase project and environment lifecycle: create, update, and delete Lakebase Autoscaling projects with production-grade branching for isolated environments.
  • Compute, scaling, and HA setup guidance: understand endpoint types, autoscaling/scale-to-zero behavior, and resource hierarchy so your app can reliably connect.
  • Data access patterns for apps: generate OAuth tokens, build correct PostgreSQL connection strings (including SSL), and use the PostgREST-compatible Data API for HTTP CRUD.
  • Lakebase synced tables (Reverse ETL): explain how to sync Unity Catalog Delta tables into Lakebase for low-latency OLTP access and how to avoid common sync pitfalls.
  • Operational next steps: scaffold Databricks Apps using Lakebase features and apply the required schema permission workflow for deployed apps.

Quick Start

Ask the AI to give you the exact databricks postgres CLI steps to create a Lakebase autoscaling project and then produce the host and token you need to connect from a PostgreSQL client with sslmode=require.

Frequently Asked Questions about databricks-lakebase

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

FAQPage Schema
How do I create a Databricks Lakebase autoscaling project using the CLI?▼

To create a Databricks Lakebase autoscaling project, you need Databricks CLI v0.294.0 or later and must execute specific provisioning subcommands to configure the project, branches, and endpoints for isolated environments.

How do I generate OAuth tokens and connection strings for Lakebase Postgres?▼

Generating OAuth tokens and PostgreSQL connection strings for Lakebase requires configuring database credentials via CLI, ensuring SSL mode is set to require, and handling token lifetimes for secure client connectivity.

Can I sync Unity Catalog Delta tables into Lakebase for low-latency OLTP access?▼

Yes, you can sync Unity Catalog Delta tables into Lakebase using synced-table workflows, which function as Reverse ETL to enable low-latency OLTP access while avoiding common synchronization pitfalls.

What CLI version is required to manage Databricks Lakebase Postgres resources?▼

Managing Databricks Lakebase Postgres resources requires Databricks CLI version 0.294.0 or higher to ensure compatibility with discoverable subcommands for projects, endpoints, and databases.

Does Lakebase support PostgREST-compatible Data API connectivity for HTTP CRUD operations?▼

Yes, Lakebase supports PostgREST-compatible Data API connectivity, allowing you to perform HTTP CRUD operations directly alongside standard PostgreSQL and pgvector database connections.

How do I configure high availability and scale-to-zero behavior for Lakebase endpoints?▼

Configuring high availability and scale-to-zero behavior for Lakebase endpoints involves using specific CLI commands to update autoscaling project settings and manage the resource hierarchy for reliable app connections.

Related Skills

Explore More Software Engineering Skills→
Zack2626-okZack2626-ok

databricks-lakebase

Manage Databricks Lakebase Postgres project lifecycles, branches, and endpoints.

Community
Advanced
databricks-solutionsdatabricks-solutions
4

lakebase-scm-extension

Coordinate paired Git and Lakebase branches for synchronized code and schema workflows.

Official
Advanced
hai-serieshai-series
3

hai-vecdb

Manage collections, vectors, and similarity search across LanceDB, pgvector, and Qdrant.

Official
Advanced
robkiskrobkisk

databricks-lakebase-autoscale

Manage Databricks Lakebase PostgreSQL projects, branches, and compute autoscaling.

Community
Advanced