databricks-apps-python

Builds and deploys Python backends for Databricks Apps using FastAPI, Flask, Dash, Streamlit, Gradio, or Reflex.

4|1|Updated May 22, 2026
One-click install
npx skills add https://github.com/ThomazRossito/ai-data-agents --skill databricks-apps-python-thomazrossito
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-apps-python
Source: https://github.com/ThomazRossito/ai-data-agents/tree/main/plugins/ai-data-agents/skills/databricks-apps-python
Command: npx skills add https://github.com/ThomazRossito/ai-data-agents --skill databricks-apps-python-thomazrossito

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires databricks-sdk, databricks-sql-connector, openai, streamlit, fastapi, uvicorn, gunicorn, psycopg2-binary, asyncpg, requests, pydantic, and includes references (resource) components.

What problem does it solve? Building a Python backend on Databricks Apps requires correct OAuth authentication, resource wiring via app.yaml, framework-specific deployment commands, and connectivity to SQL warehouses, Lakebase, and model-serving endpoints — mistakes in any of these cause apps to crash or silently run stale code. ## Core Features & Use Cases - Framework Selection & Patterns: Databricks-specific guidance for FastAPI (default), Flask, Dash, Streamlit, Gradio, and Reflex, including correct app.yaml commands and production servers (uvicorn, Gunicorn). - Auth & Resources: Service principal auth via SDK Config(), on-behalf-of user tokens via x-forwarded-access-token, and valueFrom resource references for SQL warehouses, Lakebase, secrets, and serving endpoints. - Deployment & LLM Integration: CLI and Asset Bundles deployment workflows, plus working examples for foundation-model chat, parallel LLM calls, and structured JSON outputs. - Use Case: A data team needs an internal FastAPI service that queries a SQL warehouse with per-user Unity Catalog filters and deploys it as a Databricks App — this Skill provides the exact auth, app.yaml, and deployment steps. ## Quick Start Use the databricks-apps-python skill to scaffold a FastAPI backend for a Databricks App that queries my SQL warehouse and deploy it with the Databricks CLI.

Frequently Asked Questions about databricks-apps-python

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

FAQPage Schema
How do I deploy a Python app to Databricks Apps?▼

Create an app.yaml with the framework-specific command, upload source with databricks workspace import-dir using --overwrite, then run databricks apps deploy with the source-code-path. FastAPI deploys with uvicorn and Flask with Gunicorn, never dev servers.

Which Python framework should I use for a Databricks App?▼

FastAPI is the default for Python backends, offering async APIs and auto-generated OpenAPI docs. Use Streamlit for widget-style prototypes, Dash for dashboard grids, Gradio for ML demos, and Flask or Reflex for edge cases.

How does user authorization work in Databricks Apps?▼

Databricks forwards the user's access token via the x-forwarded-access-token HTTP header, which each framework reads differently. Pass that token to sql.connect as access_token so Unity Catalog row and column filters apply per user.

Why does my Lakebase Databricks App crash on startup?▼

psycopg2 and asyncpg are not pre-installed in the Databricks Apps runtime, so the app crashes without them. Add psycopg2-binary or asyncpg to requirements.txt; this is the most common cause of Lakebase app failures.

When should I use the AppKit skill instead of a Python backend?▼

The default for new Databricks Apps is the databricks-apps skill using AppKit with Node.js, TypeScript, and React. Use the Python backend skill only when the user explicitly requests Python, extends an existing Python app, or the team is Python-only.