apache-hadoop-hive-mcp-server-by-cdata
Provides a local, read-only Model Context Protocol (MCP) server that exposes Apache Hadoop Hive data via CData JDBC Driver as MCP tools (get tables, get columns, run SELECT queries), so local LLM clients (e.g., Claude Desktop) can query live Hive data without writing SQL.
Score Breakdown
⚙ Agent Friendliness
🔒 Security
Security controls are largely not described at the MCP layer. Authentication is delegated to CData JDBC Driver configuration (potentially OAuth), but there is no mention of OAuth scope granularity, MCP-level access control, audit logging, query constraints, or TLS/transport behavior for Hive connectivity. The stdio/local design reduces some network exposure but credentials may still be stored in the .prp/JDBC connection string on the host.
⚡ Reliability
Best When
You have Hive connectivity via the CData JDBC Driver, and you want a local MCP bridge for an on-device desktop LLM client to run read-only queries.
Avoid When
You need robust production-grade API semantics (auth scopes, rate-limit headers, pagination contracts, structured error codes) or remote multi-tenant access.
Use Cases
- • Ask natural-language questions over live Hive tables/columns
- • Discover available Hive tables and schemas (columns) via MCP tools
- • Run read-only analytical queries (SELECT) against Hive through an LLM tool workflow
Not For
- • Direct public/remote access to Hive over a network (server is stdio/local)
- • High-assurance transactional workloads or write-heavy CRUD scenarios (README positions this project as read-only)
- • Use-cases requiring strict pagination, data export governance, or fine-grained query result limits (not described)
Interface
Authentication
No dedicated MCP auth layer is described; authentication is delegated to the CData JDBC Driver connection string/JDBC driver configuration.
Pricing
README describes licensing of the CData JDBC driver; this repo itself is MIT-licensed but pricing for connectivity depends on CData driver/managed offerings.
Agent Metadata
Known Gotchas
- ⚠ Server uses stdio; it must run on the same machine as the MCP client.
- ⚠ README lists run_query as SELECT; agents should avoid attempting non-SELECT/CRUD operations since the project is positioned as read-only.
- ⚠ Large result sets may be returned as CSV without documented limits/pagination, which can overwhelm client context.
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for apache-hadoop-hive-mcp-server-by-cdata.
AI-powered analysis · PDF + markdown · Delivered within 30 minutes
Package Brief
Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.
Delivered within 10 minutes
Score Monitoring
Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.
Continuous monitoring
Scores are editorial opinions as of 2026-04-04.