SWDB (Shopware Database Inspector) is a free reference tool that documents the complete database schema of every official Shopware 5 and 6 release. It lets you browse tables, columns, data types, indexes, and foreign key relationships — without needing access to an actual Shopware database.
Anyone working with Shopware at a technical level: developers building custom plugins, agencies planning migrations, freelancers debugging data issues, newcomers trying to understand the platform, or plugin manufacturers designing their data models. If you've ever needed to know how a Shopware table is structured, SWDB is for you.
It depends on the version. Shopware 6.1.0 started with around 175 tables. The latest release, Shopware 6.7.7.1, has 236 tables. The number has grown steadily as Shopware added features like Flow Builder, custom entities, and the app system.
Shopware 5 versions typically have around 250–260 tables. The schema was relatively stable across the 5.x lifecycle, with minor additions between versions.
Shopware 6 was a complete rewrite — the database schema changed fundamentally. Shopware 5 uses prefixed table names (e.g. s_articles, s_order) with a more traditional relational design. Shopware 6 uses unprefixed names (e.g. product, order) and introduces versioning columns, translation tables, and a DAL-driven architecture with binary UUIDs as primary keys instead of auto-increment integers.
SWDB currently covers 203 versions — spanning Shopware 5.5 through 5.7 and Shopware 6.1 through 6.7. New versions are added as they are officially released.
Each Shopware version is installed in an isolated Docker environment. The database schema — including tables, columns, data types, indexes, and foreign key constraints — is then extracted automatically and stored as structured JSON. This process runs against every official release to ensure the data reflects the actual database state.
Absolutely. SWDB lets you compare table structures across versions, making it easy to spot added or removed columns, changed data types, and new foreign key relationships. It's a great starting point for understanding what changed between your current and target Shopware version.
No. SWDB is an independent community project and not affiliated with, endorsed by, or connected to Shopware AG in any way. Shopware is a registered trademark of Shopware AG. The schema data is extracted from publicly available Shopware releases.
Yes, completely free. No registration, no paywall, no ads. Just open a version and start exploring.