@pipeworx/ca-dmv

Connect: https://gateway.pipeworx.io/ca-dmv/mcp · Install: one-click buttons

Tools: 6

California DMV data: registered vehicles and EV adoption by ZIP code, all 187 field offices with the services each performs, the official forms catalog, insurer NAIC codes, and licensed-driver counts by county. Keyless.

Why this is one state per pack

Part of the dmv category — one pack per state motor-vehicle agency. The states do not share a grain: California publishes a ZIP × make × model-year × fuel snapshot, New York a record-level file, Washington monthly transaction counts, Maryland county-months, Pennsylvania county-quarters. A single cross-state tool meant a schema where most arguments were ignored for most states and a “total” that was never comparable, so each agency gets its own tools with its own real arguments. For every DMV tool in one connection, use /mcp?vertical=dmv.

Tools

Auth

None. Every endpoint is public California state infrastructure. The CKAN-backed tools accept an optional CKAN API key, which the public datasets do not require.

Gotchas worth knowing

Live-verified behaviours, not guesses:

• Snapshots are one CKAN resource per year, 2019–2026, and the rows carry the prior December 31 as their as-of date — the “2026” file describes the fleet on 2025-12-31.
• Grouping by ZIP surfaces a literal OOS bucket — out-of-state registrants, ~638k vehicles — which outranks every real ZIP. Ignore it when ranking ZIPs; the tool flags it in note.
• OTHER/UNK is a real make value that absorbs small-count suppression and can outrank genuine makes in a by-make ranking.
• total_vehicles appears only when it is honest. Grouping by fuel returns every category, so its sum is the true fleet total; any other grouping can be cut off by limit, and those responses carry sum_of_returned_rows plus truncated instead.
• Fuel labels are specific strings (Battery Electric, Plug-in Hybrid, Hybrid Gasoline, Diesel and Diesel Hybrid, Hydrogen Fuel Cell). Plain words like “electric”, “phev” or “hydrogen” are mapped for you.
• Form search uses the DMV site’s own relevance ranking, so a broad phrase like “title transfer” can put a vessel-title form above the vehicle one.
• California publishes no wait-time feed. Only North Carolina (nc-dmv) and Oregon (or-dmv) do; ca_dmv_offices returns posted hours instead.
• Lien lookup and appointment booking are unavailable: the lien endpoint requires a reCAPTCHA token and appointments run on a session-based kiosk system.

Data sources

• Vehicle Fuel Type Count by Zip Code — data.ca.gov CKAN, datastore_search_sql
• Driver Licenses Outstanding by County — data.ca.gov CKAN
• Field office directory — dmv.ca.gov WP REST, hours and per-office service tags
• Forms catalog — dmv.ca.gov WP REST
• Insurance carrier NAIC lookup — https://www.dmv.ca.gov/portal/wp-json/dmv/v1/naic-lookup?s=<name>

Tools

• ca_dmv_vehicle_registrations — Count vehicles registered in California from official DMV data, broken down by ZIP code, make, model year, fuel type or light/heavy duty. Each row is a count of registered vehicles from the California
• ca_dmv_ev_adoption — Measure electric-vehicle adoption in California from DMV registration counts: how many battery-electric and plug-in hybrid vehicles are registered in a ZIP code or statewide, and what share of all reg
• ca_dmv_offices — Find California DMV field offices with street address, per-day opening hours, coordinates and the services each office actually performs (behind-the-wheel retest, duplicate title, ID cards, self-servi
• ca_dmv_forms — Search the official California DMV forms catalog by topic and get each form’s name, its REG/DL/BOAT form number, and the page to download it from. Answers “which California DMV form transfers a title”
• ca_dmv_insurance_lookup — Look up an auto insurer’s five-digit NAIC code from the California DMV insurance-carrier list by company name. California requires the NAIC number when reporting insurance for a registered vehicle, so
• ca_dmv_driver_licenses — Count valid California driver licenses and identification cards held by residents of each county, as an annual series from 2008 onward. Answers “how many licensed drivers are in Los Angeles County”, ”