I've made a tool to scrape LCSC product info for the parts in the assembly service to make a more usable tool for finding parts if anyone is interested:
https://github.com/cs2dsb/lcsc-scrape.rsThere's a pre-built database in the releases folder so you don't have to run the scraper (takes hours to do all 37k plus they might ban you? who knows).
I made it because I was fed up of libreoffice/google sheets taking minutes to update when attempting to apply a filter. The SQLite database can be queried in < 1 second for complex queries and contains basically all info available from both LCSC and JLC including all parameters listed on the LCSC product page, stock and basic/extended state from JLC and prices from both. It's at least as accurate as the spreadsheet from their SMT assembly page and has a lot of extra info for the majority of parts.
Every field is directly in the database as a string but I've also "post-processed" it to convert prices and voltages to floats so you can do numerical comparisons on them without mucking about with casting in SQL. These fields are prefixed with "pp_". I imagine I'll add more post processing as I use the DB but for my test case of finding a DC-DC with specified in & out voltages it worked great.
If you want to use it as a scraper to get up-to-date info please read the whole readme first - there are various ways to update subsets that doesn't result in you hammering LCSC & JLC with requests for hours. The workflow I'm using is update from the parts spreadsheet to get new parts (a handful of http requests), planning the design mostly to completion and finally updating only the set of products I've picked for my design with the latest JLC stock info. Obviously I'm manually checking the datasheets before the final order since the info on LCSC & JLC isn't always perfect or complete.
There's some example SQL at the bottom of the readme in the above repo including simple queries like finding categories, listing parameters available and filtering by criteria.
Open to feature requests/bug reports.
Let me know if you find it useful!