Skip to main content
Case study · Custom software for All Island Testing
Mix Search

From a pile of lab PDFs to an app Claude can run.

All Island Testing has tested New York's concrete since 1979, and every mix design, trial batch and cylinder break lived in PDFs. We built Mix Search from scratch: AI reads the reports and files everything, the app flags bad data, tracks expirations and writes the reports and invoices, and it's wired into the lab's own Claude so the team can run it all in plain English.

mix-search · sample data
Mix Search home screen: a search box, totals and the trials expiring soon

Claude · mix-search connected

Which trials expire this month?

search_trial_batches

HRM-4000 expires Nov 19. KCC-3500-SOG already expired Oct 25.

  • 35

    tools Claude can use in the app

  • 2

    AI models working together

  • 150+

    changes shipped and tested

  • 4

    AI steps from PDF to filed records

Claude, connected

They ask. Claude does the work.

We built a Model Context Protocol (MCP) server into Mix Search, so the lab's own Claude can search, create, update and file anything the app can. No new screens to learn: the team describes what they need, and Claude calls the right tools and reports back.

  • Search and filter mixes, trials and breaks
  • File a new lab PDF from a chat
  • Recommend mixes for a project
  • Create and fix suppliers, materials and readings

Claude

Connected: mix-search (35 tools)

MCP
  1. Find a 5,000 psi pump mix with slag that hasn’t expired and recommend it for the Atlantic Yards job.

  2. search_mix_designs

    rated ≥ 5,000 psi · contains slag · trial valid

    → 1 match: HRM-5000-SL

  3. recommend_mix_for_project

    Atlantic Yards ← HRM-5000-SL

    → Recommended

  4. Done. HRM-5000-SL from Hudson Ready Mix is now recommended for Atlantic Yards. Its latest trial broke at 6,150 psi at 28 days, 23% over its rating. Heads up: that trial expires in 25 days.

AI ingestion

Drop in a PDF. Get a database.

A lab's trial-batch report goes in; suppliers, projects, mixes, ingredients and every cylinder break come out, filed and linked. One AI reads the report, a second checks the reading against the page, and anything it isn't sure of goes back for another pass.

R-118 · Trial batch report

Metro Testing Lab

SupplierKings County Concrete

ProjectHarbor Square

MixKCC-6000-HE · 6,000 psi · w/c 0.36

Ingredients6 materials, lb per cubic yard

Breaks7 d 4,910 · 28 d 7,430 · 7,480 · 7,450 psi

01Read

AI extracts the supplier, project, mixes, ingredients and every break from the PDF.

02Check

A second AI reviews the result against the report and sends doubtful readings back.

03Match

Fuzzy matching ties names to existing suppliers, materials and projects, so nothing is filed twice.

04File

Everything is saved and linked, with the original PDF kept beside its trial.

Filed: supplier, project and mix matched · 1 new trial · 4 breaks · PDF stored

Search, sort, filter

Any mix, in seconds.

Search by code, type, notes or lab report number, then narrow by strength rating, water-cement ratio, the ingredients a mix contains and how much, supplier or expiration. Sort any column and page through every recipe on file.

  • Ingredient and quantity filters
  • Expiring today, this week, this month
  • Merge duplicate mixes in one click
  • Every change in an audit log
mix-search · sample data
The mix designs list: codes, ratings, latest trial status, special tests, ingredients and suppliers
mix-search · sample data
One mix design: its details, ingredients and trial batches with the latest break

Tracking

Nothing expires by surprise.

Every trial is good for a year. The home screen leads with what's expiring and what already has, grouped by supplier, and every mix shows its latest 28-day break against the strength it's rated for.

HRM-5000-SL

28-day break vs. rating

Rated 5,000 psiBroke at 6,150 psi · +23%

Data checks

Bad numbers get caught.

Mix Search re-does the math on every record: averages that don't match their cylinders, strength that drops with age, truncated or copied breaks, impossible dates. Each issue links to the mix and trial so it's fixed before it lands in a submittal.

mix-search · sample data
Data issues: a 28-day average that doesn't match its cylinders, and strength that drops with age

Reports and invoices

The paperwork writes itself.

Pick the trials and criteria and Mix Search produces a lab report on the letterhead, linked back to the recommendation it supports. Invoices come out the same way: line items, card fees and payment terms, with a live preview and a saved PDF.

Invoice

C261109

November 9, 2026

Bill to

Harbor Square Builders

2Trial batch review5000 psi pump mix$700.00
1Compressive strength testing4 cylinders, 7 and 28 day$240.00
1Report preparation and filingHarbor Square$175.00
Total due$1,115.00

Payment due on receipt

Sample invoice

Under the hood

A full-stack build, end to end.

  • React web app

    A fast, keyboard-friendly interface in light and dark, tested end to end in real browsers on desktop and phone before every release.

  • Python API and Postgres

    A typed API over a relational database, with migrations, structured errors and safe deletes that explain what still depends on a record.

  • Two AI integrations

    One model reads and double-checks lab PDFs; Claude drives the whole app through a secured MCP endpoint.

  • Locked down

    Invite-only sign-in, roles, API keys and an audit log of every change, with the AI endpoint behind its own token.

  • Files and history

    Original PDFs stored with their trials, a logo library for invoices, and the full history of every mix.

  • Shipped continuously

    Every change runs the test suites and deploys automatically, so new features reach the lab the day they're done.

Drowning in PDFs and spreadsheets?

We build the app, wire in the AI and connect it to the tools you already use, Claude included.