Standalone Databases

Standalone vPIC Databases are intended for use by developers and researchers who prefer to use a local database instead of calling the vPIC API. There are quotas and rate limits associated with the usage of the vPIC API, and you can avoid reaching the limits by using the standalone databases. Please be aware that standalone databases are limited to VIN Decoding functionality only. To retrieve other information (such as makes, models, variables, attributes, etc.), you will still need to use vPIC APIs.

MS SQL Server

SQL Server backup file is compatible with MS SQL Server 2019 and newer versions.

Download MS SQL Server backup file "vPICList_lite_2025_12.bak.zip" updated on 12/13/2025, file size: 172 MB

Once downloaded, you can restore it. Here’s an example using the command below:

RESTORE DATABASE [vPICList_Lite]
FROM  DISK = N'{path-to-downloaded-bak-file}' WITH  FILE = 1,
MOVE N'vPICList_Lite' TO N'{path-to-MSSQL\DATA-folder}\vPICList_Lite.mdf',
MOVE N'vPICList_Lite_log' TO N'{path-to-MSSQL\DATA-folder}\vPICList_Lite_log.ldf'

Once restored, you can decode a VIN by calling the 'spVinDecode' stored procedure like this:

EXEC dbo.spVinDecode 'ABC12345XYZ123456'

PostgreSQL

PostgreSQL backup files are compatible with PostgreSQL version 17 and newer. The PostgreSQL database is provided in two formats: custom and plain. The custom format is a compressed binary file containing the database. The plain format is a plain-text SQL file containing scripts to create the database. Both formats will restore the database into a separate schema named 'vpiclist_lite'.

Download PostgreSQL custom backup file "vPICList_lite_2025_12.custom.zip" updated on 12/13/2025, file size: 67 MB

Download PostgreSQL plain backup file "vPICList_lite_2025_12.plain.zip" updated on 12/13/2025, file size: 71 MB

All ownership and privilege information has been excluded. However, to ensure no errors are encountered during the restore process, it is recommended to restore the backup with the --no-owner and --no-privileges options, as shown in the examples below. Additionally, ensure that the account used for the restoration has login access to the target database.

Once downloaded, you can restore the database like this using the Windows command line while inside a PostgreSQL installation directory:
Custom:

pg_restore.exe --host {your_host} --port {your_port} --username {your_username} --dbname {your_db} 
    --no-password --no-owner --no-privileges --verbose {path-to-downloaded-custom-file}

psql.exe --host {your_host} --port {your_port} --username {your_username} --dbname {your_db} 
    --file {path-to-downloaded-plain-file}

Once restored, you can decode a VIN by calling the 'spVinDecode' function like this:

select * from vpic.spVinDecode('ABC12345XYZ123456')