Complete Vehicle Database
Download
Get the world's most comprehensive automotive database in SQL, CSV, or Excel format. Includes Year-Make-Model-Trim, Specs, and VIN Patterns.
What's Inside the Database?
YMMT Hierarchy
Clean, normalized Year-Make-Model-Trim data structure. Perfect for dropdown menus and vehicle selectors.
Technical Specs
Detailed specifications including engine type, transmission, horsepower, torque, fuel economy, and dimensions.
VIN Patterns
Includes WMI (World Manufacturer Identifier) and VDS (Vehicle Descriptor Section) patterns for local decoding.
Developer-Friendly Schema
Our database schema is designed for performance and ease of use. Whether you use MySQL, PostgreSQL, or MongoDB, import is seamless.
- Normalized Tables (3NF)
- Foreign Key Constraints
- Indexed Columns for Speed
CREATE TABLE vehicles (
id INT PRIMARY KEY,
year INT,
make_id INT,
model_id INT,
trim_name VARCHAR(255),
body_type VARCHAR(50),
drive_type VARCHAR(50),
engine_type VARCHAR(100),
fuel_type VARCHAR(50),
FOREIGN KEY (make_id) REFERENCES makes(id)
);Choose Your Database Package
Pro Specs
- Everything in Basic
- Full Technical Specs
- Trim Levels & Options
- SQL & JSON Formats
- Monthly Updates
Enterprise
- Everything in Pro
- VIN Patterns (WMI/VDS)
- Image Mappings
- Weekly Updates
- Priority Support
Related Topics
dataset csv download