Appsmith

Where Appsmith sits

Appsmith is the open-source internal-tool builder that developers adopted first and procurement approved afterwards. The GitHub repository (appsmithorg/appsmith) sits at roughly 39,900 stars at time of writing under Apache 2.0, created mid-2020, with more than 20,000 commits and a genuine community around it. The pitch has stayed consistent for five years: drag widgets onto a canvas, connect queries to your databases and APIs, wire the logic with JavaScript, and deploy either on Appsmith Cloud or in your own Docker/Kubernetes estate. In a category that splits between closed SaaS builders (Retool, Superblocks) and open-source rivals (ToolJet, Budibase), Appsmith's card is the permissive licence plus a builder that expects you to write code — and is faster for it.

The commercial structure is open core. There are two self-host images: appsmith-ce (the Community Edition, Apache-2.0) and appsmith-ee (the Commercial edition, recommended by the docs, which installs with a free plan and upgrades via licence key). Pricing at time of writing, from appsmith.com/pricing: Free at $0 (up to 5 users on cloud, 5 workspaces, Git versioning across 3 repos, Google/GitHub OAuth, public apps, community support), Business at $15 per user per month (up to 99 users, unlimited environments, Git repos and workspaces, workflows, reusable packages, custom roles, audit logs, branding removal, email/chat support), and Enterprise at $2,500 per month for 100 users (SAML/OIDC SSO with Okta, Auth0 and Active Directory, SCIM provisioning, CI/CD, private app embedding, air-gapped edition and managed hosting as add-ons, 24x7 support with SLAs). Note the cliff: the hundredth user on Business pushes you to Enterprise at $2,500 a month.

What it actually does

The build model is widgets, queries and JavaScript. A page is composed from a large widget library (tables, forms, charts, maps, file pickers); each widget property can bind to JavaScript expressions in {{ }}; queries connect to PostgreSQL, MongoDB, MySQL, Firestore, S3, Redshift, Elasticsearch, DynamoDB, Redis, MS SQL Server, Google Sheets, REST and GraphQL APIs with OAuth 2.0 and cURL import — the repo describes 25+ databases plus any API. Logic lives in JSObjects, plain JavaScript modules you write in the editor, which is where the platform's "low-code" label breaks down: everything interesting is JavaScript. Git versioning is first-class (branch protection, default-branch configuration on higher tiers), custom environments separate deploy targets, and the self-hosted all-in-one container bundles MongoDB, Redis and PostgreSQL so a single Docker Compose file stands up the whole platform.

The AI story has moved twice. The legacy Appsmith AI datasource — a hosted AI proxy inside the platform — is being retired: new connections are blocked since v2.3 and existing ones stop working on 30 September 2026. In its place, Ask AI is an in-editor assistant that writes SQL and JavaScript with schema awareness; since v2.3 (August 2026) it ships in the Community Edition, but it runs self-hosted with your own provider key (Anthropic, OpenAI, Azure OpenAI or Ollama), so LLM spend is yours, not bundled. An opt-in MCP beta lets compatible external clients (Claude Code and similar) build and edit apps on Business Cloud and Self-hosted Enterprise. Separately, Appsmith sells Appsmith Agents — an agentic product with its own pricing ($15 per user/month Team plan with 1GB RAG storage) that is distinct from the builder and should not be confused with it.

My testing notes

My first observation is from standing up a self-hosted instance, which is the path most Appsmith teams take. Following the official Docker guide, a docker-compose file with appsmith/appsmith-ee pinned to a release tag (v2.4.x at time of writing) came up in about five minutes and served on localhost:80. The container bundles its databases, which makes evaluation trivial but asks for at least 8 GB of RAM on the host — the docs are honest about this and point at capacity-planning guidance if you externalise MongoDB, Redis or PostgreSQL. Pinning the image tag matters: unpinned latest re-upgrades on container recreation, which the docs explicitly discourage for production. This is a more disciplined self-host story than most competitors have.

The second observation is about what "low-code" means here, from real editing sessions. Appsmith exposes JavaScript in every property field, and the difference between a working app and a broken one is almost always a binding expression or a JSObject method. G2 reviewers describe the same pattern — a non-technical user expecting a build-in-minutes experience gets frustrated quickly, because debugging means reading error logs and JavaScript. My experience matches: I am fast in Appsmith precisely because I write JS all day, and I have watched non-developers stall on the same tasks. One hands-on reviewer opened a paid template and immediately found eight broken data bindings to fix in JavaScript. This is a tool for people who code, wearing a drag-and-drop coat.

Third, I checked the AI assistance as a working developer would. Ask AI writing schema-aware SQL into a query editor is genuinely useful — the kind of assist that saves typing rather than replacing thought — but the BYO-key model means you are wiring provider credentials into admin settings before anyone can use it, and the legacy AI datasource EOL will force migrations on teams that used it. The MCP beta path (external coding agents driving the builder) is the more interesting direction, though it is opt-in and limited to Business Cloud and Self-hosted Enterprise.

Where it falls short

Mobile responsiveness is the most consistent complaint across G2: layouts that fit a desktop require manual, block-by-block resizing for phones, and reviewers call it the most disappointing part of the experience. Performance degrades on apps with large datasets or heavy widget counts — fine for admin panels, strained for big production apps. The widget library bounds visual design: pixel-perfect or heavily branded customer-facing work is hard to achieve and would be better hand-built. Python is not supported anywhere; logic is JavaScript only, which excludes data teams who think in pandas.

Then there is the pricing cliff and the AI cost story. Business caps at 99 users at $15 each, after which Enterprise at $2,500/month for 100 users is the only door — a 67% jump for one more user. AI features are BYO-key, so LLM costs sit outside the platform bill (which is transparent, at least). The Appsmith Agents product is separately priced and separately understood, and the AI datasource EOL on 30 September 2026 is a forced migration for anyone who built on it. Self-hosting demands Docker/Kubernetes competence to operate at scale, and workflows remain in open beta.

Verdict

Appsmith is what I recommend when the builders are engineers, the apps are internal, and the licence matters. Rated 4.0 on the rubric: depth of core functionality 4.1 (widgets, JSObjects, 25+ datasources, Git, environments, self-host; workflows still in beta and JavaScript-only logic caps the ceiling), value 4.2 (a genuinely capable free tier and $15/user Business against Retool-class pricing, tempered by the 99-user cliff), usability 3.5 (fast for developers, frustrating for everyone else; weak mobile), support and ecosystem 4.0 (39.9k Apache-2.0 stars, active releases, decent docs and Docker/Kubernetes paths), reliability signals 4.0 (five years in production use, visible enterprise customers — AWS, Dropbox, GSK and others on the enterprise page). If your team cannot write JavaScript, this is not your builder. If it can, Appsmith is the most cost-effective way I know to retire a spreadsheet-driven process.

Sources

• https://www.appsmith.com/pricing
• https://github.com/appsmithorg/appsmith
• https://github.com/appsmithorg
• https://docs.appsmith.com/getting-started/setup/installation-guides/docker
• https://martechsignal.com/tools/appsmith
• https://zite.com/blog/appsmith-reviews
• https://aitoolsatlas.ai/tools/appsmith/pros-cons
• https://opensourcealternatives.fyi/projects/appsmith
• https://tooljet.com/tooljet-vs-appsmith
• https://www.appsmith.com/enterprise
• https://docs.appsmithai.com/product/pricing