Skill UI

A structured guide for setting up a robust local development environment for Palantir Foundry data pipelines. This workflow enables users to run Python transforms and unit tests using PySpark against sample data, and mock the Foundry API client, ensuring fast, isolated iteration cycles before deploying code to the official Foundry environment. Ideal for data engineers and developers building complex ETL logic.

This advanced skill is an end-to-end tool for transforming complex research topics into professional, visualized knowledge graph PDFs. It automatically conducts multi-round web searches, extracts key entities, structures related knowledge, and designs the optimal visualization (supporting Graphviz, PlantUML, etc.). Ideal for deep academic analysis, mapping character relationships, or visualizing complex technical architectures where existing structured data is unavailable.

Master the creation of robust ELT (Extract, Load, Transform) data pipelines within Snowflake. This guide demonstrates advanced data orchestration using Snowflake Streams for Change Data Capture (CDC), Tasks for scheduled transformations and DAG management, and Dynamic Tables for declarative, auto-refreshing data models. Ideal for building sophisticated, scalable data warehousing solutions.

A comprehensive guide detailing the process of migrating data warehouses to Snowflake from major sources like Amazon Redshift, Google BigQuery, or on-premise databases. This resource covers critical steps including schema conversion (handling dialect differences like STRUCT/ARRAY to VARIANT), robust data transfer methods (S3/Cloud Storage, Python/Pandas), data validation techniques (checksums, row counts), and essential SQL syntax translation patterns.

A powerful skill for searching and retrieving comprehensive academic metadata using the OpenAlex API. It provides a unified view of research papers, including full open citation graphs, detailed institutional affiliations, and crucial funding information (e.g., NSF, NIH). Ideal for deep academic research, comparative literature reviews, and identifying research trends across multiple disciplines.

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.)

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.

A powerful command-line utility that transforms virtually any website into a structured CLI command. By utilizing OpenClaw's browser, it allows users to scrape and extract structured data (such as JSON) from over 36 platforms—including social media, finance, and developer communities—directly from the terminal. This tool eliminates the need for complex scraping code or browser extensions, making web data accessible via simple one-liners.

Execute arbitrary PySpark or pure Python code directly on Fabric Spark compute using the Livy API. This method creates ephemeral sessions without generating persistent notebook artifacts. It provides full read/write access to lakehouse Delta tables, making it ideal for agent-driven ETL pipelines, quick data transformations, or analyses where session cleanup is critical. Users must manage the session lifecycle (create, run, and delete).

Transform raw structured data (CSV, Excel, JSON) into professional, long-form, interactive visualization reports. This tool generates comprehensive business review pages featuring KPI dashboards, multiple dynamic charts (using Chart.js/ECharts), detailed data tables, and narrative business insights, making it ideal for weekly or monthly performance reporting.

This skill calculates model interpretability for algorithmic trading signals using PageRank. It constructs a feature-contribution graph from an LSTM or Transformer signal and executes a single-entry PageRank calculation. The result identifies the top-K features that most significantly drove the prediction, providing a "regulator-grade" audit trail essential for compliance with regulations like the EU AI Act.

A comprehensive tool for training and evaluating advanced neural network models (including LSTM, Transformer, and N-BEATS) on time-series market data. It facilitates the prediction of financial trends, generating results with confidence intervals, and comparing performance across multiple architectures. Ideal for quantitative trading research and financial forecasting.