h3_units

Creatures, heroes, and artifacts from Heroes III including Restoration of Erathia, Armageddon's Blade, Horn of the Abyss (Cove, Factory), and the upcoming Bulwark faction. Each table includes icons rendered inline.

Data source: heroes.thelazy.net wiki

Queries

Heroes by town
Heroes with starting spells
Heroes grouped by class
Artifacts by slot
Artifacts by rarity
Combined (combo) artifacts
Relic-class artifacts
All secondary skills
All towns
Towns by alignment
1-v-1 win rates by creature
1-v-1 upset victories
Longest full-army battles
Army battle survivor totals

Tables

artifacts

icon, name, slot, rarity, gold, effect, combo, expansion

156 rows

battles_1v1

seed, left_name, left_count, right_name, right_count, winner, rounds, winner_survivors

72 rows

battles_army

seed, left_army, right_army, rounds

72 rows

heroes

icon, name, class, town, specialty, skill_1, skill_2, spell

200 rows

resources

icon, name, category

7 rows

skills

icon, name, basic, advanced, expert

30 rows

towns

icon, town, expansion, alignment, native_terrain, special_resource, mage_guild_level, might_class, magic_class, description

12 rows

units

portrait, name, town, level, attack, defense, min_dmg, max_dmg, hp, speed, growth, ai_value, gold, resource, special, icon

190 rows

Heroes of Might & Magic III

Custom SQL query