Converting Strapi Cloud backups for local use

Last updated: March 3, 2025

When using a Strapi Cloud backup on your local machine or migrating away from Strapi Cloud, you'll need to convert media assets to work with @strapi/provider-upload-local.

Required SQL commands

These commands will only work with PostgreSQL as this is the database used by Strapi Cloud

Replace your-app with your Strapi Cloud Debug name in these commands:

  1. Convert URL column values:

update files set url = 
  replace (url, 'https://your-app.media.strapiapp.com', '/uploads') 
  where url is not null;

  1. Convert formats column values:

update files set formats = 
  replace (formats::TEXT, 'https://your-app.media.strapiapp.com', '/uploads')::jsonb 
  where formats is not null;

  1. Convert provider column values:

update files set provider = 
  replace (provider, 'strapi-provider-upload-strapi-cloud', 'local') 
  where provider is not null;

Support scope

Our support team can help with:

  • Providing database exports

  • Providing database and media asset exports

  • Sharing the SQL commands for conversion

Support limitations:

  • Cannot assist with PostgreSQL server restoration

  • Cannot help convert to different database types

  • Cannot troubleshoot export-related issues

  • Cannot assist with different provider conversions