LibItemDB — Offline Item Database for WoW

LibItemDB is a lightweight library that lets any addon look up World of Warcraft items offline — resolve an item's name to its link or id (and back), and filter by type and subtype — without the item being in the game's cache.

WoW ships no searchable item table and no “find item by name” API. LibItemDB solves that by shipping a pre-built database captured from a full client item scan, so players never wait for a scan and addon authors get instant, reliable lookups.

This is a developer library. Install it if another addon lists it as a dependency, or depend on it if you are an addon author.

What it can do

• Resolve a name to a full, clickable item link — even for items you've never seen
• Resolve a name to an item id, or an id to name / quality / type / subtype / equip slot / item level
• Read an item's stats (strength, stamina, spell power, resistances, …)
• Read the buff a consumable grants on use — food, elixirs, flasks, potions, scrolls — as the same stats (e.g. +12 Stamina, +25 Agility), searchable right alongside gear
• Search by name, item type, subtype, quality, item-level range, and stat — e.g. plate that has strength
• Reconstruct random-suffix variants ("of the Bear", "of the Eagle", …) from a compact id pair, letting the game render the full, correctly-scaled tooltip
• Enumerate types/subtypes and iterate the entire database

For addon authors

local DB = LibStub("LibItemDB-1.0", true)
if DB and DB:IsReady() then
    local link  = DB:GetLink(19019)       -- coloured, interactive Thunderfury link
    local stats = DB:GetStats(13468)      -- { ITEM_MOD_..._SHORT = n, ... }
    local buff  = DB:GetEffects(18045)    -- Tender Wolf Steak use-effect: { ITEM_MOD_STAMINA_SHORT=12, ITEM_MOD_SPIRIT_SHORT=12 }
    for _, r in ipairs(DB:Search({ classID = 4, stat = "STRENGTH" })) do print(r.link) end

    -- random suffix (field 8 of a modern link): rebuild and let the game render it
    local s = DB:BuildItemString(15218, 1196)   -- "item:15218::::::1196"
    GameTooltip:SetHyperlink(s)                 -- full Crystal Sword of the Bear tooltip
end

Key methods: IsReady, Count, GetName, GetInfo, GetQuality, GetItemLevel, GetStats, GetEffects, HasEffects, GetLink, GetID, GetClasses, GetSubClasses, Search, Iterate, GetRandomProperty, BuildItemString, GetSuffixLink, ResolveSuffix, ResolveName.

Data coverage

Stats and item levels are language-independent and ship once; names ship per language (untranslated items fall back to English, so every language is complete). LibItemDB is available for every version except Retail.

• Vanilla (Era / Hardcore / SoD) — 24,127 items
• The Burning Crusade (Anniversary realms) — 30,032 items
• Mists of Pandaria (Classic) — 88,259 items

Every version is in all 12 client languages. Wrath and Cataclysm are added when those game versions are live again. (Retail is not supported.)

Requirements

• Ace3 and VersionCheck-1.0 — auto-installed by CurseForge (they back the optional guild version-check)

Recent Updates

v0.3.0 (2026-06-01) — Consumable use-effect stats

• Food, elixirs, flasks, potions, scrolls and the like now carry the buff they grant on use (e.g. +12 Stamina / +12 Spirit, +25 Agility, +30 Strength) — read via the new GetEffects, and merged into GetStats / Search so you can find a consumable by the stat it gives, right alongside gear.
• Built from the client's own spell data, so the values are exact and language-independent. Vanilla and TBC are fully covered; Mists combat-rating buffs (crit / haste / mastery rating) follow in a later update.

v0.2.0 (2026-05-30) — The Burning Crusade & Mists of Pandaria data

• Added full data for The Burning Crusade (30,032 items) and Mists of Pandaria (88,259 items), each in all 12 languages with random-suffix support — alongside the existing Vanilla data.
• Wrath and Cataclysm will be added when those game versions are live again.

v0.1.0 (2026-05-30) — Stats, random suffixes, all 12 languages

• Items now carry their item level and full stats (strength, stamina, spell power, resistances, …), with stat-filtered search.
• Random-suffix support — "of the Bear" and friends — reconstructed from a compact id so the game renders the full, correctly-scaled tooltip.
• Now ships in all 12 client languages for Classic (Era), with English fallback for anything untranslated.
• Data is split into a load-once language-independent core plus small per-language name tables, so the bulky data isn't duplicated 12 times.

v0.0.1 (2026-05-30) — Initial release

• First release of LibItemDB — offline item lookups (name ↔ id ↔ link, type / subtype filtering) exposed as a LibStub library for addon authors.
• WoW Classic (Era) English data — 24,000+ items.
• Available for every version except Retail.

Support

Questions, bug reports, or coverage requests — reach out on Discord.