# Discourse Data Explorer **URL:** https://meta.discourse.org/t/discourse-data-explorer/32566 **Category:** Plugin **Tags:** official, data-explorer, included-in-core **Created:** [August 26, 2015, 11:46pm UTC](https://meta.discourse.org/t/discourse-data-explorer/32566 "2015-08-26T23:46:06Z") **Posts on this page:** 1 **Showing post:** 288
### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking) #### Post date: [March 26, 2025, 11:25am UTC](https://meta.discourse.org/t/discourse-data-explorer/32566/288 "2025-03-26T11:25:44Z")
No, [Data Explorer](https://meta.discourse.org/t/32566?silent=true) only executes read only transactions. (If you updated your query to have a RETURNING clause, you would get a read only transaction error.) If you’re self hosting, use one of the “launcher enter” guides, like > [@Edit a user preference for everyone or a subset of users](https://meta.discourse.org/t/edit-a-user-preference-for-everyone-or-a-subset-of-users/25162): > > bookmark This guide explains how to edit a user preference for everyone or a subset of users in Discourse. person_raising_hand Required user level: System Administrator warning Console access is required. If you need to update the user preference for all of your users or a large subset of users, you can do so via the rails console. Summary In this guide, you’ll learn: How to access the Rails console for making bulk changes Examples of modifying user preferences How to identify se… If you already have your UPDATE designed, then you can `psql discourse` instead of `rails c`. If you’re on a hosted service, contact support to have them execute the change. --- _[View the full topic](https://meta.discourse.org/t/discourse-data-explorer/32566)._