Battery
Location
Fault codes
Software
Who is listening?
Until now

Whoever could write SQL.

battery_shadowing_FINAL_v3.sql
SELECT vin, battery_state_of_charge
FROM (SELECT vin, battery_state_of_charge,
  ROW_NUMBER() OVER (PARTITION BY vin
                       ORDER BY ts DESC) rn
  FROM connectivity.wkdata_model_uview
  WHERE pyear * 100 + pmonth >= 202610
    AND vehicle_life_cycle_mode = 'TRANSPORT') t
WHERE rn = 1 AND battery_state_of_charge <= 20;
-- copied from Ahmet's mail, do not touch
?Which batteries are running flat in transport?
?Which vehicles were activated too early?
?Which fault code is suddenly spiking?
Requests waiting: 0
One specialist
BOTTLENECK
Condash
Connected vehicle reports, built for the people who need the answers.
SQL NO SQL
From the line to the customer

Follow a vehicle off the line.

Factory · 12V battery

Below 50%: recharge before shipping

Transport · km gained

+0km
Entry 08:12 Exit 14:40 Dwell 6 h 28 m Charge −4%

Normal · activation

0km
Activated under 250 km. Flagged.
Factory
Transport
Normal
Fault codes

Spot it this week.

P20EE
SCR NOx catalyst efficiency below threshold
Odometer bands
0–100 km
100–1,000
1,000–5,000
5,000–20,000
20,000+
▲ This weekEnd of the quarter
Connected services

Same treatment. Every service.

Software updates

Rebuilt from command messages
0%
Installed
Download / activation failed
Pending

Remote commands

Per type and day
Success 0
Failure 3.9%
Expired 1.9%
Lock · Unlock · Remote start
Failure reasons, per day

Telematics health

Per vehicle
Modem swaps ESN changed
Consent Granted
Deep sleep Precluded

Usage

Parking · trips · driving
Days parked → 12V at restart
Trips per program
Harsh braking
0/ 1,000 km
Illustrative · demo data
Vehicle lookup · Alerts

One VIN. The whole story.

State

Transport
12V 71% · 238 km
Yard: Autoport

Map

Mode changes

Factory → Transport
Transport → Normal

Trips

Warning lamps

⚠ Engine · 2×
Last seen 3 days ago

Raw messages

{"kafka_ts":"…:41:07",
"signal":"soc","v":71}
{"kafka_ts":"…:41:12",
"signal":"odo","v":238}
07:30
Condash daily checks
To: fleet quality team
Battery shadowing12V at or below 20% since yesterday
Watchlist codesYour fault codes, seen since yesterday
Codes on the rise2× the 4-week average this week
AI-ready

Every query is also a tool.

Model Context Protocol
✳
ClaudeMCP client
◆
Any AI assistantthat speaks MCP
0
read-only tools · one Bearer key
▦
Condash reportssame queries
⛁
Impalaread-only
Just ask.
Ask a question
→

◉ Guard model · Jev

One check before any model runs. Refusals cost ~$0.0001.
In scope? ✓
Asks for personal data? ✓
Prompt injection? ✓
Claude + MCP tools

Tool calls Claude

list_battery_risks(
 program="V710")
list_moved_in_transport(
 from="2026-10-01")
SELECT … FROM r1
JOIN r2 USING (vin)

In-memory join

r1
r2
The model sees columns and a few sample rows. Every number is computed from the full tables.

Answer ● Dashboard

0 vans under 50%
VINNM0LS7E27R1080412
Model seesV3f9a1c07e2per-question key
Cost per question
$0
< ½ cent
Saved dashboards
V710 · charge lost in transport
★ Save as dashboard
↻  Re-running tool calls on fresh data
Rebuild
0 s
Model calls
0
Ask once. Use it every day.
Governance

Built to be trusted.

Read-only

SELECT-only reader role. MCP closed without a key.

Partition pruning

Every telemetry query filters
pyear*100+pmonth

Fenced queries

Named columns only≤ 90-day windows≤ 5,000 rows

One SQL, two engines

Written once. Runs on the Postgres demo and production Impala.

Postgres demoImpala production
A configuration change. Not a rewrite.
Condash
Your fleet has been talking all along.
Now, everyone can listen.
Developed byConnected Products and Engineering Services Tribe
Paused · Space to resume
Condash
Click or press Space to start
Space play / pause   ← → previous / next slide   F fullscreen   C captions   L loop on   R restart