helfer-mcp

helpwithmetrics/helfer-mcp

3.2

If you are the rightful owner of helfer-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Helfer MCP server for Claude is a tool designed to enhance data analysis and visualization capabilities by integrating with Claude Desktop.

Tools

  1. helfer

    A tool to answer questions about data using SQL queries and generate interactive HTML artifacts.

Helfer MCP server for Claude

Installation Instructions

  1. Install Claude Desktop Subscription Required for some models. We recommend at least Sonnet 4.
  2. Create new Writing style create_style

custom_style

describe_style

create_custom_style

  1. Use this Prompt to start with, You can tune it to your preferences, for example to show only static tables instead of creating iteractive dashboards:
Use helfer tool to answer question about data. The answer may contain HTML tables, extract the HTML text and create artifact to show results in nice interactive html artifact. 
Provide key highlights. If result does not answer the user question then try to run multiple sql queries to helfer and summarize the results.
Then at the end also show the explanation from Helfer and show the generated sql in a code snippet artifact using sql syntax

Don't forget to select the style you just created. select_style

  1. Download this repo, and extract it. Make sure to figure out the path to the downloaded files.
  2. Install uv:

For Mac (with brew):

brew install uv

For Windows:

powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"
  1. Get started by opening up the Claude menu on your computer and select “Settings…” Please note that these are not the Claude Account Settings found in the app window itself.

This is what it should look like on a Mac (in windows there's a Menu icon next in the top left corner of the window):

Then hit the "Edit Config" button. This will open a Finder (File Explorer) window. Open the file claude_desktop_config.json with your favorite editor.

  1. Add this content to your claude config file, replace the path with the correct path to your downloaded files:

For Mac:

{
"mcpServers": {
  "helfer": {
    "command": "uv",
    "args": [
      "--directory",
      "/Users/john/Downloads/helfer-mcp-main",
      "run",
      "helfer.py"
    ]
  }
}
}

For Windows:

{
"mcpServers": {
  "helfer": {
    "command": "uv",
    "args": [
      "--directory",
      "C:\\Users\\JOHN\\Downloads\\helfer-mcp-main",
      "run",
      "helfer.py"
    ]
  }
}
}
  1. Open the .env file inside your helfer-mcp-main folder and input your username and password for Helfer AI.
HELFER_USERNAME=<username>
HELFER_PASSWORD=<password>

For Mac the file may be not visible from finder, you can edit it from the terminal:

 nano /Users/john/Downloads/helfer-mcp-main/.env
  1. Restart Claude and make sure MCP tools from Helfer are enabled.

mcps

helfer-tools

  1. Start your prompts with ask helfer , for example: prompt-example