Lets update this topic for PrestaShop 1.7.7.5 with list of default modules (preinstalled).
The query bellow will disable all non default PrestaShop modules.
This might be useful if your PrestaShop is crashed and you need to disable all non core modules but you have no access to your admin dashboard.
UPDATE ps_module SET active = 0 WHERE name NOT IN ('contactform', 'dashactivity', 'dashgoals', 'dashproducts', 'dashtrends', 'graphnvd3', 'gridhtml', 'gsitemap', 'pagesnotfound', 'productcomments', 'ps_banner', 'ps_categorytree', 'ps_checkpayment', 'ps_contactinfo', 'ps_crossselling', 'ps_currencyselector', 'ps_customeraccountlinks', 'ps_customersignin', 'ps_customtext', 'ps_dataprivacy', 'ps_emailsubscription', 'ps_faviconnotificationbo', 'ps_featuredproducts', 'ps_imageslider', 'ps_languageselector', 'ps_linklist', 'ps_mainmenu', 'ps_searchbar', 'ps_sharebuttons', 'ps_shoppingcart', 'ps_socialfollow', 'ps_themecusto', 'ps_wirepayment', 'sekeywords', 'statsbestcategories', 'statsbestcustomers', 'statsbestproducts', 'statsbestsuppliers', 'statsbestvouchers', 'statscarrier', 'statscatalog', 'statscheckup', 'statsdata', 'statsequipment', 'statsforecast', 'statslive', 'statsnewsletter', 'statsorigin', 'statspersonalinfos', 'statsproduct', 'statsregistrations', 'statssales', 'statssearch', 'statsstock', 'statsvisits', 'welcome', 'gamification', 'emarketing', 'psaddonsconnect', 'psgdpr', 'ps_mbo', 'ps_buybuttonlite', 'ps_metrics', 'ps_accounts', 'ps_eventbus', 'blockreassurance', 'ps_facetedsearch');
src: https://devwl.pl/disable-all-modules-in-prestashop-using-sql/