databricks-ai-functions

Parse documents and enrich text columns in Databricks SQL and PySpark.

1|Updated Apr 24, 2026
One-click install
npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill databricks-ai-functions-itsadijmbt
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-ai-functions
Source: https://github.com/itsadijmbt/SecureMCP-Servers/tree/main/TEST_SERVERS/PORTED_TO_SECUREMCP/databrickslab-mcp/ai-dev-kit/databricks-skills/databricks-ai-functions
Command: npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill databricks-ai-functions-itsadijmbt

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the friction of adding AI-driven understanding to your Databricks SQL and PySpark pipelines, so you can parse documents, extract fields, and generate business-ready outputs without managing model endpoints.

Core Features & Use Cases

  • Document parsing and text extraction: Convert PDFs and office documents into structured page and element content using ai_parse_document.
  • Task-specific enrichment: Apply ai_classify, ai_extract, ai_summarize, ai_mask, ai_translate, ai_similarity, ai_fix_grammar, and ai_analyze_sentiment directly in queries for reliable end-to-end enrichment.
  • Fallback for complex structured output: Use ai_query when you need nested arrays or complex reasoning that task-specific functions can’t express.
  • Production pipeline patterns: Build batch document ingestion pipelines (parse → enrich → extract nested JSON) and custom RAG flows (parse → chunk → index → query).

Quick Start

Ask the AI to extract invoice header fields and line items from a batch of PDF files stored in a Databricks volume, returning clean structured JSON and skipping rows where parsing fails.

Frequently Asked Questions about databricks-ai-functions

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

FAQPage Schema
How do I parse PDF documents into structured JSON in Databricks SQL?

Use the ai_parse_document function to parse PDFs and office documents into structured page and element content directly within Databricks SQL, requiring DBR 17.1 or higher.

Can I extract specific fields and classify text in PySpark without configuring model endpoints?

Yes, you can extract fields and classify text in PySpark using built-in functions like ai_extract and ai_classify to enrich text columns directly without configuring external model endpoints.

What Databricks Runtime version do I need for AI Functions?

Databricks AI Functions require DBR 15.1 or higher for text enrichment tasks like sentiment analysis and translation, while document parsing specifically requires DBR 17.1 or higher.

What's the best way to handle complex nested JSON schemas that ai_extract cannot process?

The best way to handle complex nested JSON schemas is using the ai_query function as a fallback when task-specific functions cannot express the nested arrays or complex reasoning required.

How do I build a batch document ingestion pipeline in Databricks that skips failed rows?

Build a batch document ingestion pipeline by sequencing ai_parse_document, task-specific enrichment functions, and ai_extract, applying batch error-handling guidance to skip rows where document parsing fails.

Can I use Databricks AI Functions to mask sensitive data and fix grammar in SQL queries?

Yes, you can use ai_mask to mask sensitive data and ai_fix_grammar to correct grammar directly within SQL queries for reliable end-to-end text enrichment without external API calls.