Skill UI

Generate data analysis reports by exploring database tables, running multidimensional SQL queries, performing deep attribution analysis, and outputting dynamic HTML visual reports with ECharts for business, trend, and KPI scenarios.

This guide provides a comprehensive workflow for searching and retrieving biomedical literature from PubMed and NCBI. It covers advanced query construction using MeSH terms and specific field tags, advanced filtering (date, publication type), and a repeatable programmatic workflow using NCBI E-utilities (esearch, efetch). Essential for researchers conducting systematic reviews and literature monitoring.

Provides a structured workflow for systematically accessing and analyzing official intellectual property data from the USPTO. This skill covers patent search (PatentSearch API), trademark status checks (TSDR), ownership transfer tracking, and building reproducible IP landscape logs. It is designed for data collection and record verification, emphasizing the use of official APIs and rigorous logging practices. (Warning: Not for legal advice.)

A specialized intelligence tool for comprehensive patent prior-art and landscape analysis. Unlike generic searches, this skill forces commitment to one of five critical sub-use-cases (Novelty Search, Freedom-to-Operate, Competitive Landscape, etc.) before conducting searches across major patent databases (Google Patents, Espacenet, USPTO). It outputs a detailed, editable report containing claim-aware analysis, risk flags, and strategic recommendations.

This powerful tool compares identical tables across two SQL Server instances (e.g., Production vs. Staging). It efficiently detects missing rows, extra columns, schema drifts, and data mismatches. Leveraging Python and Apache Arrow for fast columnar data transfer, it provides a comprehensive reconciliation report, making it essential for data migration validation and ETL verification.