20-page worksheet · PDF + scoring matrix
Retool, Internal, or build it yourself? Pick on a worksheet, not on Hacker News.
A 20-page worksheet for ops teams evaluating Retool, Internal.io, Airplane, Tooljet, Appsmith, or building from scratch on Next.js plus Postgres. With a 10-factor scoring matrix, a 5-year TCO comparison, and an honest framework that does not pick a winner for you.
Internal tools is the category most companies handle worst
Customer-facing software gets the build-vs-buy treatment. Internal tools rarely do. The first admin panel gets thrown together in a weekend on whichever platform an engineer used at their last job, and then every subsequent admin panel gets thrown together on the same platform because the standard has already been picked by accident. Six months later, the platform bill is climbing faster than the team expected, the per-seat costs hit at exactly the worst moment (when ops is expanding), and there is no defensible documentation of why this platform was picked in the first place. Switching costs are now substantial.
This worksheet exists because the build-vs-buy framework that works for customer-facing CRM does not directly translate to the internal-tools category. The per-seat economics are different (you pay for every ops headcount, not every customer), the integration patterns are different (mostly read from your own data warehouse rather than write to external systems), and the audit needs are different (a different surface area for SOC 2 and customer-data exposure). The 10-factor matrix in this worksheet is tuned for those category-specific differences.
Inside the 20-page worksheet
- Section 1 — The four-question filter. How much engineering capacity do you have? How sensitive is the data the tool reads? How many seats do you need at launch and at 18 months? Are you on a platform standard already?
- Section 2 — Platform landscape. The major internal-tools platforms (Retool, Internal.io, Airplane, Tooljet, Appsmith, Budibase) with the actual differences that matter — pricing model, hosting options, audit logging maturity, and the SDK surface for non-trivial customizations.
- Section 3 — Build-from-scratch baseline. A reference Next.js plus tRPC plus Postgres plus Auth.js stack that costs about 6 to 10 weeks of engineering for a first version. Includes when this baseline is faster than picking a platform.
- Section 4 — The 10-factor scoring matrix. Score across seat count, per-seat cost, integration depth, audit needs, customization frequency, data sensitivity, engineering capacity, vendor lock-in, time-to-first-tool, and post-launch maintenance.
- Section 5 — 5-year TCO comparison. Side-by-side template comparing platform TCO (with per-seat inflation modeled at 10-15% YoY) versus build-from-scratch TCO (with maintenance modeled at 15-20% of build cost annually).
- Section 6 — Security and access control. RBAC maturity across platforms, SSO and SAML support, IP allowlisting, audit log retention, and the gap between platform defaults and what your SOC 2 auditor will actually ask for.
- Section 7 — Audit and compliance. Data residency patterns, PII handling, the customer-data exposure surface for each platform option, and the audit-trail patterns that survive a real auditor review.
- Section 8 — Migration risk. What it costs and what breaks to migrate from one platform to another, or from a platform to a build-from-scratch system. Includes a worked example of a Retool-to-custom migration.
- Section 9 — Hybrid patterns. Most defensible internal-tools setups are a platform for the simple stuff and a build-from-scratch system for the complex stuff. Three reference hybrid architectures with the splitting criteria.
- Section 10 — Decision template. The one-page output of the worksheet that you can paste into a leadership Slack channel or a finance review. Includes the three objections you will get and how to answer them.
Who this is for
The worksheet is targeted at four roles. First, heads of operations at 10-to-500- employee companies whose ops team is about to spin up its first or third internal tool. Second, engineering managers at the same scale who are tired of being the bottleneck for every ops request and need to evaluate whether to give the ops team a no-code platform or build a thin custom system that handles 80% of requests. Third, IT directors evaluating internal-tools platforms as part of a SOC 2 readiness review or a customer security questionnaire response. Fourth, founders making the first call on which platform their company standardizes on for back-office work.
The worksheet is industry-agnostic but most useful in verticals where ops complexity is high — including fintech, healthcare, insurance, and legal services where the audit and data-sensitivity factors weigh heavily on the platform choice.
What you will learn
You will leave with a scored evaluation of the major internal-tools platforms against your specific situation, a 5-year TCO comparison you can present in a finance review, and a one-page decision template suitable for a leadership Slack channel. You will also have the vocabulary to push back on common platform-side sales patterns — including the one where the per-seat price quoted on the marketing page is materially below the actual price after enterprise features are bundled in.
On the build-from-scratch side, you will have a realistic engineering scope (6-to-10 weeks for a first internal tool on a Next.js plus tRPC plus Postgres baseline) and a list of the production-readiness items that distinguish a real tool from a weekend prototype — including RBAC, audit logging, SSO, IP allowlisting, and the disaster-recovery posture you need before the tool touches customer-related data. Many of those items overlap with the broader MVP-to-production checklist.
On the migration side, you will understand what it actually costs to move from a platform like Retool to a custom system 18 months in — which is the single most common failure mode for the "just pick the platform" default. The worked example in Section 8 covers a real migration timeline and the data and integration gotchas to plan for.
How this connects to our work
A significant share of our custom business software engagements begin as Retool migrations. The pattern is consistent: a small ops team built the first admin panel on Retool, hit a customization or per-seat-cost wall around month 18, and is now evaluating whether to keep paying or build the replacement. The worksheet is what we send before the first scoping call so the conversation can start at the right altitude. It also helps validate web application builds where the back-office surface is half the scope.
For the broader build-vs-buy framework that addresses customer-facing software, see the build-vs-buy playbook and the build-vs-buy calculator. For pricing on the discovery sprint that typically precedes a migration build, see our pricing page or just book a call. Recent migrations are listed on our work page.
Frequently asked questions
How is this different from the general build-vs-buy playbook?
The general playbook is anchored on customer-facing software. The internal-tools worksheet is anchored on the back-of-house category where the per-seat economics, integration patterns, and audit needs are different.
Which platforms does it cover?
Retool, Internal.io, Airplane, Tooljet, Appsmith, Budibase, plus the build-from-scratch alternative on a typical Next.js plus tRPC plus Postgres stack.
Does it cover the security and audit angle?
Yes. Sections 6 and 7 cover audit logging, RBAC, IP allowlisting, and data residency patterns and the gap between platform defaults and what SOC 2 readiness reviews actually require.
What's the right team size for this worksheet?
Most useful for ops teams at companies with 10 to 500 employees considering their first or second internal-tools build.
What happens after I download?
You get the PDF immediately and one short follow-up email. If you want a working session on your specific internal-tools scope, book a 20-minute scoping call.
Related resources & reading
Build vs Buy Playbook
The customer-facing software counterpart to the internal-tools worksheet.
MVP to Production Playbook
Production-readiness items for the build-from-scratch path.
Custom Business Software
Our service for when the worksheet output points toward a custom build.
Build vs Buy Calculator
The interactive version of the Section 5 TCO worksheet.
Stuck between a platform and a build? Get a second set of eyes.
If the worksheet output is ambiguous, a 20-minute scoping call is the cheapest way to find out whether your situation is actually a hybrid or whether one side of the scoring matrix is being weighted incorrectly for your team. Read our pricing or just book a call.