dremio-python-mcp

dremio-python-mcp

0
databases

The Dremio Model-Context Protocol (MCP) server provides a standardized method to interact with Dremio databases, offering tools for listing catalogs, schemas, and executing SQL queries. It is designed to simplify data access and management while ensuring security through validation and authentication features.

Dremio Model-Context Protocol (MCP) Server

Features

  • Resources: Access and manage Dremio data through standardized resources like catalogs, schemas, tables, and schemas of specific tables.
  • Tools: Provides functionalities such as listing catalogs, schemas, tables, and executing SQL queries.

Requirements

  • Python 3.10+
  • Dremio instance (Cloud or Software)
  • PyArrow with Flight support

Installation

  • Use pip or uv to install the package.

Configuration

  • Configure using config.yaml or environment variables for settings like Dremio connection.

Usage

  • Run the MCP server and integrate with MCP clients by configuring client settings for platforms like MacOS and Windows.

Security Features

  • SQL validation, input validation, TLS support, and authentication options.

Debugging

  • Use MCP Inspector for debugging.

License

  • Licensed under the MIT License.