# Can I run Update queries with the data-explorer?

**URL:** https://meta.discourse.org/t/can-i-run-update-queries-with-the-data-explorer/249460
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [August 7, 2022, 3:56pm UTC](https://meta.discourse.org/t/can-i-run-update-queries-with-the-data-explorer/249460 "2022-08-07T15:56:26Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![nobodyfrm](https://avatars.discourse-cdn.com/v4/letter/n/e0b2c6/32.png) [@nobodyfrm](https://meta.discourse.org/u/nobodyfrm)
#### Post date: [August 7, 2022, 3:56pm UTC](https://meta.discourse.org/t/can-i-run-update-queries-with-the-data-explorer/249460/1 "2022-08-07T15:56:26Z")

</div>

Hey, is it possible to run an update statement with this plugin?

if not is there any other simple way to run an update statement?

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [August 7, 2022, 4:11pm UTC](https://meta.discourse.org/t/can-i-run-update-queries-with-the-data-explorer/249460/2 "2022-08-07T16:11:36Z")

</div>

The data-explorer is read-only, I’m afraid. If you have server access you could use the rails console, though making changes directly can be risky depending on experience/skill level so it’s recommended to make a backup beforehand.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [January 18, 2023, 10:18am UTC](https://meta.discourse.org/t/can-i-run-update-queries-with-the-data-explorer/249460/3 "2023-01-18T10:18:50Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.