Changelog

Self-hosted Retool now includes default statement timeouts that apply when running upgrade migrations. If your organization has a self-hosted Retool deployment that uses PgBouncer with its main PostgreSQL database, you must update the PgBouncer configuration to ignore statement timeouts.

ignore_startup_parameters = statement_timeout

The new Linting and Performance tools, available within Debug Tools in the App IDE, provide additional methods for debugging and optimizing apps.

Linting​

Identify queries, code, and components that may affect app performance.

Performance​

View statistics related to app performance along with an overall performance score. This is a useful tool for measuring how changes affect an app's performance and provides guidance on how to optimize it further.

You can now use configuration variables within workflows. Both values and secrets are supported and can be referenced using:

{{ retoolContext.configVars.YOUR_VAR_NAME }}

Retool Forms is the fastest way to build a form on top of your database, your data warehouse, or wherever else you want your data. Retool Forms are:

• Native to your data source: Generating a form on top of any SQL datastore (Postgres, MySQL, Snowflake, etc.) in one click.
• Your form, your database: Use your own or we’ll give you a Postgres DB—with a connection string if you want to take it elsewhere.
• Code-first: You can write JavaScript almost anywhere, including libraries like moment and lodash, for custom validations, conditional logic, and data parsing.
• The start of other processes: Build apps and workflows on top of your data to join data sources, send updates through Slack or email, and take action on your results.
• Secure: Forms are public but the data, apps, and workflows you build are permissioned securely with granular access controls. You can also self-host it in your own VPC.

Retool Forms is free and has no arbitrary limits on users, forms, or submissions.

You can now use AI to generate fully functional workflows instead of assembling blocks or writing logic. You provide some instructions and Retool assembles the required blocks with any necessary logic. You can also select a database resource and provide context about table schema.

The option to password-protect public apps will no longer be available from February 18, 2024. To create a radically better experience in building authenticated Retool apps for external users, we’ve recently introduced Retool Portals, Retool Embed and Retool Forms.

Any existing public apps with password protection will remain protected. Should we decide to make any further changes to password protection, Retool will provide at least six months notice.

You can now use FIDO2-compliant hardware security keys, such as the YubiKey 5, with two-factor authentication.

The new Button column type in the Table component is now available. When enabled, column values render as a button. This allows you to add buttons to trigger actions, queries, and open links using a button.

The Phone Number Input component for web apps is now available. It automatically formats phone numbers, includes a country selector with international dialing code, and can perform validation based on the selected country. The default country is derived from the user's IP address.

Configuring Resources in Retool can require handling sensitive values, e.g., database passwords or API keys. Starting in Self-hosted Retool 3.20 and later, you can store and retrieve secrets from Google Cloud Platform (GCP) Secrets Manager.