Independent by design · no pay-to-rank placements  · How we evaluate tools →
Anclum Submit
R

rantree-hive/hafsql-hive

Independent directory — not the official site. Details below come from the project's public repository.

Claude Code skill for HafSQL — query patterns, virtual-op routing, vote-value formula, and Hive API pitfalls for Hive blockchain backends.

1 ★ measured · checked 2026-11-19

Before you install: command ownership unverified - shown for reference only · no license recorded

First step (reference only, ownership unverified): npx skills add rantree-hive/hafsql-hive

★ 1·updated 2026-11-19
View on GitHub ↗Direct link · no redirect page

After install: how to tell it works

  1. What you see after install — The command exits 0 and the terminal shows no "command not found" or "permission denied".
  2. One-line self-check — Run the smallest usage example from that repository's README. If the output matches what the README describes, it is working.
  3. If that does not work — This project has no troubleshooting notes. Search its issues for "install".

The install command comes from the repository; these checks describe observable results only and do not replace the project's own docs.

Star count
1 ★ · rantree-hive/hafsql-hive · read from the GitHub search API · (checked 2026-11-19 20:00:48)
Source
read directly from its GitHub page · type: open-source project
Harvest history
first seen 2026-11-20 · last seen 2026-11-20 · seen 1× · listed by 1 sources
Score
score 103 · 1 ★ · 1 sources · repo
Install
see Install & config above
FAQ (answers come from our records)
Who is it for?
We filed it under these tags: Open Source. The tags come from the entry itself, not a taxonomy we imposed.
Who maintains it?
repository rantree-hive/hafsql-hive;first catalogued 2026-11-20;last seen 2026-11-20。There is no official certification or quality rating here — we record sources and dates only.
README excerpt (English, untranslated) · Read the full README on GitHub →

# hafsql-hive

Excerpted from the repository README (abridged)

A Claude Code skill for building correct, performant queries against HafSQL — the PostgreSQL layer over HAF-indexed Hive blockchain data.
## Install
bash
npx skills add rantree-hive/hafsql-hive
## What it covers
Which HafSQL table to use for each operation type — including the virtual-op trap (haf_operations silently returns 0 rows for reward ops)
HafSQL utility functions: id_from_timestamp, get_timestamp, to_json
Multi-window aggregation with id_from_timestamp (30d / 7d / all-time in one query)
operation_comment_reward_table timing trap (fires at payout, not post creation — use 30d window)
VESTS → HP conversion via hafsql.dynamic_global_properties.vests_per_hive
Vote value / rshares formula — the correct 1_000_000 / 25 scaling factor (empirically verified 2026-11); common wrong factors and their symptoms
RC% calculation with mana regeneration forward-projection (raw current_mana is stale)
rc_api.find_rc_accounts correct params form: plain object, not array-wrapped
HAFAH broken fields: reputation: 0, comment_count: 0 from condenser_api.get_accounts — correct sources
hive_accounts_info_view.post_count includes comments — use hafsql.comments WHERE parent_author='' for root-only count
Profile metadata from hivemind_app.hive_accounts_info_view.posting_json_metadata
Precision-aware parseAmt for both old string and new asset-object API formats
Schema layers: hafd layer-0 raw tables, generic views, dedicated op tables, and the op_type name format
Per-voter parallel scan for vote queries over many accounts (avoids slow bitmap scans on voter = ANY(...))
Vote value from actual rshares via hivemind_app.hive_votes_view
milli-VESTS scaling in hafsql.balances.vests and hafsql.accounts.incoming_vests / outgoing_vests
Operation timeline with haf_account_operations cursor pagination, plus reading custom_json via the hafd account-operation index
haf_operations.body wrapping on HAFAH nodes (body?.value)
hafsql.comments payout columns: SPLIT_PART string format, tags JSONB filter, active vs. paid-out detection, sub-account LIKE pattern
Production pool setup with circuit breaker, retry, and statement_timeout
Correct custom_json column (json text → hafsql.to_json(json)) and op-type registry names
Comment edits are separate ops: DISTINCT ON dedup in operation_comment_view, stale hafsql.comments.body, bounding comment scans by created
DHF / proposal payouts via operation_proposal_pay_table (a virtual op, not a transfer)
Post community/category resolution through hivemind joins, plus snap/microblog community IDs
Listed badge (optional)
Copy this line into the README if you want the listing mark. Optional, and it does not affect being listed.
[![Listed on Anclum](https://anclum.com/badge/listed.svg)](https://anclum.com/en/s/rantree-hive-hafsql-hive/)
Source
github · https://github.com/rantree-hive/hafsql-hive
Browse by field
Open source
Traction
1 ★
added
today

More entries

All 1,875 →

Filed under

Every tag opens the full list for that filter. Counts are the live catalogue figures.

Browse all fields →

← Back to index