広告掲載
MCP.so
ログイン
D

Dremio Python MCP Server

@ucesys

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

ucesys

投稿者

Nikita Makarov

Dremio Python MCP Server について

概要はまだありません

#dremio#mcp#mcp-server

Dremio Python MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

Dremio Python MCP Server のツール

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

概要

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.

よくある質問

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.

コメント

「その他」の他のコンテンツ

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

広告掲載