Dremio MCP
by Dremio
Official listing: built and published by Dremio. More from Dremio
Query Dremio lakehouse data in plain language from Claude, ChatGPT, or your own agent: run SQL, read schemas and lineage, and review failed jobs. For data teams.
Use it now
Keep it with up to 9 other tools you're setting up, then share them all as one link.
Try this first
Ask your assistant, with Dremio MCP connected:
- Run SQL Queries
Use Dremio MCP to run SELECT queries on your Dremio cluster: ‹what you need›
- Table Schemas
Use Dremio MCP to retrieve the schema of Dremio tables: ‹what you're looking for›
- Table And View Lineage
Use Dremio MCP to find the lineage of a Dremio table or view: ‹what you're looking for›
Connect it over MCP
Connect Dremio MCP as an MCP server, following its setup instructions at https://docs.dremio.com/cloud/sonar/mcp-server/
Setup guide: docs.dremio.com/cloud/sonar/mcp-server
Compare
Press Compare to add it to the tray at the bottom of the window, then pick up to 2 others anywhere on the site.
- Access
- MCP
- Auth
- OAuth 2.0
- Skills
- 5
Skills
Run SQL Queries
Runs SELECT queries on your Dremio cluster and returns the results to the agent for analysis and follow-up questions.
Table Schemas
Retrieves the schema of Dremio tables and views so the agent knows the columns and types before writing SQL against them.
Table And View Lineage
Finds the lineage of a Dremio table or view, so the agent can trace which datasets it is built from before using it.
Semantic Search
Searches across the Dremio cluster semantically to find relevant datasets; it must be enabled in the server's config file.
Failed Jobs And Usage Reports
Analyzes failed and canceled Dremio jobs from the past 7 days and builds usage reports grouped by engines or projects.