5 min read

John Miniadis

A pre-build checklist for internal tools that have to last

A pre-build checklist for internal tools that have to last

What to settle before building an internal tool: workflow, data, owners, access, audit, and a definition of done.

Blog article header for "PostgreSQL INT4RANGE: Enforce non-overlapping zones in SQL" by Omar Tarek, Stackdrop Engineering
Blog article header for "PostgreSQL INT4RANGE: Enforce non-overlapping zones in SQL" by Omar Tarek, Stackdrop Engineering

Before building an internal tool that has to last, settle six things: map the workflow it supports, agree where the data lives, name an owner, decide the access model, decide what gets audited, and define what done looks like. Tools that skip this stall or turn fragile. Tools that work through it survive change.

The decisions are cheap to make before a build and expensive to retrofit after one. What follows is the order we work through them in scoping, and what each one prevents.

What should you map before building an internal tool?

Map three things before building: the workflow the tool supports, the data it reads and writes, and the handoffs between the people who touch it. A workflow map shows how work moves in practice, where it stalls, and who is involved at each step, which is rarely how the process reads in a document. 

The gap shows up fast once you look. At a maritime communications SaaS, customer-success runbooks had grown complex enough that some steps ran automatically and others needed manual work through Postman or the Swagger interface, each carried out against live environments. Writing the workflow down surfaced which steps carried real risk and which could collapse into a single governed action inside a tool. None of that is visible from the feature request; it appears only when you trace the real path.

Data deserves the same treatment. At a specialist manufacturing supplier, pre-order activity sat in HubSpot, orders and stock lived in the ERP, and the rest moved through email, so staff re-keyed plain-text orders by hand and adjusted prices as they went. Agreeing the source of truth for each piece of data, before a build, is what stops a new tool from becoming one more place the same number is entered. For a closer look at this step, see mapping a workflow before you build.

 

What do you need to decide about access and audit up front?

Decide who can see and change each part of the tool, and what the tool records, before the first query runs. Access and audit shape the data model and the build; they are slow and risky to add once a tool is live and people depend on it. This is what it means to embed governance from the start instead of bolting it on.

Access is two questions held apart: who can view a given screen or record, and who can change it. Separating viewers from editors, and keeping a development environment apart from production, means changes get tested without putting live operations at risk. Audit is the other half. At a private capital fund, a five-year regulatory retention requirement meant the tool had to produce evidence of who did what and when, so audit logging was part of the data model from the first session, not a later request. Deciding what gets recorded early is far cheaper than reconstructing a history the system never kept.

 

Who should own the tool, and why does it matter?

Name one owner before building, because a tool without an owner stops being maintained and drifts back into the workaround it replaced. The owner is the person accountable for changes, access reviews, and the backlog of what to fix or add next. Without that role, small problems accumulate until the tool is quietly abandoned.

Ownership is also a continuity question. At a manufacturing firm running parts of its operation on a Microsoft Access database, one person held all the knowledge and was a year or two from retirement, with no clear successor. A tool that depends on a single undocumented person is one resignation away from being unmaintainable. Ownership done well looks like the Wayve engagement, where an operations tooling manager acts as product manager for the Retool work, owns the roadmap, and runs delivery on a sprint cadence. That is the difference between a tool someone runs and a tool that runs until it breaks. Owning it also means owning the standard, which is part of what makes an internal tool that holds up in production different from one that only works in a demo.

 

What does "done" mean for an internal tool?

Done means the tool runs the whole workflow in production, the named owner can maintain it, access and audit work as agreed, and it passes IT and compliance review without rework. A tool that demos well but cannot clear review is not done; it is a prototype waiting for the gap to surface. Defining done before building is what keeps scope from drifting through the build.

A concrete bar helps. At a higher education assessment body, done included accessibility compliance, an audit trail, and a clean handoff to SAP for payments, so the test was whether the application passed review on those terms, not whether it looked finished. Writing that definition down at the start gives everyone the same target and gives the owner a clear point to accept the work. If you want help setting that bar for a specific build, talk to us about scoping.

FAQ

How detailed should a pre-build plan be?

Detailed enough to name the workflow, the source of truth for the data, the owner, the access model, and the definition of done. It does not need to specify every screen. A week of discovery is usually enough to settle these and leave room to refine the rest during the build.

What happens if you skip the workflow map?

The build encodes assumptions about how work happens instead of how it moves in practice, so the tool stalls in review or needs rework once the team starts using it. The steps that get missed are usually the manual exceptions and handoffs that never made it into the original request, which are often the reason the tool was needed in the first place.

 Does this apply to low-code tools too?

Yes, and more so. Retool and similar platforms make building fast, which makes it easy to start before the six decisions are settled. Speed hides the gaps until the tool reaches production, so the planning matters more on a low-code build, not less.

Get monthly insights on building better internal tools, faster.