Advertise
MCP.so
Sign In
D

Dremio Python MCP Server

@ucesys

Repository

Basic information

Category

Other

Transports

stdio

Author

ucesys

Submitted by

Nikita Makarov

About Dremio Python MCP Server

No overview available yet

#dremio#mcp#mcp-server

Dremio Python MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "dremio-mcp": {
      "command": "mcp-dremio-server",
      "args": []
    }
  }
}

Dremio Python MCP Server tools

4

Lists all available catalogs in Dremio

Lists all schemas in a specific catalog

Lists all tables in a specific schema

Executes a SQL query against Dremio

Overview

What is Dremio Python MCP?

Dremio Python MCP is a Model Context Protocol (MCP) server that provides a standardized way to interact with Dremio databases, supporting both Dremio Software and Dremio Cloud. It exposes Dremio catalogs, schemas, and tables as MCP Resources and offers tools for listing metadata and executing SQL queries.

How to use Dremio Python MCP?

Install the package with pip install -e . or uv pip install -e .. Create a config.yaml file or set environment variables for Dremio connection details. Run the server with mcp-dremio-server or python run_mcp_server.py. Add the server configuration to your MCP client (e.g., Claude) using the provided JSON snippet.

Key features of Dremio Python MCP

  • Exposes Dremio catalogs, schemas, and tables as MCP Resources.
  • Tools: list_catalogs, list_schemas, list_tables, execute_sql.
  • SQL validation prevents non-read-only queries.
  • Input validation protects against SQL injection.
  • Supports username/password and token authentication.
  • TLS support for secure communication.

Use cases of Dremio Python MCP

  • Enable an AI assistant to discover and query Dremio databases.
  • List all catalogs, schemas, and tables available in a Dremio instance.
  • Execute read-only SQL queries and retrieve structured results.
  • Integrate Dremio data exploration into MCP‑compatible applications.

Frequently asked questions

1

What are the runtime requirements?

Python 3.10 or later, a Dremio instance (Cloud or Software), and PyArrow with Flight support.

2

How do I authenticate to Dremio?

For Dremio Software, provide username and password (with optional TLS). For Dremio Cloud, use a personal access token.

3

What query limits does the server enforce?

By default, results are limited to 10,000 rows, schema requests to 1,000 columns, and query execution has a 300‑second timeout.

4

Can I execute write queries like INSERT or UPDATE?

No. The server validates SQL and only permits read‑only queries such as SELECT.

5

How can I debug the MCP server?

Run the server with the MCP Inspector: `npx @modelcontextprotocol/inspector mcp-dremio-server`. The Inspector provides a browser‑based debugging interface.

Comments

More Other MCP servers

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K
P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Advertise