Dremio MCP Server
The Dremio MCP Server is an open-source project that enables AI chat clients or agents to securely interact with your Dremio deployment using natural language. While you can fork the open-source Dremio MCP Server and customize the MCP Server functionality further if needed we recommend using the Dremio-hosted MCP Server which is available for all projects. Connecting to the Dremio-hosted MCP Server is the fastest path to enabling external AI chat clients to work with Dremio. The Dremio-hosted MCP Server provides OAuth support which guarantees and propagates the user identity, authentication, and authorization for all interactions with Dremio. Once connected, you can use natural language to explore and query data, perform analysis and create visualizations, create views, and analyze system performance.
Configure Connectivity
To configure connectivity to your Dremio-hosted MCP Server, you first need to set up a Native OAUth application and provide the redirect URLs for the AI chat client you are using.
- For Claude, use https://claude.ai/api/mcp/auth_callback, https://claude.com/api/mcp/auth_callback.
- For ChatGPT, use https://chatgpt.com/connector_platform_oauth_redirect.
- For a custom AI chat client, you will need to speak to your administrator.
Then in your AI chat client, you need to create a connection to the Dremio-hosted MCP Server by providing the client ID from the OAuth application and the MCP endpoint for your control plane.
- For Dremio instances using the US control plane, your MCP endpoint is
mcp.dremio.cloud/mcp/{project_id}. - For Dremio instances using the European control plane, your MCP endpoint is
mcp.eu.dremio.cloud/mcp/{project_id}. - If you are unsure of your endpoint, you can copy the MCP endpoint from the Project Overview page in Project Settings.
MCP Server Tools
The Dremio MCP server exposes several tools that aid LLMs to interact effectively with Dremio:
GetUsefulSystemTableNames: Retrieves a dictionary of system tables with descriptions.GetSchemaOfTable: Retrieves schema information for a table.GetDescriptionOfTableOrSchema: Retrieves descriptions and tags for a table or schema.GetTableOrViewLineage: Retrives lineage information for a table or view.RunSqlQuery: Run a SQL command and return the result in JSON format.