Cloudera Hive MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| HIVE_HOST | Yes | Virtual Warehouse hostname | |
| HIVE_PORT | No | HTTPS port | 443 |
| HIVE_PASSWORD | Yes | Cloudera workload password | |
| HIVE_USERNAME | Yes | Cloudera workload user | |
| HIVE_HTTP_PATH | No | HiveServer2 HTTP path | /cliservice |
| HIVE_READ_ONLY | No | If true, execute_query rejects DDL/DML | true |
| HIVE_QUERY_ROW_LIMIT | No | Max rows returned by execute_query | 1000 |
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 | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_databasesA | Retrieve all available databases in the Hive Virtual Warehouse. |
| list_tablesB | Retrieve all tables for a given database. |
| describe_tableA | Return column names, types, and comments for |
| get_table_sampleA | Preview the first |
| execute_queryA | Execute a HiveQL query and return results as a list of row dicts. When HIVE_READ_ONLY is true (the default), write DDL/DML is rejected. Results are capped at HIVE_QUERY_ROW_LIMIT rows. |
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 5 tools
Each tool has a distinct responsibility: describing table schema, executing queries, sampling data, listing databases, and listing tables. No two tools overlap in purpose, ensuring clear selection.
All tools use a consistent verb_noun pattern in snake_case (e.g., describe_table, execute_query). This makes the toolset predictable and easy to navigate.
With 5 tools, the server covers core Hive operations without being bloated or sparse. Each tool serves a necessary function for a read-only Hive interface.
The tools provide fundamental read-only capabilities: schema discovery, data preview, and query execution. A minor gap is the lack of tools for obtaining table statistics or partition info, but the set is largely complete for its purpose.