dremio-mcp-lite
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DREMIO_PAT | Yes | Your Dremio personal access token | |
| DREMIO_URL | Yes | The URL of your Dremio instance (e.g., http://localhost:9047) | |
| DREMIO_REJECT_UNAUTHORIZED | No | Set to 'false' to disable SSL certificate verification for self-signed certificates (only for development/testing) | true |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| catalog_browseB | Browse Dremio catalog to list sources, spaces, folders, and tables. Optionally provide a path to browse a specific location. |
| schema_getA | Get the schema of a specific table in Dremio |
| sql_queryA | Execute a SELECT query on Dremio. Returns up to 1000 rows. Read-only queries only. |
| table_previewB | Preview the first 10 rows of a table |
| search_catalogC | Search for tables and datasets in the Dremio catalog by name |
| explain_queryB | Get the execution plan for a SQL query |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 6 tools
Each tool targets a clearly distinct operation: catalog browsing, schema retrieval, arbitrary SQL, quick preview, catalog search, and query explanation. The only potentially overlapping pair is catalog_browse and search_catalog, but one navigates the hierarchy while the other searches by name, so they are easy to distinguish.
The naming is readable and consistently uses snake_case, but the verb placement is mixed: object-verb forms like catalog_browse, schema_get, and table_preview sit alongside verb-object forms like search_catalog and explain_query, and sql_query has no verb at all. This is not chaotic, but it does not follow a single predictable pattern.
Six tools is well-scoped for a read-only Dremio exploration and querying server. Each tool serves a distinct purpose without redundancy, and the count is comfortably within the ideal range.
The tool set covers the full read-only workflow: discovering data via browse/search, inspecting structure via schema, peeking at data via preview, running arbitrary queries, and understanding performance via explain. No obvious dead ends or missing essential operations exist for the stated purpose.