Appsmith — Open Source Low-Code Internal Tool Builder

What it is

Appsmith is an open-source platform for building internal tools, admin panels, and dashboards. It provides drag-and-drop UI components, connects to any database or REST/GraphQL API, and lets you write custom JavaScript for business logic. Everything runs in a visual builder accessible from a web browser.

Appsmith is suited for engineering teams, ops teams, and technical product managers who need to build internal tooling without dedicating frontend engineering resources.

How it saves time or tokens

Building an internal admin panel from scratch involves setting up a frontend framework, designing components, wiring API calls, and handling authentication. Appsmith provides all of this out of the box. A CRUD admin panel that would take a week to build in React can be assembled in Appsmith in hours using pre-built table, form, and chart widgets connected directly to your database.

How to use

1. Deploy Appsmith with Docker:

curl -L https://bit.ly/docker-compose-CE -o docker-compose.yml
docker compose up -d

1. Access the builder at http://localhost:80 and create an admin account.

1. Connect a datasource (PostgreSQL, MySQL, MongoDB, REST API, GraphQL, etc.), drag widgets onto the canvas, and bind them to queries.

Example

A simple admin panel that lists users from a PostgreSQL database:

-- Appsmith query: GetUsers
SELECT id, name, email, created_at
FROM users
WHERE status = 'active'
ORDER BY created_at DESC
LIMIT {{ Table1.pageSize }}
OFFSET {{ Table1.pageOffset }}

Bind this query to a Table widget. Appsmith automatically handles pagination, sorting, and search. Add a Form widget for creating new users, connected to an INSERT query. The entire admin panel is built without writing frontend code.

Related on TokRepo

• No-code tools — Browse low-code and no-code development platforms
• Database tools — Explore database management and admin tools

Common pitfalls

• Trying to build customer-facing apps in Appsmith. It is designed for internal tools and admin panels. The UI framework is functional but not optimized for end-user polish.
• Not setting up Git version control for Appsmith apps. Without Git integration, you lose change tracking and the ability to roll back. Enable Git sync early in your project.
• Overusing JavaScript in widgets instead of using Appsmith's built-in bindings. The mustache syntax {{ query.data }} handles most cases without needing custom JS transformations.
• Starting with an overly complex configuration instead of defaults. Begin with the minimal setup, verify it works, then customize incrementally. This approach catches configuration errors early and keeps troubleshooting straightforward.