The Problem
Shopware is one of Europe's leading e-commerce systems. With each new version, database structures change — new tables are added, existing ones are extended, others are removed. For developers planning migrations or building plugins, it has been difficult to systematically track these changes.
The Solution
The Shopware Database Table Inspector (SWDB) makes exactly this possible: It documents the complete database structure for every Shopware version — from Shopware 5.5.7 to the current 6.7.x — and presents it in a clear web interface.
Technical Implementation
- Schema Extraction: For each Shopware version, a Docker container is started, the database is analyzed, and the schema is exported as JSON.
- Static Generation: Over 46,000 pages are statically generated with Astro — one page per table per version.
- Schema Comparison: A client-side diff engine enables direct comparison of two versions, showing added, removed, and modified tables, columns, and indexes.
Numbers & Facts
The project currently covers over 200 Shopware versions with more than 46,000 statically generated pages. The build process takes about 6 minutes and requires 8 GB of heap memory.
A tool that saves me a lot of time in my daily work with Shopware migrations.
Technology Stack
- Astro (Static Site Generation)
- Node.js (Schema Crawling)
- Docker (Version Environments)
- Vanilla JavaScript (Client-Side Diff)
- GA4 Analytics with Cookie Consent