Skip to main content
affpapa.org
RU EN
skill CX Codex

databricks-dbsql — Claude Code skill: what it does, how to install

Equips your coding agent with advanced Databricks SQL patterns, pipe syntax, H3 geospatial functions, and embedded LLM queries.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add databricks/databricks-agent-skills --skill databricks-dbsql -a claude-code
Open on GitHub

What databricks-dbsql does

This skill supplies your assistant with patterns for advanced Databricks SQL (DBSQL) and SQL Warehouse environments. It covers procedural scripting with BEGIN...END, atomic transactions, recursive CTEs, and pipe syntax using the |> operator. It helps the agent write dialect-specific code without hallucinating standard SQL constructs.

It also details the setup for Lakehouse Federation queries, file ingestion with read_files, and native AI functions such as ai_query and ai_classify. In addition, reference patterns for H3 indexing and ST spatial functions are included.

Using this skill alongside Databricks tooling expects databricks CLI version 1.0.0 or higher. Certain capabilities like materialized views and http_request also demand Pro or Serverless SQL Warehouses.

What it helps with

  • write stored procedures with SQLEXCEPTION handlers in Databricks SQL
  • enrich datasets directly using ai_query and ai_classify functions
  • run geospatial proximity searches with H3 indexing and ST points
  • refactor multi-step queries using DBSQL pipe operator syntax

Example prompts for the agent

  • Write a stored procedure in Databricks SQL to merge staging orders with error handling
  • Show how to use ai_classify to categorize incoming support tickets in DBSQL
  • Create an H3 geospatial query to calculate distances between coordinates

How to install databricks-dbsql

1Skills CLI (Vercel)

npx skills add databricks/databricks-agent-skills --skill databricks-dbsql -a claude-code

2Manually: put the files in place

~/.claude/skills/databricks-dbsql/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/databricks-dbsql/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about databricks-dbsql

How to install databricks-dbsql in Claude Code?

Run npx skills add databricks/databricks-agent-skills --skill databricks-dbsql -a claude-code. Alternatively, place the file at ~/.claude/skills/databricks-dbsql/SKILL.md.

What features does databricks-dbsql cover?

It provides syntax rules and examples for procedural SQL scripting, materialized views, pipe syntax, Lakehouse Federation, and built-in AI functions on Databricks.

What are the requirements for this skill?

The skill requires databricks CLI version 1.0.0 or higher. Specific features like materialized views and http_request need Pro or Serverless SQL Warehouses.

Similar skills

All skills for Data and databases →
sql-queries official anthropics Writes and optimizes SQL across PostgreSQL, Snowflake, BigQuery, Redshift, and Databricks. Useful when tuning queries or migrating analytics across warehouses. CX Codex +1 4,500installs migrating-dbt-project-across-platforms dbt-labs Guides dbt project migrations across data platforms using dbt Fusion real-time compilation. Catches SQL dialect issues early and verifies logic using unit tests. CX Codex +1 526installs neon-ai-gateway neondatabase This skill teaches your agent to route LLM and embedding calls through Neon AI Gateway, using a single Neon credential instead of separate provider keys. CX Codex +1 27,700installs fabric-lakehouse official tedvilutis This skill gives GitHub Copilot context on Fabric Lakehouse storage, schemas, access control, Shortcuts, and table optimization. Use it for solution design. 8,800installs chief-data-officer-advisor Alireza Rezvani Advises startup founders and CDOs on AI training data rights, data product architecture, B2B customer data valuation for M&A, and hiring sequences. 410installs firebase-data-connect Google LLC Builds and configures Firebase SQL Connect backends on PostgreSQL with GraphQL schemas and generated SDKs. Useful when adding relational data to Firebase projects. CX Codex +1 168,800installs

From the same set7

databricks-core Guides Databricks CLI work around authentication, profile choice, and bundles. Use it before CLI tasks involving Databricks resources. CX Codex +1 1,700installs databricks-pipelines Guides agents in designing Lakeflow Spark Declarative Pipelines on Databricks with Python or SQL. It selects dataset types and configures Auto CDC before coding begins. CX Codex +1 987installs databricks-unity-catalog Helps agents handle Unity Catalog permissions, configure row filters and column masks, manage storage, and query system tables in Databricks. CX Codex +1 325installs databricks-apps-python Configures Python backends for Databricks Apps, handling framework deployment, OAuth authentication, and Lakebase connections. CX Codex +1 305installs databricks-aibi-dashboards A skill for building Databricks AI/BI (formerly Lakeview) dashboards: picks widgets, tests SQL, deploys through the CLI. CX Codex +1 305installs databricks-ai-functions A skill that teaches your agent to call Databricks built-in AI functions from SQL and PySpark. Useful when a pipeline needs a model without endpoint setup. CX Codex +1 306installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor