Get SQL Scripts of Strapi Application

Questions and Answers Database-SQL
1
System Information
  • Strapi Version: 3.3.4
  • Operating System: Linux
  • Database: PostgreSQL
  • Node Version: 12
  • NPM Version: 6

Hi folks,

I’m wondering if there is a way to get the changes that Strapi makes on DB schema (table create, column create etc.) as an SQL script when I made changes on admin dashboard?

For example, if I create a new single type which has 3 properties, I want to get an SQL script for creating the tables that Strapi does, like “CREATE TABLE …”. I want SQL scripts of db changes like. a log.

Is it somehow possible?

Thanks.

2

You can turn on MySQL log and see what’s query MySQL is processed