x=hub

your toolset

    build deployment
    sign in

    Lagaam

    mcpkey · package
    io.github.lagaam-ai/lagaam · v0.2.5
    deploy just this

    Stops an agent's Trino or Pinot query before it runs if it costs too much or reads outside its grant

    run it

    on your own machines, one way per deploy method
    generated from the record, not tested yet
    # once, as root:
# as_mcp DIR COMMAND...: runs COMMAND as the mcp user in DIR, its home, sandboxed as the
# units are: a package's install scripts can write to DIR only, as the server later can
as_mcp() {
  local dir="$1"; shift
  systemd-run --quiet --wait --pipe --collect --uid=mcp --gid=mcp \
    -p WorkingDirectory="$dir" -p Environment=HOME="$dir" -p ReadWritePaths="$dir" \
    -p NoNewPrivileges=true -p ProtectSystem=strict -p ProtectHome=true -p PrivateTmp=true \
    -- "$@" </dev/null
}
install -d -m 0750 -o mcp -g mcp /var/lib/mcp/lagaam
# lagaam: its packages, installed whole before its unit starts (no session installs)
systemctl stop mcp-my-agent-lagaam.service 2>/dev/null || true
as_mcp /var/lib/mcp/lagaam uv tool install lagaam==0.2.5
as_mcp /var/lib/mcp/lagaam uv tool install mcp-proxy

#!/usr/bin/env bash
# lagaam (io.github.lagaam-ai/lagaam), recipe baremetal (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-lagaam.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec uvx mcp-proxy --host 127.0.0.1 --port 8101 --pass-environment -- uvx lagaam==0.2.5

[Unit]
Description=MCP server lagaam (toolset my-agent), generated by Hub
After=network-online.target
Wants=network-online.target

[Service]
Type=simple
User=mcp
Group=mcp
EnvironmentFile=/etc/mcp/my-agent.env
Environment=HOME=/var/lib/mcp/lagaam
WorkingDirectory=/var/lib/mcp/lagaam
ExecStart=/opt/mcp/my-agent/bin/lagaam.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/lagaam

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    docker run --rm -p 127.0.0.1:8101:8000 -e LAGAAM_ALLOWED_TABLES -e LAGAAM_ALLOW_ALL_TABLES -e LAGAAM_ENGINE -e TRINO_HOST -e TRINO_PORT -e TRINO_USER -e PINOT_CONTROLLER_URL -e PINOT_BROKER_URL -e PINOT_USER -e PINOT_PASSWORD -e LAGAAM_AGENT_NAME -e LAGAAM_MAX_SCAN_BYTES -e LAGAAM_MAX_ROWS -e LAGAAM_MAX_INTERMEDIATE_ROWS -e LAGAAM_MAX_RETURNED_ROWS -e LAGAAM_QUERY_TIMEOUT -e LAGAAM_METADATA_TTL -e LAGAAM_AUDIT_LOG ghcr.io/astral-sh/uv:python3.12-bookworm-slim sh -c 'uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx lagaam==0.2.5'
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T17:44:46+00:00).
# Each package server runs behind a stdio->HTTP bridge and listens on localhost only.
#   cp .env.example .env    # fill the ${VAR}s
#   docker compose up -d && bash smoke.sh
# Remote servers are not here: clients reach them directly (see clients/).
name: mcp-my-agent
services:
  lagaam:
    image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
    command:
    - sh
    - -c
    - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx lagaam==0.2.5
    ports:
    - 127.0.0.1:8101:8000
    volumes:
    - uv-cache:/root/.cache/uv
    healthcheck:
      test:
      - CMD
      - python3
      - -c
      - import urllib.request; urllib.request.urlopen('http://127.0.0.1:8000/status')
      interval: 30s
      timeout: 5s
      retries: 5
      start_period: 2m
    restart: unless-stopped
    environment:
      LAGAAM_ALLOWED_TABLES: ${LAGAAM_ALLOWED_TABLES}
      LAGAAM_ALLOW_ALL_TABLES: ${LAGAAM_ALLOW_ALL_TABLES}
      LAGAAM_ENGINE: ${LAGAAM_ENGINE}
      TRINO_HOST: ${TRINO_HOST}
      TRINO_PORT: ${TRINO_PORT}
      TRINO_USER: ${TRINO_USER}
      PINOT_CONTROLLER_URL: ${PINOT_CONTROLLER_URL}
      PINOT_BROKER_URL: ${PINOT_BROKER_URL}
      PINOT_USER: ${PINOT_USER}
      PINOT_PASSWORD: ${PINOT_PASSWORD}
      LAGAAM_AGENT_NAME: ${LAGAAM_AGENT_NAME}
      LAGAAM_MAX_SCAN_BYTES: ${LAGAAM_MAX_SCAN_BYTES}
      LAGAAM_MAX_ROWS: ${LAGAAM_MAX_ROWS}
      LAGAAM_MAX_INTERMEDIATE_ROWS: ${LAGAAM_MAX_INTERMEDIATE_ROWS}
      LAGAAM_MAX_RETURNED_ROWS: ${LAGAAM_MAX_RETURNED_ROWS}
      LAGAAM_QUERY_TIMEOUT: ${LAGAAM_QUERY_TIMEOUT}
      LAGAAM_METADATA_TTL: ${LAGAAM_METADATA_TTL}
      LAGAAM_AUDIT_LOG: ${LAGAAM_AUDIT_LOG}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T17:44:47+00:00).
#   kubectl create namespace mcp
#   kubectl -n mcp create secret generic mcp-credentials --from-env-file=.env
#   kubectl apply -f kubernetes.yaml
# Services are cluster-internal: <name>.mcp.svc.cluster.local:8000/mcp. Put an ingress
# with auth in front before exposing any of them.
apiVersion: v1
kind: Namespace
metadata:
  name: mcp
---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: lagaam
  namespace: mcp
  labels: &id001
    app: lagaam
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: lagaam
        image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: LAGAAM_ALLOWED_TABLES
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_ALLOWED_TABLES
        - name: LAGAAM_ALLOW_ALL_TABLES
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_ALLOW_ALL_TABLES
        - name: LAGAAM_ENGINE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_ENGINE
        - name: TRINO_HOST
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: TRINO_HOST
        - name: TRINO_PORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: TRINO_PORT
        - name: TRINO_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: TRINO_USER
        - name: PINOT_CONTROLLER_URL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PINOT_CONTROLLER_URL
        - name: PINOT_BROKER_URL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PINOT_BROKER_URL
        - name: PINOT_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PINOT_USER
        - name: PINOT_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PINOT_PASSWORD
        - name: LAGAAM_AGENT_NAME
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_AGENT_NAME
        - name: LAGAAM_MAX_SCAN_BYTES
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_MAX_SCAN_BYTES
        - name: LAGAAM_MAX_ROWS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_MAX_ROWS
        - name: LAGAAM_MAX_INTERMEDIATE_ROWS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_MAX_INTERMEDIATE_ROWS
        - name: LAGAAM_MAX_RETURNED_ROWS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_MAX_RETURNED_ROWS
        - name: LAGAAM_QUERY_TIMEOUT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_QUERY_TIMEOUT
        - name: LAGAAM_METADATA_TTL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_METADATA_TTL
        - name: LAGAAM_AUDIT_LOG
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LAGAAM_AUDIT_LOG
        args:
        - sh
        - -c
        - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx lagaam==0.2.5
        readinessProbe:
          httpGet:
            path: /status
            port: http
          initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
  name: lagaam
  namespace: mcp
spec:
  selector:
    app: lagaam
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T17:44:47+00:00).
# Credentials come from the Secret 'mcp-credentials' (kubectl create secret generic ... --from-env-file=.env).
# Each server under `servers` is one Deployment + Service; the keys after it configure
# upstream charts a worker verified.
servers:
  lagaam:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: lagaam
      image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: LAGAAM_ALLOWED_TABLES
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_ALLOWED_TABLES
      - name: LAGAAM_ALLOW_ALL_TABLES
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_ALLOW_ALL_TABLES
      - name: LAGAAM_ENGINE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_ENGINE
      - name: TRINO_HOST
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: TRINO_HOST
      - name: TRINO_PORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: TRINO_PORT
      - name: TRINO_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: TRINO_USER
      - name: PINOT_CONTROLLER_URL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PINOT_CONTROLLER_URL
      - name: PINOT_BROKER_URL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PINOT_BROKER_URL
      - name: PINOT_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PINOT_USER
      - name: PINOT_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PINOT_PASSWORD
      - name: LAGAAM_AGENT_NAME
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_AGENT_NAME
      - name: LAGAAM_MAX_SCAN_BYTES
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_MAX_SCAN_BYTES
      - name: LAGAAM_MAX_ROWS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_MAX_ROWS
      - name: LAGAAM_MAX_INTERMEDIATE_ROWS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_MAX_INTERMEDIATE_ROWS
      - name: LAGAAM_MAX_RETURNED_ROWS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_MAX_RETURNED_ROWS
      - name: LAGAAM_QUERY_TIMEOUT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_QUERY_TIMEOUT
      - name: LAGAAM_METADATA_TTL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_METADATA_TTL
      - name: LAGAAM_AUDIT_LOG
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LAGAAM_AUDIT_LOG
      args:
      - sh
      - -c
      - uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx lagaam==0.2.5
      readinessProbe:
        httpGet:
          path: /status
          port: http
        initialDelaySeconds: 10

# helm install my-agent helm/my-agent -n mcp

    in the cloud

    one click: the provider's deploy form opens filled in, in your own account
    koyeb
    deploy to koyeb

    The form opens with CHANGE_ME for each value you supply: LAGAAM_ALLOWED_TABLES, LAGAAM_ALLOW_ALL_TABLES, LAGAAM_ENGINE, TRINO_HOST, TRINO_PORT, TRINO_USER, PINOT_CONTROLLER_URL, PINOT_BROKER_URL, PINOT_USER, PINOT_PASSWORD, LAGAAM_AGENT_NAME, LAGAAM_MAX_SCAN_BYTES, LAGAAM_MAX_ROWS, LAGAAM_MAX_INTERMEDIATE_ROWS, LAGAAM_MAX_RETURNED_ROWS, LAGAAM_QUERY_TIMEOUT, LAGAAM_METADATA_TTL, LAGAAM_AUDIT_LOG. Fill them in before you deploy.

    Clients connect to the service's https://…koyeb.app address plus /mcp.

    azure
    deploy to azuretemplate

    A Container Apps environment with one app per server, each with HTTPS ingress and one replica. The portal asks for each value you supply as a secure parameter; the deployment's outputs list the endpoints.

    connect to it

    copy what your client needs
    uvx lagaam==0.2.5
# env: LAGAAM_ALLOWED_TABLES, LAGAAM_ALLOW_ALL_TABLES, LAGAAM_ENGINE, TRINO_HOST, TRINO_PORT, TRINO_USER, PINOT_CONTROLLER_URL, PINOT_BROKER_URL, PINOT_USER, PINOT_PASSWORD, LAGAAM_AGENT_NAME, LAGAAM_MAX_SCAN_BYTES, LAGAAM_MAX_ROWS, LAGAAM_MAX_INTERMEDIATE_ROWS, LAGAAM_MAX_RETURNED_ROWS, LAGAAM_QUERY_TIMEOUT, LAGAAM_METADATA_TTL, LAGAAM_AUDIT_LOG
    {
  "mcpServers": {
    "lagaam": {
      "command": "uvx",
      "args": [
        "lagaam==0.2.5"
      ],
      "env": {
        "LAGAAM_ALLOWED_TABLES": "${LAGAAM_ALLOWED_TABLES}",
        "LAGAAM_ALLOW_ALL_TABLES": "${LAGAAM_ALLOW_ALL_TABLES}",
        "LAGAAM_ENGINE": "${LAGAAM_ENGINE}",
        "TRINO_HOST": "${TRINO_HOST}",
        "TRINO_PORT": "${TRINO_PORT}",
        "TRINO_USER": "${TRINO_USER}",
        "PINOT_CONTROLLER_URL": "${PINOT_CONTROLLER_URL}",
        "PINOT_BROKER_URL": "${PINOT_BROKER_URL}",
        "PINOT_USER": "${PINOT_USER}",
        "PINOT_PASSWORD": "${PINOT_PASSWORD}",
        "LAGAAM_AGENT_NAME": "${LAGAAM_AGENT_NAME}",
        "LAGAAM_MAX_SCAN_BYTES": "${LAGAAM_MAX_SCAN_BYTES}",
        "LAGAAM_MAX_ROWS": "${LAGAAM_MAX_ROWS}",
        "LAGAAM_MAX_INTERMEDIATE_ROWS": "${LAGAAM_MAX_INTERMEDIATE_ROWS}",
        "LAGAAM_MAX_RETURNED_ROWS": "${LAGAAM_MAX_RETURNED_ROWS}",
        "LAGAAM_QUERY_TIMEOUT": "${LAGAAM_QUERY_TIMEOUT}",
        "LAGAAM_METADATA_TTL": "${LAGAAM_METADATA_TTL}",
        "LAGAAM_AUDIT_LOG": "${LAGAAM_AUDIT_LOG}"
      }
    }
  }
}
    #!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add lagaam -e "LAGAAM_ALLOWED_TABLES=${LAGAAM_ALLOWED_TABLES}" -e "LAGAAM_ALLOW_ALL_TABLES=${LAGAAM_ALLOW_ALL_TABLES}" -e "LAGAAM_ENGINE=${LAGAAM_ENGINE}" -e "TRINO_HOST=${TRINO_HOST}" -e "TRINO_PORT=${TRINO_PORT}" -e "TRINO_USER=${TRINO_USER}" -e "PINOT_CONTROLLER_URL=${PINOT_CONTROLLER_URL}" -e "PINOT_BROKER_URL=${PINOT_BROKER_URL}" -e "PINOT_USER=${PINOT_USER}" -e "PINOT_PASSWORD=${PINOT_PASSWORD}" -e "LAGAAM_AGENT_NAME=${LAGAAM_AGENT_NAME}" -e "LAGAAM_MAX_SCAN_BYTES=${LAGAAM_MAX_SCAN_BYTES}" -e "LAGAAM_MAX_ROWS=${LAGAAM_MAX_ROWS}" -e "LAGAAM_MAX_INTERMEDIATE_ROWS=${LAGAAM_MAX_INTERMEDIATE_ROWS}" -e "LAGAAM_MAX_RETURNED_ROWS=${LAGAAM_MAX_RETURNED_ROWS}" -e "LAGAAM_QUERY_TIMEOUT=${LAGAAM_QUERY_TIMEOUT}" -e "LAGAAM_METADATA_TTL=${LAGAAM_METADATA_TTL}" -e "LAGAAM_AUDIT_LOG=${LAGAAM_AUDIT_LOG}" -- uvx lagaam==0.2.5

    {
  "mcpServers": {
    "lagaam": {
      "command": "uvx",
      "args": [
        "lagaam==0.2.5"
      ],
      "env": {
        "LAGAAM_ALLOWED_TABLES": "${LAGAAM_ALLOWED_TABLES}",
        "LAGAAM_ALLOW_ALL_TABLES": "${LAGAAM_ALLOW_ALL_TABLES}",
        "LAGAAM_ENGINE": "${LAGAAM_ENGINE}",
        "TRINO_HOST": "${TRINO_HOST}",
        "TRINO_PORT": "${TRINO_PORT}",
        "TRINO_USER": "${TRINO_USER}",
        "PINOT_CONTROLLER_URL": "${PINOT_CONTROLLER_URL}",
        "PINOT_BROKER_URL": "${PINOT_BROKER_URL}",
        "PINOT_USER": "${PINOT_USER}",
        "PINOT_PASSWORD": "${PINOT_PASSWORD}",
        "LAGAAM_AGENT_NAME": "${LAGAAM_AGENT_NAME}",
        "LAGAAM_MAX_SCAN_BYTES": "${LAGAAM_MAX_SCAN_BYTES}",
        "LAGAAM_MAX_ROWS": "${LAGAAM_MAX_ROWS}",
        "LAGAAM_MAX_INTERMEDIATE_ROWS": "${LAGAAM_MAX_INTERMEDIATE_ROWS}",
        "LAGAAM_MAX_RETURNED_ROWS": "${LAGAAM_MAX_RETURNED_ROWS}",
        "LAGAAM_QUERY_TIMEOUT": "${LAGAAM_QUERY_TIMEOUT}",
        "LAGAAM_METADATA_TTL": "${LAGAAM_METADATA_TTL}",
        "LAGAAM_AUDIT_LOG": "${LAGAAM_AUDIT_LOG}"
      }
    }
  }
}
    {
  "servers": {
    "lagaam": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "lagaam==0.2.5"
      ],
      "env": {
        "LAGAAM_ALLOWED_TABLES": "${LAGAAM_ALLOWED_TABLES}",
        "LAGAAM_ALLOW_ALL_TABLES": "${LAGAAM_ALLOW_ALL_TABLES}",
        "LAGAAM_ENGINE": "${LAGAAM_ENGINE}",
        "TRINO_HOST": "${TRINO_HOST}",
        "TRINO_PORT": "${TRINO_PORT}",
        "TRINO_USER": "${TRINO_USER}",
        "PINOT_CONTROLLER_URL": "${PINOT_CONTROLLER_URL}",
        "PINOT_BROKER_URL": "${PINOT_BROKER_URL}",
        "PINOT_USER": "${PINOT_USER}",
        "PINOT_PASSWORD": "${PINOT_PASSWORD}",
        "LAGAAM_AGENT_NAME": "${LAGAAM_AGENT_NAME}",
        "LAGAAM_MAX_SCAN_BYTES": "${LAGAAM_MAX_SCAN_BYTES}",
        "LAGAAM_MAX_ROWS": "${LAGAAM_MAX_ROWS}",
        "LAGAAM_MAX_INTERMEDIATE_ROWS": "${LAGAAM_MAX_INTERMEDIATE_ROWS}",
        "LAGAAM_MAX_RETURNED_ROWS": "${LAGAAM_MAX_RETURNED_ROWS}",
        "LAGAAM_QUERY_TIMEOUT": "${LAGAAM_QUERY_TIMEOUT}",
        "LAGAAM_METADATA_TTL": "${LAGAAM_METADATA_TTL}",
        "LAGAAM_AUDIT_LOG": "${LAGAAM_AUDIT_LOG}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.lagaam-ai/lagaam
    • not probed yet: tools unpinned, ingest lists them

    tools

    Not probed yetThe tools appear once the hub or its worker has listed this entry. Running it still works: your client lists them on first start.