skills.rest
rbutinar
rbutinarCOMMUNITY
Explore all skills by this author →
Website𝕏@rbutinarGitHub

databricks-query

Execute SQL queries on a Databricks SQL Warehouse.

Updated May 26, 2026
Search Tags:#sql#data warehouse#query execution#databricks#data profiling
One-click install
npx skills add https://github.com/rbutinar/ade-ops --skill databricks-query-rbutinar
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
LaurentPRAT-DBLaurentPRAT-DB

databricks-query

Execute SQL queries against Databricks SQL warehouses and format results as ASCII tables.

Community
Intermediate
ScientiaCapitalScientiaCapital
28

hubspot-revops-skill

Integrate HubSpot API with a SQL warehouse to analyze revenue analytics.

Community
Advanced
JingyiWngJingyiWng

databricks-genie

Create and query Databricks Genie Spaces via natural language.

Community
Advanced
robkiskrobkisk

databricks-aibi-dashboards

Create and update Databricks AI/BI dashboards with SQL validation and deployment.

Community
Advanced