Building Internal Tools with Appsmith

Appsmith is an open-source low-code platform that streamlines custom application development, deployment, and maintenance. Organizations use it to build dashboards, admin panels, customer 360 views, IT automation tools, and service management applications so that their teams can work more efficiently.

Appsmith ships a drag-and-drop visual editor with more than 45 customizable widgets — tables, charts, forms, maps, and more — and connects those widgets to virtually any data source: over 25 native database integrations, REST APIs, and GraphQL endpoints. Because the platform is open-source, teams can self-host it on their own infrastructure and keep full control of their data.

Installing Appsmith with Docker Compose

Docker is the recommended installation path. Before starting, ensure you have Docker version 20.10.7 or later and Docker Compose version 1.29.2 or later. The host machine should have at least 8 GB of RAM, because the default all-in-one container runs MongoDB, Redis, and PostgreSQL alongside the application server.

Create a folder for the deployment and navigate into it:

Next, create a docker-compose.yml file with the following content:

This configuration maps ports 80 and 443 and mounts a local stacks directory so that application data and configuration survive container restarts. To start the service, run:

Once the container is healthy, open http://localhost in your browser to complete the on-screen setup wizard and create the first administrator account.

Connecting Datasources

After the server is running, the next step is connecting it to your data. Appsmith supports a wide range of native integrations:

• Relational databases: PostgreSQL, MySQL, Microsoft SQL Server, MariaDB, Oracle, CockroachDB
• Document and search stores: MongoDB, Elasticsearch, Firebase/Firestore
• Cache and queue: Redis, Amazon DynamoDB
• SaaS tools: Google Sheets, Salesforce, HubSpot, Stripe, S3, Slack
• Generic APIs: any REST or GraphQL endpoint

To add a datasource, open your application in the editor, click + New datasource in the left panel, select the database type, and fill in the connection credentials. Appsmith stores those credentials encrypted and never exposes them to the browser.

Writing Queries and Binding Data to Widgets

With a datasource connected, you can write queries directly in the editor. For a PostgreSQL datasource, a query might look like:

Once the query is saved, you bind its result to a Table widget by setting the Table Data property to {{getUsersQuery.data}}. The double-brace syntax is how Appsmith evaluates JavaScript expressions anywhere in the canvas — you can filter, transform, or format data inline:

This makes it straightforward to build live-search admin panels without writing a separate API layer.

Agentic AI Capabilities

Appsmith has expanded beyond classic CRUD tooling with Appsmith Agents, a platform that integrates large language models with private and proprietary business data. Agents let knowledge workers in sales, support, customer success, and HR ask questions and configure automations specific to their business without requiring model fine-tuning or complex RAG implementations. The feature connects to AI providers including Anthropic, Google, and OpenAI and gives those models continuous context from the same datasources already wired into your Appsmith applications.

Deployment Options

Beyond the Docker path shown above, Appsmith provides installation guides for:

For teams that want to get started immediately without managing infrastructure, Appsmith Cloud offers the same editor and widgets as the self-hosted version.

Contributing

Appsmith welcomes community contributions. The project publishes a Contribution Guide and maintains a set of issues labelled Good First Issue for newcomers. All contributors are expected to follow the project Code of Conduct. Community discussion happens on the Discord server and the Community Portal.