Data scattered across systems
TMS, WMS, telematics, fuel cards and spreadsheets never quite line up, so every report starts with a manual stitch.
Industries / Logistics
Agentic BI for LogisticsYour fleet data has a goal.It finds why deliveries run late.
The agentic BI platform for logistics teams. Your AI analyst investigates late deliveries, fuel burn and lane margins across your TMS, WMS and telematics data. Every number cited, never guessed.
No credit card · 14-day team trial
Logistics analysisdeliveries.csv
LiveQuestion
Why is on-time delivery dropping this month?
On-time delivery by hub%
Root cause
Denver loses 3.8 hrs per route to dock detention at two shippers — and 61% of its late drops start there.
60s
to connect your database and start asking
100%
of numbers cited to a query that ran
24/7
monitoring on the lanes and KPIs you put on watch
The logistics data problem
Everything is tracked. Almost nothing is explained.
Dispatch, telematics, fuel cards and carrier invoices each tell part of the story. Spotting that a number moved is easy. Knowing why takes an analyst a week — by which time the shipments are long gone.
Late deliveries, unclear causes
On-time rate is down two points. Is it the carrier, the dock, the driver, the weather or the lane? Nobody can say quickly.
Fuel and idle cost leaks
Cost per km creeps up, idle time hides inside route averages and exceptions surface only at month-end.
Lane profitability is a guess
Revenue per lane is easy. Fully loaded margin after fuel, detention, claims and empty miles is not.
Carrier invoices that don’t reconcile
Accessorials, re-bills and rate mismatches get paid because nobody has time to check every line.
Dashboards that go stale
Static exports are out of date the moment they’re emailed, and two reports rarely agree on the same KPI.
How it works
From connected to monitoring in two days
No SQL, no ticket to the data team. SchemaChat does the heavy lifting.
See it in action
Ask the questions ops and finance actually ask
Four real-world questions, answered the way SchemaChat answers them: the number, the why, and a chart of what it found.
Ask
Why did on-time delivery fall to 91% last week?
- Compared on-time rate by hub, lane and carrier week over week
- Isolated Denver → Salt Lake and Denver → Omaha
- Broke late stops down by dock dwell, driver hours and weather
SchemaChat
On-time delivery fell from 95.2% to 91.0%. Three-quarters of the drop sits in two lanes out of the Denver hub.
Root cause
Dwell time at two shippers rose from 1.1 to 4.9 hours, which pushes 61% of late drops past their window.
Ask
Which vehicles are driving up our cost per km?
- Ranked vehicles by cost-per-km change against their own 90-day baseline
- Joined fuel-card transactions to telematics idle events
- Grouped the outliers by depot, model and route type
SchemaChat
Fleet cost per km is $1.42, up 6.1% in 8 weeks. 14 of 212 vehicles account for 38% of the increase.
Root cause
The outliers are all older diesel units on short urban drops, idling an average of 2.6 hrs per shift.
Ask
Which lanes lose money after empty miles?
- Allocated fuel, driver and detention cost to every load
- Added empty return legs to the outbound lane they belong to
- Ranked lanes by contribution margin per load
SchemaChat
9 of 64 active lanes run at negative contribution margin once deadhead and detention are included.
Root cause
Seven of the nine are one-way backhaul gaps: the lane is priced as if the truck returns loaded.
Ask
Are any carrier invoices out of line with contracted rates?
- Matched invoice lines to the rate card by lane and service level
- Flagged accessorials with no matching pickup or delivery event
- Grouped variances by carrier and charge code
SchemaChat
212 invoice lines across 6 carriers exceed contract rate, totalling $48,300 above agreed terms this quarter.
Root cause
Fuel-surcharge tables are out of date for two carriers, and 41 detention charges have no supporting scan.
What teams use it for
One analyst for every logistics question
From the dispatch desk to the CFO, the same governed numbers answer every team.
OTIF · Dwell time · Late-stop reasons
On-time delivery & SLA analytics
See where, when and why deliveries miss their window, and which customers, carriers or docks cause it.
Cost / km · Idle % · MPG / L per 100 km
Fleet & fuel analytics
Cost per km, idle waste and consumption trends across every vehicle, driver and depot.
Margin · Deadhead · Revenue
Route & lane profitability
Fully loaded margin per lane, including empty miles, detention and claims, so pricing follows reality.
Dock turn · Pick rate · Dwell
Warehouse & throughput
Spot dock congestion, pick-rate dips and dwell build-ups before they delay outbound trucks.
Carrier score · Invoice variance · Claims
Carrier performance & freight audit
Score carriers on service and cost, and catch invoice lines that don’t match contract.
Volume / lane · Utilisation · Seasonality
Demand & capacity planning
Understand volume patterns by lane and season so capacity is booked before it gets expensive.
Automated dashboards
Operations dashboards that build themselves
- Ask “build me a fleet performance dashboard”. It picks the KPIs and charts.
- Live, not snapshots. Every widget re-queries on each view.
- Click any hub on the map to cross-filter the whole board.
Try it: click a hub on the map.
Build me a fleet performance dashboard
On-time delivery93.4%−1.8pt
Cost per km$1.42+6.1%
Fleet utilisation81.2%+2.4pt
Idle time9.8%+0.6pt
Hubs & lanesColour = on-time rate
Cost per km by depot
On-time delivery, last 12 weeksNow 93.4% · was 95.1%
Integrations
Works with the data you already collect
SchemaChat reads the database your logistics systems already feed. There’s no new tracking to install and no data to re-enter.
- TMS & dispatch records
- WMS & dock scans
- Telematics & GPS
- Fuel-card data
- Carrier invoices
- Customer orders
- Maintenance logs
- Spreadsheets & CSV
Your database read-only
SchemaChat reads from
- PostgreSQL
- MySQL
- BigQuery
- Snowflake
- MongoDB
- CSV files
schemachatAI data analyst
- Root-cause analysisInvestigating late deliveries
- Live dashboardsFleet performance · re-querying
- Alerts & monitoringOn-time delivery < 92% · watching
- Cited answersEvery number traced to its source
Read-only, credentials encrypted.See all integrations →
FAQ
Questions logistics teams ask
Which logistics systems does SchemaChat work with?
SchemaChat connects to the database your systems write into: PostgreSQL, MySQL, BigQuery, Snowflake or MongoDB. If your TMS, WMS or telematics data lands in one of those, or in a CSV export, you can start asking questions straight away.
Do I need a data team or SQL knowledge?
No. You ask in plain English. SchemaChat writes and runs the queries, and shows the exact SQL behind every answer, so your data team can check it any time.
Can it join data from different systems, like telematics and fuel cards?
Yes, if the tables are in the same connected database, SchemaChat can join them. For example it can link fuel-card transactions to telematics idle events by vehicle and date, and define the join once as a governed metric.
How do I know the numbers are right?
Every figure comes from a query that actually ran, with the step behind it cited. If the data isn’t there to answer a question, SchemaChat says so rather than guessing.
Is my operational and customer data safe?
All AI queries are SELECT-only, enforced at the SQL parser layer, so SchemaChat cannot modify or delete your data. Database credentials are encrypted at rest with AES-256-GCM.
Can it alert us when a lane or KPI goes off track?
Yes. Put any finding on watch, for example on-time delivery on a lane or cost per km for a depot, and you’ll be alerted when it crosses a threshold, along with a digest of what changed.
Can we pull answers into our own tools?
Yes. The REST API lets you ask questions, run read-only queries and pull charts from your own backends, Slack bots and automations using a Bearer token.
How much does it cost to try?
The 14-day team trial lets you connect your own database (read-only) or upload CSVs, run deep analyses and build dashboards, with no credit card and up to 3 seats. After the trial, Premium and custom plans for larger teams are on the pricing page.
Put an AI analyst on your logistics data today
Connect a database or upload a CSV of recent shipments and ask your first question in about a minute.
- 14-day team trial, no credit card
- No credit card
- Cancel anytime