Retool

Retool is the low-code platform for building internal tools that connects to any database or API and provides drag-and-drop components to build admin panels, dashboards, and CRUD apps used by 27,000+ organizations. In this Retool review, we examine how the platform eliminates weeks of internal tool development for engineering teams.

Overview

Retool (retool.com) was founded in 2017 by David Hsu and raised $445M in funding at a $3.2B valuation. The platform serves 27,000+ organizations including Amazon, DoorDash, NBC Universal, Brex, and Plaid. Retool generates an estimated $100M+ in annual revenue.

The platform provides a visual builder for internal tools that connects to databases (PostgreSQL, MySQL, MongoDB, Snowflake), APIs (REST, GraphQL, gRPC), and SaaS services (Stripe, Twilio, Salesforce). Components include tables, forms, charts, maps, file uploaders, and 100+ pre-built UI elements. Custom JavaScript and SQL can be embedded anywhere for complex logic.

Retool has expanded beyond the web builder to include Retool Mobile (mobile app builder), Retool Workflows (backend automation), and Retool Database (built-in PostgreSQL database for quick prototyping).

Key Features and Architecture

Visual App Builder

A drag-and-drop interface with 100+ pre-built components: tables with sorting/filtering/pagination, forms with validation, charts, maps, file uploaders, rich text editors, JSON viewers, and more. Components are connected to data sources through queries, and interactions (button clicks, row selections) trigger actions.

Database and API Connectors

Native connectors for PostgreSQL, MySQL, MongoDB, Snowflake, BigQuery, Redshift, Elasticsearch, DynamoDB, Firebase, Google Sheets, REST APIs, GraphQL, gRPC, and 50+ more. Queries are written in the native language (SQL for databases, HTTP for APIs) with variable binding from UI components.

JavaScript Customization

Any component property, query transformer, or event handler can include custom JavaScript. This escape hatch means Retool isn't limited to what the visual builder supports — complex business logic, data transformations, and conditional flows are all possible.

Retool Workflows

A visual workflow builder for backend automation — scheduled jobs, webhook handlers, and multi-step processes. Workflows connect to the same data sources as apps and can trigger actions like sending emails, updating databases, or calling APIs on a schedule or in response to events.

Retool Mobile

Build mobile apps for field teams, warehouse workers, and on-the-go operations using the same drag-and-drop approach. Mobile apps connect to the same data sources and share components with web apps.

Granular Permissions

Role-based access control at the app, page, component, and query level. Admins can restrict which users see which data, which buttons they can click, and which queries they can execute — critical for internal tools that access sensitive data.

Ideal Use Cases

Customer Support Tools

Support teams need to look up customer data, modify accounts, issue refunds, and manage subscriptions. Retool connects to the production database and payment APIs to build a support console in hours instead of the weeks it would take to build from scratch.

Operations Dashboards

Operations teams monitoring order fulfillment, inventory levels, delivery status, and system health use Retool to build real-time dashboards that pull from multiple databases and APIs into a single view.

Admin Panels and CRUD Apps

Every SaaS product needs admin tools for managing users, configurations, feature flags, and content. Retool's table + form + SQL pattern builds these admin panels faster than any framework.

Data Management and Approval Workflows

Teams that need to review, approve, or modify data (content moderation, data quality review, manual data entry) use Retool to build workflow apps with approval steps, audit logs, and role-based permissions.

Pricing and Licensing

Retool offers a free tier and per-user pricing:

For comparison: Appsmith (open-source alternative) is free to self-host, Budibase starts at $5/user/month, Internal.io starts at $10/user/month, and building internal tools from scratch typically costs $50K–$200K in engineering time per tool. Retool's pricing is justified when you consider the engineering time saved.

Pros and Cons

Pros

• Dramatically faster development — build internal tools in hours instead of weeks; connect to databases, drag components, write SQL, done
• 100+ pre-built components — tables, forms, charts, maps, and more; covers 90% of internal tool UI needs out of the box
• Any data source — connects to 50+ databases, APIs, and SaaS services natively; no custom integration code needed
• JavaScript escape hatch — custom JS anywhere means you're never blocked by the visual builder's limitations
• Free tier — 5 users with unlimited apps; genuinely useful for small teams
• 27,000+ customers — proven at scale; extensive documentation and community

Cons

• Not for customer-facing apps — internal tool aesthetic; not suitable for products where design and branding matter
• Per-user pricing adds up — $50/user/month (Business) for a 50-person team is $30K/year; significant for large organizations
• Vendor lock-in — apps built in Retool can't be exported as standalone code; you're dependent on the platform
• Performance with large datasets — complex apps with many queries and large tables can feel sluggish; requires optimization
• Learning curve for complex apps — simple CRUD apps are fast; complex multi-step workflows with conditional logic require significant Retool expertise

Getting Started

Getting started with Retool is straightforward. Visit the official website to create a free account or download the application. The onboarding process typically takes under 5 minutes, and most users can be productive within their first session. For teams evaluating Retool against alternatives, we recommend a 2-week trial period to assess whether the feature set and user experience align with your specific workflow requirements. Documentation and community resources are available to help with initial setup and configuration.

Alternatives and How It Compares

Appsmith

Appsmith (open-source, free self-hosted) is the leading open-source alternative to Retool. Appsmith provides similar drag-and-drop building with database connectors and JavaScript customization. Appsmith is more cost-effective; Retool is more polished with more components and better documentation.

Budibase

Budibase ($5/user/month) is an open-source low-code platform for internal tools with a built-in database. Budibase is simpler and cheaper; Retool is more powerful for complex applications with multiple data sources.

Airplane (acquired by Airtable)

Airplane focused on developer-first internal tools with code-based workflows. It was acquired by Airtable in 2023. Airplane was more developer-friendly; Retool is more visual and accessible to non-developers.

Custom Development (React/Next.js)

Building internal tools from scratch with React provides maximum flexibility and no vendor lock-in. However, it takes 10-50x longer than Retool for equivalent functionality. Custom development for customer-facing products; Retool for internal tools where speed matters.