# HiveServer2 MCP

A MCP server for HiveServer2.

## Installation

1.  **Clone the repository:**

    ```bash
    git clone https://github.com/your-username/hiveserver2-mcp.git
    cd hiveserver2-mcp
    ```

2.  **Create a virtual environment:**

    ```bash
    python3 -m venv venv
    source venv/bin/activate
    ```

3.  **Install the dependencies:**

    ```bash
    pip install -r requirements.txt
    ```

## Usage

1.  **Create a `.env` file:**

    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>
    ```

2.  **Run the server:**

    ```bash
    hiveserver2-mcp
    ```

3.  **Interact with the server:**

    You can use `curl` to interact with the server.

    **Query:**

    ```bash
    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:**

```bash
sudo apt-get install -y libsasl2-dev
pip install sasl
```

**macOS:**

```bash
brew install sasl
pip install sasl
```