Show row counts and when the data was last refreshed.

List heroes ranked by tier. mode e.g. overall/Guild War/Arena/Dungeons; tier filters (S+, S, A+...).

Full hero record: the complete game data (combat, base per evolution, level curves, main skill per level, totem, icon) merged with tier + build tags.

Ranked tier list for a mode (overall/Guild War/Arena/Dungeons/HBM-LBF/Blitz).

Talent effect and capability tags.

Insignia/crest-item (Equipment table, 208 items): per-level Hp/Attack + effect text.

Career crest (Camp: Oracle/Saint/Brawler/Orderbound/Voidwalker): per-level Attack/HP/Tenacity/Crit/Dodge/Hit_DMG.

Rune (Runes table, 101): per-level Hp/Attack + effect.

Enchantment = Soul-Arms skill (e.g. 'Bold Ambition', 'Forest Ward'): per-level from game data.

Equipment item (Equipment table): per-level Hp/Attack + effect text.

Effect of a talent or hero skill at a specific level. kind='talent' or 'hero'. Returns that level's effect text (+ might/cooldown if present) and the full range.

LIVE fully-computed stats for a hero at a given level (1-200), via casclash's calculator (there is no official IGG API). Returns HP, Attack, ATK SPD, MOV SPD, Attack Range, ACC, Dodge, CRIT, CRIT DMG, CRIT Resist. talent = talent NAME (e.g. 'Tenacity') or id, with talent_lvl 1-10; reincarnation=1 is the normal evolved form. camp(crest)/pet/inscription are numeric ids (0 = none).

TRUSTWORTHY formula-based stats (validated exactly vs the user's real game: Serratica 10 stars/L200 = 180,695 HP). stat = perStarStars + inc(Level-1); evo=1/2 uses Fandom's exact Legendary evolution params. Optional talent name + level applies its HP/ATK %. Prefer this over hero_stats (casclash caps stars at 4). inscription/soularms/artifact are LEVELS; gear_json is a JSON list of {type:'insignia'|'rune', name, level} — all fold into the returned effective stats (flat HP/ATK on top of the talent-% base).

EXACT per-level HP/Attack/MOV/Might from casclash's tables (Lv1-80, per evolution), authoritative, no formula. evo = 'Ordinary'|'Evolution1'|'Evolution2'|'max'. For level>80 or higher stars use hero_stats_calc (formula).

Per-level effect + English description for any of the 421 game skills (from decoded Skill.data). skill = name (e.g. 'Divine Shield') or numeric name_id.

A hero's skills: totem skill (name + level count, from Hero.data naming scheme) and a pointer to the main active skill (via get_hero / hero_level_stats from the wiki).

List all 182 game data tables extracted from the APK (buildings, dungeons, pets, soul arms, inscriptions, summon rates, battle pass, guild, monsters, ...).

Rows of a game data table by name (see list_game_tables). Rows carry English *_en fields.

Full-text search across ALL 182 game tables. Returns matching rows with their table name.

Pet lookup (Pet table): id, mark, and its pet-talent. Note: pets give a team-wide %% aura, browsable here but not folded into hero_stats_calc's per-hero flat stats.

Soul-Arms base stats at a given level (flat Attack/HP/Tenacity added to a hero).

Every Castle Clash data system and its entry count (heroes, skills, talents, crests, insignias, gear, holy, traits, relics, soul, pets, magic, buildings, monsters, gacha, items...).

Rows of a game system (see game_systems). English-annotated (name_en).

One entry from a system by English name, with its full per-level/per-star data (e.g. system_lookup('holy','Divine Roots'), ('crest','Revive Crest I'), ('gear','Dragon Ring')).

The COMPLETE hero record: combat stats, base per evolution, full level curves (Ord/Evo1/Evo2 1-80), main skill per level, totem skill, icon. The authoritative all-in-one hero entry.

Icon path for a hero/skill/item/pet (kind from icon_maps). Omit key to list icon kinds.

Drop odds for a gacha pool (by Type): each reward with its weight and probability %. Omit/unknown type returns the list of available pool types.

Search across ALL 28 game systems at once (heroes, skills, talents, gear, items, ...).

Side-by-side computed stats for two heroes at the same stars/level.

Rank heroes by a computed stat (HP/Attack) at given stars/level. Newest epics may be missing.

A hero's Totem skill with English description per level (from totem_skills_full).

EVERYTHING about a hero in one call: complete stats + main skill + totem skill summary + tier + a recommended build. The one-stop hero overview.

Recommend a full 5-slot build (talent, crest, insignia, enchantment, pet). Pass any slot to fix it (e.g. talent='Wicked Armor'); the engine fills the rest without anti-synergies (reflection in the enchant slot, energy in talent-or-crest) and explains every pick.

Validate a 5-slot build: flags reflection redundancy (two slots), energy gaps, missing reflection/ATK, signature-talent HP penalties, and revive suggestions. Returns findings + ok.

List catalog categories and how many entries each has (talent, enchantment, pet, crest, trait, signature, buildings, decorations, dungen, watchers, ...).

List all entries in a catalog category (e.g. pet, crest, trait, signature, buildings, decorations, dungen, watchers, slime, talent, enchantment).

Get one catalog entry (effect/stats where casclash provides them).

Rebuild the database: load seed catalog and (unless seed_only) scrape casclash. limit caps heroes scraped.

Explain one hit using the engine's exact formulas (recovered from libgame.so, see docs/GAME_MATH.md). attack_type/armor_type 1..5 (Melee, Pierce, Magic, Siege, Hero); player heroes attack as 5. skill_coeff=1.0 for a normal hit or skill%/100 for a skill. Ratings are raw Hero.data stats. Also returns crit chance and crit-damage that the ratings convert to.

Simulate a 1v1 auto-attack duel between two hero builds using the verified damage formulas (see docs/GAME_MATH.md). Returns the expected winner, each side's DPS, crit chance (with the opponent's Tenacity), and time-to-kill. reduce_a/reduce_b are optional damage-reduce ratings from each build. Skills, energy, heals, shields and crowd control are not yet modeled.

The effect-engine taxonomy recovered from the binary (docs/GAME_MATH.md sec 9). With no argument: counts by handler category across the 59 in-use BufferTypes. With a buffer_type: that type's mechanic + state bit. Status bits map to crowd control (type 39 = hard CC / halt; type 3 = immunity/cleanse).

Everything about one hero in a single call: base combat ratings, every evolution grade's exact formula params + 10*/L200 HP/ATK, main + totem skill, tier/role, and a recommended build. Ordinary stats are formula-verified; evolved grades come from live_hero_params (with a reconciliation flag when a multi-form hero mis-extracts its Ordinary grade).

Numeric per-level data for a skill (from Skill.data): damage % of ATK, targets, duration, effect %. 274 of 426 skills carry a real damage coefficient. Use skill_damage to turn a % into an actual number.

Exact skill damage for a given ATK, using the verified skill primitive (ceil(damage% * ATK / 100), from docs/GAME_MATH.md). Defaults to the skill's max level. Returns per-hit damage and the target count.

Grade a build by numbers without a fight: effective stats plus EHP (tankiness) and an offense score (ATK x attacks/sec x average crit factor), all from the verified combat math. loadout_json is the same shape hero_stats_calc takes. Use it to compare builds on one hero.

Cross-reference any name: resolve whether it is a hero, a skill, or a catalog item, and return what connects to it (a skill points to the heroes that use it, a hero points to its skill, an item points to its system).

Rank the talent and crest slots for a hero by the numbers (build_score), for objective 'offense', 'ehp' or 'balanced', and return the best full build (talent + crest scored together) plus the top options per slot. Pure stat ranking → cross-check recommend_build for the capability caveats.