Provides a connection to HiveServer2, allowing users to execute SQL queries against Hive databases and retrieve results through a REST API endpoint.
HiveServer2 MCP
A MCP server for HiveServer2.
Installation
Clone the repository:
git clone https://github.com/your-username/hiveserver2-mcp.git cd hiveserver2-mcpCreate a virtual environment:
python3 -m venv venv source venv/bin/activateInstall the dependencies:
pip install -r requirements.txt
Usage
Create a
Create a
.env
file in the root of the project and add the following environment variables:HIVESERVER2_HOST=<your_hiveserver2_host> HIVESERVER2_PORT=<your_hiveserver2_port> HIVESERVER2_USER=<your_hiveserver2_user> HIVESERVER2_PASSWORD=<your_hiveserver2_password>Run the server:
hiveserver2-mcpInteract with the server:
You can use
curl
to interact with the server.Query:
curl -X POST -H "Content-Type: application/json" -d '{"query": "SELECT * FROM my_table"}' http://localhost:5000/query
Note on sasl
This project does not include the sasl
package as a direct dependency, as it can be difficult to install on some systems. If you are connecting to a Hive instance that requires SASL authentication, you may need to install it manually.
Ubuntu/Debian:
macOS:
This server cannot be installed
A MCP server that allows users to interact with HiveServer2 through an API interface, enabling execution of Hive queries over HTTP.
Related MCP Servers
- AsecurityAlicenseAqualityMCP Server for the GitHub API, enabling file operations, repository management, search functionality, and more.Last updated -22,57370,957MIT License
- -securityAlicense-qualityAn MCP server that exposes HTTP methods defined in an OpenAPI specification as tools, enabling interaction with APIs via the Model Context Protocol.Last updated -8MIT License
- AsecurityAlicenseAqualityAn MCP server that connects to the Teamwork API, providing a simplified interface for interacting with Teamwork projects and tasks.Last updated -361712MIT License
- -securityFlicense-qualityAn MCP (Multi-Agent Conversation Protocol) Server that provides access to Google Cloud's Dataproc Metastore API, enabling AI agents to manage and interact with Hive metastore services through natural language.Last updated -