Queries and code concept guides
Learn about relevant features, functionality, and principles related to queries and code.
You're viewing documentation for classic apps, which use Retool's original app editor. The new app builder is the recommended way to build apps and where Retool focuses new development.
Explanations of Retool concepts that provide greater understanding about how they work. These guides are not instructional by design and focus on providing context related features and functionality.
Ask AI
Learn about Retool's built-in AI assistance.
Best practices
Learn about the best practices for writing performant queries.
Query caching
Learn more about caching query results to increase app performance.
JavaScript
Write JavaScript in Retool.
Performance
Learn about query performance at different stages.
Prepared statements
Learn how Retool uses prepared statements for SQL queries.
Query Library
Learn more about creating and sharing queries with the Query Library.
Row-level security
Learn about row-level security of database tables.