Dremio MCP Server

service cf(database)[Config] in ws service mcp(server)[Dremio MCP Server] in ws service claude(cloud)[Claude Desktop] in ws

Local serverstdioPython

What is the Dremio MCP MCP server?

service cf(database)[Config] in ws service mcp(server)[Dremio MCP Server] in ws service claude(cloud)[Claude Desktop] in ws. That is what the dremio mcp mcp server brings to an AI assistant: the same capability, reachable through the Model Context Protocol rather than a separate app or dashboard.

The short version

  • OAuth + External Token Provider authentication (recommended for production)
  • Streaming HTTP mode for web-based deployments
  • Horizontal Pod Autoscaling for scalability
  • Prometheus metrics integration
  • Ingress support with TLS/SSL
  • Security best practices (non-root, read-only filesystem)

Getting it running

Setup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client.

The tools it exposes

The server publishes 7 tools. What each one is for:

  • macOS — ~/Library/Application Support/Claude/claude_desktop_config.json
  • Windows — %APPDATA%\Claude\claude_desktop_config.json
  • Directory — ~/.local/share/dremioai/logs/
  • Documentation — The Documentation tool exposed by this server
  • Format — The Format tool exposed by this server
  • Modes — 1. FOR_DATA_PATTERNS - the normal mode where MCP server will allow LLM to look at tables and data to allow pattern discovery and other use cases 2
  • Linux — The Linux tool exposed by this server

Things to watch

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

How it compares

Plenty of monitoring and observability servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. Dremio MCP's toolset — macOS, Windows, Directory and 4 more — is a fair guide to whether it matches your workflow. It is maintained by dremio; worth a glance at recent repository activity before you build anything load-bearing on it.

SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.

Available tools

ToolWhat it does
macOS~/Library/Application Support/Claude/claude_desktop_config.json
Windows%APPDATA%\Claude\claude_desktop_config.json
Directory~/.local/share/dremioai/logs/
DocumentationThe Documentation tool exposed by this server.
FormatThe Format tool exposed by this server.
Modes1. FOR_DATA_PATTERNS - the normal mode where MCP server will allow LLM to look at tables and data to allow pattern discovery and other use cases 2. FOR_SELF - a mode which allows the MCP server to introspect Dremio syste
LinuxThe Linux tool exposed by this server.

Example prompts to try

  • Use Dremio MCP to macOS.
  • Use Dremio MCP to Windows.
  • Use Dremio MCP to Directory.

Frequently asked questions

It connects Dremio MCP to MCP-compatible AI assistants such as Claude and Cursor, exposing 7 tools (macOS, Windows, Directory, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Dremio MCP directly.