Prototype · Preview: every server in the official registry, synced every 30 minutes. Sign in with Google to write reviews.Prototype · updated every 30 min
PopNx MCPMCP servers for people who use AI · explained in plain words

Hybrid Recursive Ladder

by MagicSquarekeyversion 0.0.8i★ 0iRuns on your computerOfficial site ↗
Registry nameio.github.MagicSquarekey/hybrid-recursive-ladder

How to install

What it does

Aggregate long time-series ranges with a few source requests instead of one per bucket.

  • Connects Runs on your computer
  • Account or key Needs HL_TB_PASSWORD, HL_TB_TOKEN, HL_PG_DSN
  • Category Other

Why it ranks here

Lists are ordered by a usage score (out of 100) built from these parts

Popularity7/80GitHub stars or weekly downloads: the larger counts 60, the smaller 20
Freshness12/12Full marks for a release or code change within 30 days
Still answering0/8The cloud endpoint answered at the last check
Usage score19/100

Quality: Passed 3/3 basic checks (shown, not used for ordering) · Momentum: No data yet (Used only on the Trending tab)

Install

Pick the AI app you use, then copy the settings.

Let your AI install it with one sentence

Please install Hybrid Recursive Ladder. Follow https://mcp.popnx.com/i/magicsquarekey-hybrid-recursive-ladder.md, show me the commands and wait for my OK before running them.

Paste it into an AI that can work on your computer (such as Claude Code or Cursor). It reads our steps, shows you the commands and waits for your OK. No key, no sign-up. · See the full text your AI reads

Passed 3/3 checks · Runs on your computer · ✓ Commands checked Nov 14, 2026

First: which AI do you use?

Pick your app and the steps appear below.

Works with Claude, with some setup first

You need a Hybrid Recursive Ladder key (create it on the maker’s site) · Install Python (uv) on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone

Let AI install it

Copy this message into a Claude chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Hybrid Recursive Ladder for Claude on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "hybrid-recursive-ladder": { "command": "uvx", "args": [ "hybrid-recursive-ladder-mcp" ], "env": { "HL_TB_PASSWORD": "your-value", "HL_TB_TOKEN": "your-value", "HL_PG_DSN": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For HL_TB_PASSWORD, HL_TB_TOKEN, HL_PG_DSN, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Hybrid Recursive Ladder tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install uv (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    uv --version
    • A version number such as uv … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required

    Open the uv download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version

    Install once; it works for everything that needs uv

  2. Sign up and create a Hybrid Recursive Ladder key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Hybrid Recursive Ladder site ↗

  3. Open the Claude desktop app’s settings file

    SettingsDeveloperEdit Config

  4. Paste these settings and save the file

    {
      "mcpServers": {
        "hybrid-recursive-ladder": {
          "command": "uvx",
          "args": [
            "hybrid-recursive-ladder-mcp"
          ],
          "env": {
            "HL_TB_PASSWORD": "your-value",
            "HL_TB_TOKEN": "your-value",
            "HL_PG_DSN": "your-value"
          }
        }
      }
    }

    Paste the key only into the app’s field, never into a chat or to anyone

  5. Quit Claude and open it again

  6. Try it

    Use Hybrid Recursive Ladder and tell me what you can do for me, then show me one thing

    ✓ If Claude says it is using Hybrid Recursive Ladder or shows a Hybrid Recursive Ladder tool in the answer, you are connected

5 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • HL_SOURCE Source backend: demo (default), thingsboard, or postgres.
  • HL_TB_URL ThingsBoard base URL, for example http://localhost:9090.
  • HL_TB_USERNAME ThingsBoard username; pair with HL_TB_PASSWORD.
  • HL_TIMEZONE IANA timezone for calendar boundaries; default Asia/Shanghai.
  • HL_FINEST Finest ladder level: minute, hour, day, or month.

Descriptions are as written by the maker.

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

ChatGPT cannot connect Hybrid Recursive Ladder yet

Hybrid Recursive Ladder runs on your computer, but ChatGPT can only connect servers that run on the web

What you can do instead

A · Use an app that can connect Hybrid Recursive Ladder

  • You need a Hybrid Recursive Ladder key (create it on the maker’s site) · Install Python (uv) on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone
  • You need a Hybrid Recursive Ladder key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
  • You need a Hybrid Recursive Ladder key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
  • You need a Hybrid Recursive Ladder key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)

B · Others in Other that work with ChatGPT

Picked from the most used in the same category, only ones that connect by address with no key

Works with Claude Code, with some setup first

You need a Hybrid Recursive Ladder key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)

Let AI install it

Copy this message into a Claude Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Hybrid Recursive Ladder for Claude Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): claude mcp add --scope user hybrid-recursive-ladder --env HL_TB_PASSWORD=your-value --env HL_TB_TOKEN=your-value --env HL_PG_DSN=your-value -- uvx hybrid-recursive-ladder-mcp 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For HL_TB_PASSWORD, HL_TB_TOKEN, HL_PG_DSN, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Hybrid Recursive Ladder tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install uv (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    uv --version
    • A version number such as uv … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required

    Open the uv download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version

    Install once; it works for everything that needs uv

  2. Sign up and create a Hybrid Recursive Ladder key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Hybrid Recursive Ladder site ↗

  3. Open Terminal

    Mac: press Command+Space and type Terminal · Windows: open PowerShell

  4. Paste this command and press Enter

    claude mcp add --scope user hybrid-recursive-ladder --env HL_TB_PASSWORD=your-value --env HL_TB_TOKEN=your-value --env HL_PG_DSN=your-value -- uvx hybrid-recursive-ladder-mcp

    Replace “your-value” with your key before pressing Enter

    Paste the key only into the app’s field, never into a chat or to anyone

  5. Type /mcp in Claude Code

    You should see Hybrid Recursive Ladder listed as connected

  6. Try it

    Use Hybrid Recursive Ladder and tell me what you can do for me, then show me one thing

    ✓ If Claude Code says it is using Hybrid Recursive Ladder or shows a Hybrid Recursive Ladder tool in the answer, you are connected

5 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • HL_SOURCE Source backend: demo (default), thingsboard, or postgres.
  • HL_TB_URL ThingsBoard base URL, for example http://localhost:9090.
  • HL_TB_USERNAME ThingsBoard username; pair with HL_TB_PASSWORD.
  • HL_TIMEZONE IANA timezone for calendar boundaries; default Asia/Shanghai.
  • HL_FINEST Finest ladder level: minute, hour, day, or month.

Descriptions are as written by the maker.

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with Cursor, with some setup first

You need a Hybrid Recursive Ladder key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)

Let AI install it

Copy this message into a Cursor chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Hybrid Recursive Ladder for Cursor on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "hybrid-recursive-ladder": { "command": "uvx", "args": [ "hybrid-recursive-ladder-mcp" ], "env": { "HL_TB_PASSWORD": "your-value", "HL_TB_TOKEN": "your-value", "HL_PG_DSN": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For HL_TB_PASSWORD, HL_TB_TOKEN, HL_PG_DSN, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Hybrid Recursive Ladder tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install uv (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    uv --version
    • A version number such as uv … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required

    Open the uv download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version

    Install once; it works for everything that needs uv

  2. Sign up and create a Hybrid Recursive Ladder key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Hybrid Recursive Ladder site ↗

  3. Click this button to open Cursor

    Open in Cursor

    Cursor asks you to confirm; click Install

  4. Fill in your key

    In the Hybrid Recursive Ladder settings, HL_TB_PASSWORD, HL_TB_TOKEN, HL_PG_DSN is empty; add your key and save

    Paste the key only into the app’s field, never into a chat or to anyone

  5. Open the AI chat in Cursor in Agent mode

  6. Try it

    Use Hybrid Recursive Ladder and tell me what you can do for me, then show me one thing

    ✓ If Cursor says it is using Hybrid Recursive Ladder or shows a Hybrid Recursive Ladder tool in the answer, you are connected

5 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • HL_SOURCE Source backend: demo (default), thingsboard, or postgres.
  • HL_TB_URL ThingsBoard base URL, for example http://localhost:9090.
  • HL_TB_USERNAME ThingsBoard username; pair with HL_TB_PASSWORD.
  • HL_TIMEZONE IANA timezone for calendar boundaries; default Asia/Shanghai.
  • HL_FINEST Finest ladder level: minute, hour, day, or month.

Descriptions are as written by the maker.

Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with VS Code, with some setup first

You need a Hybrid Recursive Ladder key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)

Let AI install it

Copy this message into a VS Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Hybrid Recursive Ladder for VS Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "servers": { "hybrid-recursive-ladder": { "type": "stdio", "command": "uvx", "args": [ "hybrid-recursive-ladder-mcp" ], "env": { "HL_TB_PASSWORD": "your-value", "HL_TB_TOKEN": "your-value", "HL_PG_DSN": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For HL_TB_PASSWORD, HL_TB_TOKEN, HL_PG_DSN, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Hybrid Recursive Ladder tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install uv (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    uv --version
    • A version number such as uv … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required

    Open the uv download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version

    Install once; it works for everything that needs uv

  2. Sign up and create a Hybrid Recursive Ladder key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Hybrid Recursive Ladder site ↗

  3. Click this button to open VS Code

    Open in VS Code

    VS Code asks you to confirm; click Install

  4. Fill in your key

    In the Hybrid Recursive Ladder settings, HL_TB_PASSWORD, HL_TB_TOKEN, HL_PG_DSN is empty; add your key and save

    Paste the key only into the app’s field, never into a chat or to anyone

  5. Open the AI chat in VS Code in Agent mode

  6. Try it

    Use Hybrid Recursive Ladder and tell me what you can do for me, then show me one thing

    ✓ If VS Code says it is using Hybrid Recursive Ladder or shows a Hybrid Recursive Ladder tool in the answer, you are connected

5 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • HL_SOURCE Source backend: demo (default), thingsboard, or postgres.
  • HL_TB_URL ThingsBoard base URL, for example http://localhost:9090.
  • HL_TB_USERNAME ThingsBoard username; pair with HL_TB_PASSWORD.
  • HL_TIMEZONE IANA timezone for calendar boundaries; default Asia/Shanghai.
  • HL_FINEST Finest ladder level: minute, hour, day, or month.

Descriptions are as written by the maker.

Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.

See every app that uses MCP →

JSON settings are under “For developers” below

Stuck? Ask people who use Hybrid Recursive Ladder💬 Discussion →
For developers: Terminal commands and JSON settings

Installed on your computer

Claude Code

claude mcp add --scope user hybrid-recursive-ladder --env HL_TB_PASSWORD=your-value --env HL_TB_TOKEN=your-value --env HL_PG_DSN=your-value -- uvx hybrid-recursive-ladder-mcp

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "hybrid-recursive-ladder": {
      "command": "uvx",
      "args": [
        "hybrid-recursive-ladder-mcp"
      ],
      "env": {
        "HL_TB_PASSWORD": "your-value",
        "HL_TB_TOKEN": "your-value",
        "HL_PG_DSN": "your-value"
      }
    }
  }
}

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "hybrid-recursive-ladder": {
      "command": "uvx",
      "args": [
        "hybrid-recursive-ladder-mcp"
      ],
      "env": {
        "HL_TB_PASSWORD": "your-value",
        "HL_TB_TOKEN": "your-value",
        "HL_PG_DSN": "your-value"
      }
    }
  }
}

VS Code (mcp.json)

{
  "servers": {
    "hybrid-recursive-ladder": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "hybrid-recursive-ladder-mcp"
      ],
      "env": {
        "HL_TB_PASSWORD": "your-value",
        "HL_TB_TOKEN": "your-value",
        "HL_PG_DSN": "your-value"
      }
    }
  }
}

Values you fill in

  • HL_SOURCE env
    Source backend: demo (default), thingsboard, or postgres.
  • HL_TB_URL env
    ThingsBoard base URL, for example http://localhost:9090.
  • HL_TB_USERNAME env
    ThingsBoard username; pair with HL_TB_PASSWORD.
  • HL_TB_PASSWORD secret required env
    ThingsBoard password.
  • HL_TB_TOKEN secret required env
    ThingsBoard access token, used instead of username and password.
  • HL_PG_DSN secret required env
    PostgreSQL DSN for the local materialized store.
  • HL_TIMEZONE env
    IANA timezone for calendar boundaries; default Asia/Shanghai.
  • HL_FINEST env
    Finest ladder level: minute, hour, day, or month.

Descriptions are as written by the maker.

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

At a glance

Downloads per weeki
325/wk
Connection
Runs on your computer
Latest versioni
0.0.8
Categoryi
Other
Published to registryi
Nov 13, 2026
Code last changedi
Nov 13, 2026
Maker
MagicSquarekey
Packages
pypi: hybrid-recursive-ladder-mcp
Registry status
Active

Which apps can use it

Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.

Run on your computer in

ClaudeGooseLM StudioMsty StudioCherry StudioCursorVS Code + GitHub CopilotVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantClaude CodeCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatRaycast

All apps, with pros and cons →

Related guides

What it can do

Runs on your computer; the tool list appears in your AI app after you install it.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 19, 2026

  • ✓ Pass

    Maker matches the repo

    The registry name was verified with the GitHub account MagicSquarekey, which owns the repo

  • ✓ Pass

    Still maintained

    Code last changed 6 days ago

  • ✓ Pass

    Has a licence

    Uses MIT

  • – Not applicable

    Endpoint responds

    This one runs on your computer; there is no internet endpoint

  • – Not applicable

    Sign-in with OAuth

    Runs on your computer and uses local settings instead

  • … Not checked yet

    No hidden instructions in tool descriptions

    Runs on your computer; we can only read tool lists from internet endpoints

Published vulnerabilities (OSV.dev)

No entries on OSV.dev for hybrid-recursive-ladder-mcp@0.0.8

Checks only this package version, not every dependency · checked Nov 15, 2026

What we check → · JSON

Makers: ask for a re-check or report wrong info
For makers: add a badge to your README

If you made this, paste this code into your README. The badge links back to this page.

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/magicsquarekey-hybrid-recursive-ladder.svg)](https://mcp.popnx.com/en/servers/magicsquarekey-hybrid-recursive-ladder)

Discussion

Ask, share a tip or report that it does not work. Sorted by what people marked helpful.

No posts yet. Be the first to ask or share.

Posts here are written by users, not the PopNx team.

Sign in to post

User reviews

No reviews yet

Sign in to write a review

Compared with others in Otheri

  • More stars than 0% of the other 20653 servers in this category
  • Published to the registry more recently than 89% of the other 20653 servers in this category
  • Basic checks equal to or better than 99% of the other 20653 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Common questions

Is Hybrid Recursive Ladder safe?

It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.

What keys or codes does it need?

You need to fill in: HL_TB_PASSWORD, HL_TB_TOKEN, HL_PG_DSN

Does it run on my computer or in the cloud?

It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).

Is it still maintained?

The GitHub repo last changed 6 days ago, and the latest version (0.0.8) reached the registry 6 days ago.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Python (uv) on your computer.

What can I use instead?

In the same category: World Monitor, openstatus, Oh My Posh Validator, Strata, Jitsu

Similar alternatives

Same category, other makers, commands already checked. Official ones first, then by stars.

Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

World Monitor

Real-time global intelligence on conflict, markets, energy, trade, shipping and cyber. 100 tools.

by koala73Widely used★ 90.9KUpdated 3 days ago

Runs in the cloud✓ service owner · worldmonitor.app

openstatus

Manage monitors, status pages, incidents and maintenances in your openstatus workspace.

by openstatusHQWidely used★ 9.3KUpdated 2 months ago

Runs in the cloud✓ service owner · openstatus.dev

Oh My Posh Validator

Validate oh-my-posh configurations and segment snippets against the official schema.

by JanDeDobbeleerWidely used★ 23.8K Stars for the whole repoUpdated 30 days ago

Runs in the cloud✓ service owner · ohmyposh.dev

Strata

MCP server for progressive tool usage at any scale (see https://klavis.ai)

by Klavis-AIGrowing★ 5.8KUpdated 14 months ago

Runs in the cloudRepo archived✓ klavis.ai

Jitsu

Manage Jitsu data pipelines: destinations, streams, connections, functions, live events.

by jitsucomWidely used★ 5.1KUpdated 4 months ago

Runs in the cloud✓ service owner · jitsu.com
Compared with similar ones
This one
Hybrid Recursive Ladder
World MonitoropenstatusOh My Posh ValidatorStrataJitsu
Runs whereInstalls on your computerRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to install
Needs a keyYesNoNoNoNoNo
Add with + in ClaudeNoNoNoNoNoNo
Basic checks3/34/44/44/41/44/4
LicenseMITAGPL-3.0AGPL-3.0MITApache-2.0MIT
PriceNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registry

README from the maker

Open the README

Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.

Hybrid Recursive Ladder

Query planning for bucket-limited time-series APIs. Aggregate long ranges with a handful of source requests instead of thousands of per-bucket queries.

Languages: English · 简体中文 · 日本語 · 한국어 · Español · Français · Deutsch · Português · Русский · العربية · हिन्दी

Algorithm spec · API reference · Benchmarks · Related work · Public disclosure · Docs index

Same output granularity. The per-bucket client pays one round trip per row; the ladder fetches each level once.

Why this exists

Most time-series APIs charge you per request, per bucket, or per round trip. A naive "one query per statistical bucket" client turns a two-day minute-level range into 2,880 buckets, each needing up to four HTTP calls. In a production ThingsBoard deployment, 1,140 buckets took 139 seconds over a VPN.

The bottleneck is not arithmetic. It is the number of network round trips.

Three obvious fixes all sacrifice something:

FixWhat it costs
Ask for one coarse intervalLoses the per-minute or per-day rows the dashboard needs
Pre-aggregate (continuous aggregates, rollup tables)Requires write access to, or control of, the source
PaginateSame number of pages, plus more boundary cases

The ladder takes a different route: keep the output granularity, but stop fetching one request per output unit. A source that can return an interval aggregate over a contiguous run can fill many output segments in one request.

How it works

  1. Decompose [start, end) into complete calendar units, from month down to the configured finest level. Emit only complete units; push the partial left and right edges to the next finer level.
  2. Group adjacent segments only when they need the same fetch level. Hours and minutes can share a minute-level run; months and days cannot.
  3. Fetch each maximal contiguous run once at the next finer aggregation: months as days, days as hours, hours as minutes, minutes as minutes.
  4. Fold the returned buckets into the output segments locally.

For 2026-01-01 00:00:00 → 2026-10-21 18:49:59, that is 97 segments instead of 423,049 minute buckets. A typical 10-month query needs roughly 5–7 aggregation requests.

Rules
  • Left-closed, right-open — [start, end).
  • Complete units only — a month/day/hour/minute is emitted at its level only when it lies entirely inside the range.
  • Recursive edges — a partial edge is pushed to the next finer level; a sub-minute remainder becomes its own tail segment.
  • Local calendar — boundaries use the configured IANA timezone (default Asia/Shanghai).
  • Tiling — segments are ordered, contiguous, non-overlapping, and their union is exactly [start, end).
Request bound

For a fetch run of duration T at bucket size Δ, with K buckets per request:

requests(run) = ceil(T / (K * Δ))

Fine-grained work is confined to the two partial units at the edges. For the default hierarchy, N <= N_month + 639; recursion depth is at most 4. The request count is O(N_month / K + 1) — it grows with the coarse units, not with the number of minute buckets. The formal propositions are in docs/algorithm.md §5.3–5.5 (中文).

Quick start

pip install hybrid-recursive-ladder

hybrid-ladder demo hybrid-ladder decompose --start 2026-01-01 --end 2026-10-21T18:49:59 hybrid-ladder calc --start 2026-01-01 --end 2026-02-01 --rule meter_delta --dimension day

The demo builds synthetic 15-minute data, decomposes a 120-day range, materializes half of it, runs a local-first mixed query, and verifies that the totals match. No database, no network, no configuration.

Optional extras:

pip install "hybrid-recursive-ladder[thingsboard]"   # ThingsBoard source (httpx)

pip install "hybrid-recursive-ladder[postgres]" # local store (psycopg 3) pip install "hybrid-recursive-ladder[api]" # FastAPI HTTP API pip install "hybrid-recursive-ladder[mcp]" # MCP server pip install "hybrid-recursive-ladder[all]" # everything

The core decomposition has zero third-party dependencies (only tzdata for reliable IANA time zones on Windows).

Usage

FormEntry pointBest for
Python libraryfrom hybrid_ladder import ...embedding in a service or pipeline
CLIhybrid-ladder ...ad-hoc inspection, scripts, cron
HTTP APIhybrid-ladder servelanguage-agnostic integration, async tasks
MCP serverhybrid-ladder mcpAI agents and MCP-compatible clients
Agent skillskills/hybrid-recursive-ladder/Claude/ZCode-style skill installation
Python library
from hybrid_ladder import LadderEngine, MemorySource

source = MemorySource() source.add("device-1", "energy", [(ts, 1.0) for ts in range(0, 86_400_000, 60_000)])

engine = LadderEngine(source) result = engine.sum([("device-1", "energy")], 0, 86_400_000)

print(result.grand_total) # 1440.0 print(result.rows[0].segments[0].label) # 1970-01-01 00:00 print(result.rows[0].empty_count) # 0

The engine depends on two small protocols: TimeSeriesSource (interval_agg, raw_series) and PointStore (sum_ranges, series, coverage, upsert_points, ...). Built-ins: MemorySource/MemoryStore, ThingsBoardSource, PostgresStore. See docs/architecture.md (中文) to add another source.

CLI
# Demo data

hybrid-ladder sum --series demo-chiller-1:energy --start 2026-01-01 --end 2026-02-01

ThingsBoard, local-first

export HL_TB_URL=https://tb.example.com export HL_TB_TOKEN=... export HL_PG_DSN='postgresql://user:pass@127.0.0.1:5432/telemetry' hybrid-ladder sum --source thingsboard --series : \ --start 2026-01-01 --end 2026-10-21T18:49:59 \ --mode mixed --materialize

Verify and repair the local copy

hybrid-ladder verify --source thingsboard --series : --start ... --end ... hybrid-ladder repair --source thingsboard --series : --start ... --end ...

HTTP API
hybrid-ladder serve --port 8000

OpenAPI docs: http://127.0.0.1:8000/docs

curl "http://127.0.0.1:8000/v1/decompose?start_ts=1767196800000&end_ts=1792512599000"

curl -X POST http://127.0.0.1:8000/v1/ladder/sum \ -H 'content-type: application/json' \ -d '{"series":[{"entity":"demo-chiller-1","key":"energy"}], "start_ts":1767196800000,"end_ts":1777564800000,"mode":"tb"}'

→ {"code":0,"data":{"task_id":"...","async":true}}

curl http://127.0.0.1:8000/v1/tasks/

The API uses {"code":0,"data":...} on success and {"code":1,"detail":...} on error. Every endpoint is in docs/api.md (中文).

MCP server
pip install "hybrid-recursive-ladder[mcp]"

hybrid-ladder mcp

Tools: ladder_meta, ladder_decompose, ladder_sum, ladder_verify. With no configuration it serves demo data, so an agent can try it immediately. Example client configuration:

{

"mcpServers": { "hybrid-ladder": { "command": "hybrid-ladder", "args": ["mcp"], "env": { "HL_SOURCE": "thingsboard", "HL_TB_URL": "https://tb.example.com", "HL_TB_TOKEN": "...", "HL_PG_DSN": "postgresql://..." } } } }

Agent skill

Copy skills/hybrid-recursive-ladder/ into your agent's skills directory (for example ~/.claude/skills/ or ~/.zcode/skills/). The skill teaches the agent when to use the ladder, how to call the CLI/API, and how to interpret null vs 0.0 and source.

Local-first mode

When you have a local point store, the same segments are split against materialized coverage. Covered parts come from one batched local query; uncovered parts come from the source; a partially covered segment fetches only the missing slice.

<img

Only the beginning is shown; read the rest in the repo