Skip to main content

Dremio MCP

Kaji can query your data lakehouse in Dremio using natural language. Describe what data you need and Kaji will write and run the SQL for you, then return the results in a readable format.

What Kaji can do​

  • Run SQL queries against your Dremio data sources
  • Explore available tables and schemas
  • Retrieve and format query results
  • Answer questions about your data without requiring SQL knowledge

Example prompts​

What tables are available in Dremio?
Show me total revenue by product for the last 30 days
How many new customers signed up in January 2026?
Pull the top 10 customers by order volume this quarter and put it in a table
Run this SQL query in Dremio: SELECT * FROM sales.orders WHERE date >= '2026-01-01' LIMIT 100
Compare this month's pipeline vs last month's pipeline from the CRM data

Tips for business users​

  • You don't need to know SQL — just describe what you want in plain language
  • Mention the data domain when possible ("from the sales data", "in the customer table") to help Kaji find the right table
  • Ask for results in a specific format: "as a markdown table", "as bullet points", "as a summary paragraph"
  • For large datasets, Kaji will automatically limit results and let you know

Configuration​

The Dremio MCP connects using your organization's Dremio credentials configured on the Shakudo platform.

For custom environments:

VariableDescription
DREMIO_URLDremio server URL
DREMIO_USERNAMEDremio username
DREMIO_PASSWORDDremio password or PAT (personal access token)