Appsmith Quick Start: Deploy with Docker and Build Your First Internal Tool

Quick Start: Deploy Appsmith with Docker and Build Your First App

Appsmith is the fastest way to build internal tools on your own infrastructure. This tutorial walks you through deploying Appsmith with Docker from scratch and building a simple customer management dashboard — all in under 15 minutes. No frontend experience required.

Prerequisites

Docker installed on your server (Linux, macOS, or Windows WSL2)
A PostgreSQL database (local or remote) — or use Appsmith's built-in mock data to start
A browser — the entire workflow happens in the browser

Step 1: Deploy with Docker

Run a single command to start Appsmith:

docker run -d --name appsmith \
  -p 8080:8080 \
  -v appsmith-data:/data \
  appsmith/appsmith-ce:release

Wait about 30 seconds for Appsmith to initialize. Then open http://localhost:8080 in your browser.

Step 2: Create Your Admin Account

On the first visit, Appsmith prompts you to create an admin account. Fill in your name, email, and password. This account has full administrative privileges — you can invite team members later from the Admin Settings panel.

Step 3: Connect a Data Source

Once logged in, click the Datasources tab on the left sidebar. Click Create New and choose your database. For this tutorial, select PostgreSQL:

Host: your-db-host.com
Port: 5432
Database name: postgres
Username: postgres
Password: your-password

Click Test to verify the connection, then Save. Appsmith also supports MySQL, MongoDB, Redis, Elasticsearch, Firestore, Supabase, REST APIs, and GraphQL — so you are never limited to a single data source.

Step 4: Build Your First Query

After connecting your database, create a new query by clicking the + icon next to your datasource name. Write a SQL query to fetch customer data:

SELECT id, name, email, status, created_at
FROM customers
ORDER BY created_at DESC
LIMIT 20;

Click Run — the results appear instantly below. Name this query getCustomers.

Step 5: Build Your Dashboard UI

Now switch to the Pages tab and create a new page. Drag widgets from the right panel onto the canvas:

Table: Drag a Table widget onto the canvas. In its properties panel, set Table Data to {{ getCustomers.data }}. The table automatically populates with your customer data.
Statbox: Add a Statbox widget showing the total customer count using {{ getCustomers.data.length }}.
Chart: Add a Chart widget grouped by status to visualise customer distribution.
Input: Add a text Input for searching by name, and wire it to a filtered query using WHERE name ILIKE '%{{ Input1.text }}%'.

Step 6: Deploy and Share

Click the Deploy button in the top-right corner. Your app is now live on your server. Share the URL with your team, or embed the app in an iframe. Use the Share button to invite specific users with role-based permissions (Viewer, Developer, or Admin).

Going Further

From here you can:

Add workflows: Create multi-step forms with approval flows and email notifications
Set up Git: Connect your app to a Git repository for version control
Custom branding: Add your company logo, colours, and custom CSS
API integrations: Connect to Stripe, Salesforce, Slack, or any REST/GraphQL API
Schedule jobs: Use Appsmith's scheduled queries to run recurring tasks

Conclusion

In under 15 minutes, you deployed Appsmith with Docker, connected a database, built a functional customer dashboard, and shared it with your team. Appsmith transforms how teams build internal tools — no more waiting weeks for a frontend developer to create a simple admin panel.