# databricks-lakeflow-connect

databricks-lakeflow-connect — a skill for Claude Code builds and debugs Lakeflow Connect ingestion from SQL Server, PostgreSQL, MySQL, and Oracle into Unity Catalog. It covers CDC and query-based loads.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 348 installs · ★ 408 repo stars
- Author: databricks
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/databricks/databricks-agent-skills/tree/HEAD/skills/databricks-lakeflow-connect/SKILL.md
- Updated: 2026-11-10
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/databricks-lakeflow-connect

## What it does

databricks-lakeflow-connect runs in Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, and OpenCode. It guides an agent through creating, running, and troubleshooting Lakeflow Connect pipelines that move data from SQL Server, PostgreSQL, MySQL, and Oracle into Delta tables in Unity Catalog.

The skill separates integrated CDC, standard CDC through a gateway, and query-based ingestion. It maps each mode to its pipeline fields, source tables, destinations, and compute checks. The `databricks CLI` version `>= v1.2.0` is required, so the skill does not replace CLI setup.

## Requirements
- Works with: Databricks, PostgreSQL, Confluence

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add databricks/databricks-agent-skills --skill databricks-lakeflow-connect -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/databricks-lakeflow-connect/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/databricks-lakeflow-connect/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add databricks/databricks-agent-skills --skill databricks-lakeflow-connect -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/databricks-lakeflow-connect/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add databricks/databricks-agent-skills --skill databricks-lakeflow-connect -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/databricks-lakeflow-connect/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install databricks/databricks-agent-skills skills/databricks-lakeflow-connect
```

2. **Manually: put the files in place**
- File: `.github/skills/databricks-lakeflow-connect/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add databricks/databricks-agent-skills --skill databricks-lakeflow-connect -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/databricks/databricks-agent-skills --path skills/databricks-lakeflow-connect
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/databricks-lakeflow-connect/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add databricks/databricks-agent-skills --skill databricks-lakeflow-connect -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/databricks/databricks-agent-skills/tree/HEAD/skills/databricks-lakeflow-connect/SKILL.md

## When to use it
- create a Lakeflow Connect pipeline for Unity Catalog
- choose CDC or query-based ingestion for a database
- map source tables to Unity Catalog destinations
- configure a gateway for standard CDC
- debug an ingestion pipeline failure

## Example prompts
- Set up a Lakeflow Connect pipeline that moves PostgreSQL tables into Unity Catalog with CDC.
- Create a MySQL ingestion pipeline for Delta tables and choose the correct Lakeflow Connect mode.
- Investigate the pipeline error and compare its `serverless` setting with other pipelines in the workspace.

## Similar
- [data-engineering-patterns-fabric-databricks](https://affpapa.org/en/nevibecode/skills/data-engineering-patterns-fabric-databricks.md) — skill · 1600 installs
- [databricks-expert](https://affpapa.org/en/nevibecode/skills/databricks-expert.md) — skill · 215 installs
- [azure-databricks-platform-architect](https://affpapa.org/en/nevibecode/agents/azure-databricks-platform-architect.md) — subagent · ★ 6505 repo stars
- [databricks-cli](https://affpapa.org/en/nevibecode/plugins/databricks-cli.md) — plugin · ★ 1104 repo stars
- [databricks-2025](https://affpapa.org/en/nevibecode/skills/databricks-2025.md) — skill · 168 installs
- [databricks](https://affpapa.org/en/nevibecode/rules/databricks.md) — rule · ★ 3589 repo stars

From the same set: [databricks/databricks-agent-skills](https://affpapa.org/en/nevibecode/by/databricks/databricks-agent-skills.md) — 30 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
