aicost crawler health

:: All vendors (full nightly run)
node scripts\aicost-pricing-crawler.js > D:\aicost\logs\pricing-now.log 2>&1

:: Single vendor
node scripts\aicost-pricing-crawler.js --vendor=anthropic

:: Dry run (preview, no DB writes)
node scripts\aicost-pricing-crawler.js --vendor=openai --dry-run

:: All vendors (full weekly run)
node scripts\aicost-product-crawler.js > D:\aicost\logs\product-now.log 2>&1

:: Single vendor
node scripts\aicost-product-crawler.js --vendor=cursor

:: Dry run
node scripts\aicost-product-crawler.js --vendor=github --dry-run

:: All vendors (full weekly run)
node lib\aicost-hybrid-crawler.js > D:\aicost\logs\hybrid-now.log 2>&1

:: Single vendor
node lib\aicost-hybrid-crawler.js --vendor=anthropic

:: Dry run / Tier-A only / extract phase only
node lib\aicost-hybrid-crawler.js --vendor=openai --dry-run
node lib\aicost-hybrid-crawler.js --tier=A
node lib\aicost-hybrid-crawler.js --phase=extract

:: All 10 topics (full weekly run)
node scripts\aicost-benchmark-crawler.js > D:\aicost\logs\benchmark-now.log 2>&1

:: Single topic
node scripts\aicost-benchmark-crawler.js --vendor=anthropic-caching
node scripts\aicost-benchmark-crawler.js --vendor=openai-batch

:: Dry run / phase-only
node scripts\aicost-benchmark-crawler.js --dry-run
node scripts\aicost-benchmark-crawler.js --phase=crawl
node scripts\aicost-benchmark-crawler.js --phase=extract

:: Available topic slugs:
::   anthropic-caching, anthropic-batch, openai-batch, openai-caching,
::   google-gemini, google-vertex, aws-bedrock, mistral, pinecone, cohere

:: Review flagged rows (Mistral couldn't verify claim from source text)
mysql -u root -p toolsinfo -e "SELECT topic_slug, claim, source_url FROM aicost_benchmarks WHERE needs_review = 1;"

:: Single vendor
node scripts\generate-vendor-pricing-guides-batch.js --vendor=anthropic --force

:: Multiple vendors
node scripts\generate-vendor-pricing-guides-batch.js --vendor=anthropic --vendor=openai --force

:: All 16 V2 vendors (~$0.30, ~5-7 minutes)
node scripts\generate-vendor-pricing-guides-batch.js --all --force

:: Open the procedure doc
notepad D:\aicost\docs\MICROSOFT-MANUAL-UPDATES.md

:: Edit verified plan data with current Microsoft pricing
notepad D:\aicost\lib\hybrid-pricing-data-verified-2026q2.js

:: Update last_verified date in routes/crawler-health.js MANUAL_VENDORS
notepad D:\aicost\routes\crawler-health.js

:: Then regen Microsoft V2
node scripts\generate-vendor-pricing-guides-batch.js --vendor=microsoft --force

:: Register all scheduled tasks (run as admin)
powershell -ExecutionPolicy Bypass -File D:\aicost\powershell\Run-AicostCrawler.ps1

:: List all aicost scheduled tasks
schtasks /query /tn "aicost*"

:: Manually trigger a scheduled task
schtasks /run /tn "aicost-pricing-crawler"

:: View recent task history (last 24h)
powershell "Get-WinEvent -LogName 'Microsoft-Windows-TaskScheduler/Operational' -MaxEvents 50 | Where-Object {$_.Message -like '*aicost*'}"

:: Last run per vendor (all crawlers)
mysql -u root -p toolsinfo -e "SELECT vendor_slug, COUNT(*) AS runs, MAX(started_at) AS last_run FROM aicost_crawler_runs GROUP BY vendor_slug ORDER BY last_run DESC;"

:: Recent price changes (last 7 days)
mysql -u root -p toolsinfo -e "SELECT provider_slug, model_slug, field_name, old_value, new_value, change_pct, detected_at FROM aicost_price_changelog WHERE detected_at >= DATE_SUB(NOW(), INTERVAL 7 DAY) ORDER BY detected_at DESC LIMIT 20;"

:: V2 guide refresh status
mysql -u root -p toolsinfo -e "SELECT slug, schema_version, last_refreshed_at FROM aicost_guides WHERE type='vendor-pricing' AND schema_version='v2' ORDER BY last_refreshed_at DESC;"

:: pricing-data.js last modified
dir D:\aicost\lib\pricing-data.js