Project Overview dremio-local-mcp
Full Documentation on Git Repo Here
The dremio-local-mcp is a Model Context Protocol (MCP) server that connects AI assistants (like Claude) to your Dremio lakehouse.
Features
- Semantic Layer Management: Create views, update wikis, and tag datasets directly from chat.
- Data Exploration: List datasets, inspect schemas, and package context for analysis.
- Query Execution: Run SQL queries safely (destructive queries require confirmation).
- Job Analysis: Analyze job profiles for performance improvements.
Installation
pip install dremio-local-mcp
Configuration
This tool uses the standard Dremio CLI configuration format. You can manage your Dremio credentials using the dremio-cli utility (recommended) or manually via a YAML file.
Option 1: Using dremio-cli
First, install the CLI (if not already present):
pip install dremio-cli
Then create a profile for your environment:
For Dremio Cloud:
# Create a profile named 'default'
dremio profile create --name default --type cloud --token <your-pat-token> --project-id <your-project-id> --base-url https://api.dremio.cloud
For Dremio Software:
# Create a profile named 'software'
dremio profile create --name software --type software --base-url http://localhost:9047 --username <user> --password <pass>
(For Software, verify_ssl defaults to true. Add --no-verify-ssl if using self-signed certs)
Option 2: Manual YAML
Create or edit ~/.dremio/profiles.yaml manually:
default_profile: cloud
profiles:
cloud:
base_url: "https://api.dremio.cloud"
token: "your-pat-token"
project_id: "your-project-id"
verify_ssl: true
software:
base_url: "http://localhost:9047"
username: "admin"
password: "password123"
verify_ssl: false
### Supported Authentication Flows
This MCP server supports all authentication flows available in `dremio-cli` (v1.10.0+):
1. **Cloud (PAT)**: Requires `token` and `project_id`.
2. **Software (PAT)**: Requires `token` and `base_url`.
3. **Software (User/Pass)**: Requires `username`, `password`, and `base_url`.
4. **Service (OAuth2 Credentials)**: Requires `client_id`, `client_secret`, and `base_url`.
> [!TIP]
> **Service/Credentials Flow**: If you are using the Client Credentials flow (common for service accounts), it is recommended to explicitly set the scope in your profile to ensure full access.
>
> ```yaml
> service_profile:
> type: "software" # or "cloud"
> base_url: "https://dremio.org/api/v3"
> auth:
> type: "oauth"
> client_id: "your-client-id"
> client_secret: "your-client-secret"
> # scope: "dremio.all" # NOTE: dremio-cli v1.11.0 currently ignores this key and defaults to dremio.all on retry
> ```
Usage
Start the Server
dremio-local-mcp start --profile default
Connectivity Test
dremio-local-mcp test --profile default
Claude Desktop Config
Generate the configuration block:
dremio-local-mcp config --profile default
Copy the output into your claude_desktop_config.json.
Documentation
Metadata
Release files for dremio-local-mcp 0.5.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| dremio_local_mcp-0.5.0.tar.gz | 24.3 kB | Without provenance | Details for dremio_local_mcp-0.5.0.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| dremio_local_mcp-0.5.0-py3-none-any.whl | Python 3 | none | any | Details for dremio_local_mcp-0.5.0-py3-none-any.whl |
Total release size: 57.7 kB
Release files / dremio_local_mcp-0.5.0.tar.gz
| Download URL | dremio_local_mcp-0.5.0.tar.gz |
|---|---|
| Size | 24.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
466ed4a655c43ef01c6bf0b53ab801a84a6e3bd3366a0ba1124386f22a4661aa
|
|
BLAKE2b-256 checksum How to use checksums |
a739a40900a5bf2d07a47a19d745fa3ad5cdebec9594d3684b3cb179db7e4922
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.11.2
|
Release files / dremio_local_mcp-0.5.0-py3-none-any.whl
| Download URL | dremio_local_mcp-0.5.0-py3-none-any.whl |
|---|---|
| Size | 33.4 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
cf87260b298947ab58ba30f6792f9e85aaff74c668e191b0da8805c1c410ec60
|
|
BLAKE2b-256 checksum How to use checksums |
cfa3b115a93502ee3211d1397ca62cec96fa50280eed99874531de8f32551306
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.11.2
|
Security for dremio-local-mcp 0.5.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.