Skill UI

Vaex is a high-performance Python library designed for processing and visualizing enormous tabular datasets that exceed available RAM (gigabytes to terabytes). It excels at out-of-core DataFrame operations, lazy evaluation, fast statistical aggregation, and machine learning integration on massive datasets. Use it for analyzing large CSV, Parquet, or HDF5 files efficiently on a single machine, without memory constraints.

This skill provides comprehensive access to 78 public REST APIs, covering biomedical science, chemistry, materials science, physics, and economics. Users can query vast datasets for genes, proteins, compounds, clinical trials, patents, and environmental indicators. It is an indispensable tool for deep academic research, complex data analysis, and cross-disciplinary scientific investigation.

This skill connects to the DeepEar Lite platform to fetch real-time, high-frequency financial signals. It retrieves crucial data points including signal titles, sentiment summaries, confidence scores, and detailed reasoning. Use this when you require immediate, actionable insights into volatile market trends, stock performance factors, or comprehensive financial analysis.

This skill utilizes the Kronos model to perform advanced financial time-series forecasting. It generates quantitative base predictions and then integrates news sentiment analysis to adjust and refine the forecast, making it an essential tool for finance professionals needing actionable market insights.

This tool collects comprehensive diagnostic data from ClickHouse system tables. It gathers crucial metrics, query logs, merge statuses, and disk usage information. It is essential for troubleshooting performance bottlenecks, preparing detailed support tickets, or investigating complex database infrastructure issues.

A comprehensive guide and implementation template for building robust data ingestion pipelines into ClickHouse. Supports multiple sources including HTTP webhooks (with batching), Kafka streams, S3, and direct SQL inserts. Demonstrates best practices for data handling, such as deduplication using ReplacingMergeTree and monitoring query logs, ensuring reliable, scalable data analytics.

This skill provides the core mechanism for integrating Hex into external data pipelines. It enables triggering, monitoring, and managing Hex projects (e.g., via Airflow or Dagster) programmatically. Users can implement parameterized runs, execute multi-step ETL workflows sequentially, and handle status polling and error management, making it ideal for production data orchestration.

This guide provides a quick reference for diagnosing and fixing the top common errors encountered in ClickHouse, including syntax errors, memory limit issues, write permission failures, and data type mismatches. It offers specific error codes, root causes, and actionable SQL solutions for smooth database operation and complex analytics.

This comprehensive guide teaches users how to set up a ClickHouse database environment. It covers creating a MergeTree table, inserting structured event data using TypeScript, and executing essential analytical queries (e.g., counting, grouping, unique user metrics). Ideal for beginners learning OLAP databases, testing connections, or mastering core data warehousing concepts.

This guide provides comprehensive steps for setting up and authenticating the official ClickHouse client for both Node.js and Python. It covers connecting to ClickHouse Cloud or a self-hosted instance, managing environment variables, and verifying the connection using sample code snippets. Ideal for new ClickHouse projects or integrating data analytics pipelines into existing applications.

A comprehensive tutor designed to build robust statistical thinking. It guides users through the entire data analysis lifecycle, from exploratory data visualization and descriptive statistics to complex hypothesis testing and regression modeling. The focus is on understanding the 'why' and 'how' of statistical logic using real datasets and practical problems, rather than just memorizing formulas. It is tool-agnostic, supporting concepts learned in Python, R, SPSS, or Stata.

This skill aggregates real-time financial information, including hot news articles and market trends from multiple sources (e.g., Weibo, Zhihu). It is also capable of retrieving structured data from prediction markets like Polymarket. Use this when you need a unified, comprehensive view of the financial market landscape, spanning breaking news, aggregated sentiment, and forward-looking market predictions.