databricks-dbsql

Execute advanced SQL and AI functions in Databricks SQL.

Updated May 31, 2026

Search Tags:#data analysis #sql #databricks #ai functions #advanced sql

Ready to run

npx skills add https://github.com/thbeh/coding-agents-databricks-apps --skill databricks-dbsql-thbeh

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: databricks-dbsql
Source: https://github.com/thbeh/coding-agents-databricks-apps/tree/main/.claude/skills/databricks-dbsql
Command: npx skills add https://github.com/thbeh/coding-agents-databricks-apps --skill databricks-dbsql-thbeh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires databricks-sql, serverless sql warehouse, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill unit offers advanced SQL features and AI functions in Databricks SQL, enabling users to perform complex data analysis and leverage AI capabilities directly within the SQL environment.

Core Features & Use Cases

Advanced SQL Functions: Execute advanced SQL operations such as stored procedures, recursive CTEs, transactions, and materialized views.
AI Functions: Leverage AI functions like ai_query, ai_classify, and ai_extract to enrich data and perform complex analyses.
Use Case: For instance, users can use this Skill to classify support tickets or extract entities from text, enhancing their data analysis capabilities.

Quick Start

Use the databricks-dbsql skill to execute a SQL query and visualize the results in a chart.

Frequently Asked Questions about databricks-dbsql

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

FAQPage Schema

How do I use AI functions to classify text data in Databricks SQL?▼

Use AI functions in Databricks SQL like `ai_classify` to categorize text data and `ai_extract` to pull entities directly within your SQL queries. This enables complex text analysis and data enrichment without leaving the SQL environment.

Can I write stored procedures and recursive CTEs in Databricks SQL?▼

Yes, Databricks SQL supports advanced SQL scripting including stored procedures, recursive CTEs, and transactions. These features allow you to execute complex data transformations and logic directly within your data warehouse.

Do I need a Serverless SQL Warehouse to run advanced SQL features in Databricks?▼

Yes, executing advanced SQL features and AI functions requires a Serverless SQL Warehouse along with Databricks SQL. This serverless compute environment provides the necessary infrastructure to run complex queries and AI functions.

What is the best way to analyze support tickets using Databricks SQL?▼

The best way to analyze support tickets in Databricks SQL is by utilizing built-in AI functions like `ai_classify` to categorize tickets and `ai_extract` to identify key entities. This allows for automated, enriched data analysis directly in SQL.

How do I visualize SQL query results from Databricks?▼

You can execute a SQL query using the databricks-dbsql skill and visualize the results in a chart. This provides immediate visual insights from your advanced SQL operations and AI function outputs.

What are the limitations of using materialized views in Databricks SQL?▼

Materialized views in Databricks SQL are supported for advanced data analysis, but their performance and refresh capabilities depend on the underlying Serverless SQL Warehouse configuration. Proper compute setup is required to maintain them efficiently.