Labsco
dremio logo

Dremio

★ 52

from dremio

Integrate Large Language Models (LLMs) with the Dremio data lakehouse platform.

🔥🔥🔥🔥✓ VerifiedFreeQuick setup
#automation#database#devops#git#maps#security#monitoring

Dremio MCP server

Table of Contents

Introduction

This repo provides an Model Context Protocol (MCP) server for easing LLM integration with Dremio. If you are new to MCP and MCP Servers take our Dremio MCP Server course on Dremio University (DremioU). If you are familiar with these concepts already please proceed below.

%%{init:
{
    "themeVariables": {
        "fontFamily": "Inter"
    }
}
}%%

architecture-beta
    group ws(cloud)[Workstation]

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

    mcp:B <-- T:cf
    claude:R <--> L:mcp


    group dremio(cloud)[Dremio]
    service de(server)[Dremio Engine] in dremio

    mcp:R <--> L:de

Installation

The Dremio MCP server can be deployed in two ways:

Log File Locations

The log files are stored in the following locations based on your operating system:

Linux

  • Directory: ~/.local/share/dremioai/logs/
  • Full path: ~/.local/share/dremioai/logs/dremioai.log
  • XDG compliance: Respects $XDG_DATA_HOME environment variable if set

macOS

  • Directory: ~/Library/Logs/dremioai/
  • Full path: ~/Library/Logs/dremioai/dremioai.log

Windows

  • Directory: %LOCALAPPDATA%\dremioai\logs\
  • Full path: %LOCALAPPDATA%\dremioai\logs\dremioai.log
  • Typical location: C:\Users\<username>\AppData\Local\dremioai\logs\dremioai.log

Controlling File Logging

By default, the MCP server logs to the logfile mentioned above. To control it further, you can use the following environment variables and command line options:

  1. Use JSON format: JSON_LOGGING=1 or pass --enable-json-logging for structured JSON logs
  2. Disable file logging: pass --no-log-to-file to disable writing logs to file

Example:

$ uv run dremio-mcp-server run --no-log-to-file --enable-json-logging

# OR 

$ uv run dremio-mcp-server run --enable-json-logging

The log directory is automatically created if it doesn't exist, so no manual setup is required.

Further Documentation

  1. Architecture: Detailed overview of the Dremio MCP server architecture, including component interactions and data flows.

  2. Tools: Comprehensive guide to available tools, including:

    • Tool categories and types
    • Usage examples
    • Development guidelines
    • Integration support

  3. Settings: Complete configuration reference covering:

    • Dremio connection settings
    • Tool configurations
    • Framework integrations
    • Environment variables

  4. Remote HTTP streaming / Helm Chart

Additional Information

This repository is intended to be open source software that encourages contributions of any kind, like adding features, reporting issues and contributing fixes. This is not a part of Dremio product support.

Testing

The project uses pytest for testing. To run the tests:

# Run all tests
$ uv run pytest tests

GitHub Actions automatically runs tests on pull requests and pushes to the main branch.