StarRocks MCP 之销售数据洞察

背景

准备

  • n8n工作流
  • starRocks
  • starRocks MCP

实践

让n8n支持uvx,uv

  • 改造n8n镜像,使其支持uv,uvx

    主要为安装uv工具,增加 /data/mcp 目录用于挂载mcp

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    FROM n8nio/n8n:1.93.0

    USER root

    # Install necessary system packages
    RUN apk add --no-cache \
    curl \
    git \
    build-base \
    chromium \
    bash \
    tar \
    xz \
    util-linux \
    coreutils

    # Install Astral uv/uvx and make available system-wide
    RUN curl -Ls https://astral.sh/uv/install.sh | bash \
    && cp /root/.local/bin/uv /usr/local/bin/uv \
    && cp /root/.local/bin/uvx /usr/local/bin/uvx \
    && chmod a+rx /usr/local/bin/uv /usr/local/bin/uvx \
    && mkdir -p /data/mcp \
    && chown -R node:node /data/mcp

    ENV PATH="/usr/local/bin:/root/.local/bin:${PATH}"

    USER node