MageSmith

Magento 2 Database Documentation

Browsable Magento 2 schema with foreign-key graphs and instant search.

Magento 2 Database Documentation screenshot

What Magento 2 Database Documentation does

  • 363 core tables grouped into 14 functional domains — Catalog & Products, Sales & Orders, Customer, CMS, Inventory, etc.
  • Filter tables by name, column, or domain from anywhere in the app
  • Per-table detail: every column with type, null, default, primary-key and foreign-key markers
  • Indexes section — index type, column list, uniqueness
  • Foreign-key graph — click a table to see its 1-hop neighbourhood visualised, then click a neighbour to jump
  • Right-hand drawer for quick peeks without losing your place in the list
  • Schema pinned to a known Magento version — the banner tells you exactly which version you're looking at

How it works

1

Search or browse

Type a table name in the filter, or click a domain card to see that group's tables.

2

Inspect a table

See columns, indexes, and the foreign-key graph showing direct relationships.

3

Trace relationships

Click any related table in the graph to jump there. Build a mental model of the data flow in minutes instead of hours.

Frequently asked about Magento 2 Database Documentation

Which Magento version is the schema from? +

Pinned to the latest stable 2.4.x. Updated when Adobe ships patch releases that change the schema.

Does it show my custom tables? +

Not today — this is the core Magento schema only. Uploading your own db_schema.xml to visualise is a Pro-tier feature on the roadmap.

Is this useful for Magento 1? +

No. Magento 1's data model is fundamentally different (heavy EAV) and not covered here.

Can I export the schema as SQL? +

The raw db_schema.xml files from Magento core are easier to grab than reconstructing SQL. Check Magento's GitHub repository.

Why group by domain? +

The full 363-table list is too much to scan. Grouping mirrors Magento's own module boundaries and cuts navigation time dramatically.

Can I use this offline? +

It's a hosted tool. DevDocs' offline schema reference is the closest offline alternative.

Related tools

Every Magento dev tool, in one hosted workspace.

Free to sign up. Nothing to install. Drafts, audits, and projects saved across every tool.