What is SWDB?
A Developer's Database Reference
Ever needed to quickly check how a Shopware entity is structured — without spinning up a local instance and diving into the database? SWDB gives you instant access to every table, column, index, and foreign key relationship across 200+ Shopware versions.
Whether you're building plugins, planning a migration, or just trying to understand how things connect — it's all here.
Certificates
Our Certifications
SWDB is built on years of hands-on Shopware experience. These certifications reflect a deep understanding of the platform — from core development and templating to PaaS architecture.
Database Schemas
Browse 200+ Shopware Versions
From Shopware 5.5 to the latest 6.7 release — select any version below and explore its complete database schema.
Shopware version
Shopware Version
Shopware 5
Shopware 6
| Column | Type | Additional |
|---|---|---|
| id | binary(16) | Primary key |
| version_id | binary(16) | Primary key |
| auto_increment | int | Unique |
| product_number | varchar(64) | Index |
| active | tinyint unsigned | |
| parent_id | binary(16) | Index |