SQL utils (Postgres / MySQL MariaDB)

postgres.sql

select 'SELECT SETVAL(' || seq [ 1] || ', COALESCE(MAX('||column_name||')+1, 1) ) FROM '||table_name||';'
from (
       SELECT table_name, column_name, column_default, regexp_match(column_default, '''.*''') as seq
       from information_schema.columns
       where column_default ilike 'nextval%'
     ) as sequense_query

strapi.sql

-- Reset sequence

DO $$
DECLARE 
i TEXT;
BEGIN
    FOR i IN (SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname = 'public') LOOP
    EXECUTE 'Select setval('''||i||'_id_seq'', (SELECT max(id) as a FROM "'||i||'")+1);';
    END LOOP;
END$$;