Production and Staging Resources in Query Library


I would love to have a toggle in the query library between staging and production, currently it looks like its only available for production resources. (or am I missing something?)

@JoeyKarczewski Your queries will depend on the resource you are using. Are you asking if you can have one set of queries for Retool Staging and another for Retool Production? If so, I am not aware of being able to do that, but you can stop a query from running or only execute a query based on environment in the Advanced tab:
{{retoolContext.environment == "production"}}
Screen Shot 2022-01-11 at 10.42.47 AM

Hi @ScottR

Thanks for the reply!

I'm talking about the query library, not an application. In the query library there isn't a way to toggle between production and staging resources

Yep, you can only toggle between authentication resources as it relates to environment as far as I can tell.

I think the goal here is to be able to develop in the query library and test against the Staging environment of a resource. Currently, you can only toggle between staging/production within an app.

I have a workflow where I am developing the backend / storage / APIs, and then exposing them to another team member who is building the actual Retool apps through creating the queries in the query library. Often times, the new APIs aren't yet deployed to the production environment yet, so I have to use a fake app of my own to test the newly developed queries, which requires sharing them before they're necessarily confirmed to be working.

It's a small team so it's not much of an issue, but it would certainly be nice to be able to toggle between production/staging within the query library feature.

1 Like

Hi Retool team!

Has there been any update on this?

This still would be super helpful :slight_smile:


No timeline yet, but it is something we want to ship! We'll post here when it's live

Hi there! :tada: We have a new feature for toggling environments in the query library. It is currently blocked by a bug that we need to fix, but it should be available soon


@Tess - Is there an update to be able to toggle environments in the query library ?

Hi @fragrant_issues I haven't been notified of any updates, but let me double check! Thanks for checking in

Hi @fragrant_issues I'm so sorry! While I didn't get the expected notification to remind me to update this post, this feature has shipped :tada:

It should be available on Cloud + on-premise 2.113+

Is 2.113+ still an unreleased version ? I can't seem to find it in

2.113.6 is released! It looks like the release notes haven't published quite yet.