jlcpcb-component-finder-update-db - SKILL.md Agent Skill

name: jlcpcb-component-finder-update-db description: "Download or update the JLCPCB electronic components database for the jlcpcb-component-finder skill. Use when: (1) User says 'update jlcpcb db', 'download jlcpcb database', 'refresh parts database', (2) The jlcpcb-component-finder skill reports database not found, (3) User wants to get the latest component data from JLCPCB/LCSC, (4) User says 'update db', 'update parts db'. Downloads 0.6 GB split-zip (5 GB installed) from yaqwsx.github.io/jlcparts." allowed-tools: - Bash

DO NOT auto-invoke this skill. This downloads ~0.6 GB and writes a ~5 GB database. Always ask for user confirmation before proceeding.

JLCPCB Database Updater

Download or update the JLCPCB parts database (~5 GB installed, ~7 million components). Upstream now ships the slim source-db-v2 format (table jlc_components); the old v1 format bundled a ~20 GB raw-payload table — this script drops it if it ever reappears.

Prerequisites

curl - for downloading files
7z (p7zip) - for extracting split-zip archives. Install: brew install p7zip
sqlite3 - for the defensive slim-down step. Install: brew install sqlite

Update Script

Run the automated update script:

bash $HOME/.claude/skills/jlcpcb-component-finder-update-db/scripts/update-db.sh

This script will:

Check prerequisites (curl, 7z, sqlite3)
Discover and download split-zip files from https://yaqwsx.github.io/jlcparts/data/
Extract cache.sqlite3 using 7z
Back up existing database (if any) to cache.sqlite3.bak
Install new database to $HOME/.jlcpcb-db/cache.sqlite3
Drop the legacy jlcpcb_component_details payload table if present (no-op on v2) + VACUUM
Remove the previous cache.sqlite3.bak so backups don't pile up
Clean up temporary files

Important Notes

Download size: ~0.6 GB compressed (12×50 MB split parts + a final ~13 MB zip)
Installed size: ~5 GB (source-db-v2); the old v1 format was ~26 GB due to a raw-payload table
Download time: usually a minute or two on a decent connection
Disk space needed: during the transition you briefly hold the old DB + new DB; the script

removes the .bak automatically after install
If the download fails partway, re-run the script - it cleans up partial downloads

Data Source

Database from JLC Parts by Jan Mrazek. Updated periodically from JLCPCB/LCSC component data.

Verify After Update

node $HOME/.claude/skills/jlcpcb-component-finder/query.js db-info

Manual Update (Alternative)

If the script doesn't work, download manually:

Visit https://yaqwsx.github.io/jlcparts/
Download all cache.z* and cache.zip files
Extract: 7z x cache.zip
Move: mv cache.sqlite3 $HOME/.jlcpcb-db/