databricks-query

Execute SQL queries on a Databricks SQL Warehouse.

Updated May 26, 2026

Search Tags:#sql #data warehouse #query execution #databricks #data profiling

Ready to run

npx skills add https://github.com/rbutinar/ade-ops --skill databricks-query-rbutinar

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: databricks-query
Source: https://github.com/rbutinar/ade-ops/tree/main/.agents/skills/databricks-query
Command: npx skills add https://github.com/rbutinar/ade-ops --skill databricks-query-rbutinar

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill streamlines executing SQL queries on a Databricks SQL Warehouse, providing a convenient way to perform ad-hoc queries, schema exploration, data profiling, and validation.

Core Features & Use Cases

Ad-hoc Queries: Execute SQL queries for various purposes like data profiling, validation, and analysis.
Schema Exploration: Retrieve information about tables, columns, and data types.
Data Profiling: Get insights into data distribution, anomalies, and trends.
Use Case: Imagine you need to quickly check the data in a specific table or analyze the performance of a query. This Skill allows you to execute the SQL query directly and receive the results in a readable format.

Quick Start

Execute a SQL query on the default warehouse: /databricks-query "SELECT * FROM t LIMIT 10"

Frequently Asked Questions about databricks-query

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

FAQPage Schema

How do I execute SQL queries on a Databricks SQL Warehouse for ad-hoc analysis?▼

To execute SQL queries for ad-hoc analysis on a Databricks SQL Warehouse, you can use a configured Databricks MCP server to run your statements and retrieve readable results for data profiling and validation.

Can I explore table schemas and data types directly in a Databricks SQL Warehouse?▼

Yes, you can explore Databricks SQL Warehouse schemas to retrieve detailed information about available tables, columns, and data types directly by executing SQL queries through a configured Databricks MCP server.

What is the best way to perform data profiling on tables stored in a Databricks SQL Warehouse?▼

Performing data profiling on a Databricks SQL Warehouse involves executing targeted SQL queries to analyze data distribution, identify anomalies, and uncover trends within your tables using a configured Databricks MCP server.

Do I need a configured Databricks MCP server to run data warehouse queries?▼

Yes, you need a configured Databricks MCP server and active access to a Databricks SQL Warehouse to execute SQL queries, perform schema exploration, and run data profiling operations using this approach.

How do I validate data distribution and anomalies in a Databricks data warehouse?▼

You validate data distribution and anomalies in a Databricks data warehouse by executing specific SQL profiling queries via a Databricks MCP server to get insights into data trends and irregularities.