One open source project for admin panels, CRUD apps, & internal tools

TL;DR: Appsmith is an open source framework to build apps for analytics, workflows or CRUD operations. Replace all your internal tools with one project. See GitHub repo or try an example app here.

Weve all spent time on building internal tools which are simple CRUD apps, admin panels, or complex workflows. In my experience these kind of internal tools are used for:

1. Analytics and reporting
2. Customer data views for sales & support teams
3. Configuration managers for client-visible UI used by technical and non-technical people
4. Multi-step data workflows which involve multiple participants(like content moderation tools or customer KYC at fin-tech startups)

These tools often arent very interesting to build because of the repetitive work involved like building UI, writing CRUD APIs, setting up authentication, & managing deployments. I decided to create Appsmith because I couldnt find a project which did most of the work for me and also easily customizable.

How does Appsmith work?

1. First setup Appsmith using Docker. Read instructions here for a 2 min setup process.(https://docs.appsmith.com/quick-start#docker). Or try our online sandbox

2. Go to https://localhost or your machines public IP to see the login page. online sandbox.

3. Create a new application and name it.
   

4. Connect to a database or API. Today MySQL, Mongo, Postgres, and REST apis are supported. The gif below shows me connecting to an API.
   

5. Go to the canvas section and choose a UI widget. Appsmith ships with 16 components like tables, different charts, map viewer, forms, etc. In the example below Ive used a table component.
   

6. Modify the table property to display your query results by writing {{queryname.data}}. You can code in JS and use Lodash functions inside {{ }}.
   

7. Trigger an action through events like onClick, onTextchange, onSelectedrow, etc for CRUD operations.
   
   script)

8. Click deploy to see your app in a URL. (You can set up a custom domain in the setup script)
   

9. Invite users after assigning them a role. They can sign up via a form login or with their Google/Github accounts. Make your app publicly viewable to allow access without a login.
   

So this is how you build a simple app in less than 10mins. Access an app I built on Appsmith here.

Appsmith is my first open source low code project for internal tools. If you like the project, please star our GitHub project.

What features should we add to Appsmith?