Skill UI

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.

This guide provides production-ready patterns for integrating with Bright Data proxy services. It covers critical aspects like setting up a proxy client, implementing robust retry logic for transient errors (e.g., 502, 503), managing sticky sessions for consistent IPs, and parsing complex HTML responses. Essential for building reliable, high-scale web scrapers using TypeScript and Python.

A comprehensive guide to designing high-performance schemas in ClickHouse. Learn how to select the optimal MergeTree engine (e.g., ReplacingMergeTree, AggregatingMergeTree), structure the ORDER BY key for maximum query efficiency, and implement effective partitioning strategies for large-scale analytical workloads and ETL processes.

This comprehensive guide provides advanced techniques to diagnose and significantly boost ClickHouse query performance. It covers analyzing slow queries using system tables, optimizing ORDER BY keys, implementing data skipping indexes (Bloom, Set, MinMax), utilizing projections for pre-aggregation, and fine-tuning server settings and materialized views. Essential for high-volume OLAP environments.

This comprehensive checklist guides users through critical operational readiness steps for a ClickHouse production deployment. It covers server tuning (config.xml), schema design best practices, robust backup strategies (S3), detailed monitoring setup (Prometheus/Grafana), security hardening, and application integration verification. Use this document before go-live, during major upgrades, or when auditing production systems to ensure maximum stability and performance.

This comprehensive guide details best practices for securing a ClickHouse deployment. It covers essential security measures including role-based access control (RBAC) for granular user permissions, implementing row-level security for multi-tenancy, configuring network IP restrictions, enabling TLS encryption, and setting up detailed audit logging. Use this when hardening a production ClickHouse instance or enforcing strict data governance.

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.

Use the HasData CLI to access real-time, structured web data from major platforms. This tool provides dedicated subcommands for various APIs (including Google SERP, Amazon, Zillow, Booking, etc.), enabling users to automate data collection, scrape specific URLs, and retrieve structured information like local business listings, product pricing, and real estate data directly from the command line.

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.

This skill provides a single CLI interface to query numerous web search engines, including Brave, DuckDuckGo, Bing, Baidu, Sogou, and 360. It runs parallel searches, aggregates the results from various sources, and normalizes them into a uniform JSON format. Ideal for deep research, fact-checking claims across multiple platforms, or comparing global vs. regional search results.

Provides expert guidance for connecting to Power BI Desktop's local tabular model using the Tabular Object Model (TOM) and ADOMD.NET via PowerShell. This skill covers model enumeration, executing DAX queries, metadata modification (tables, measures, relationships), query tracing, and model refreshing. It is specifically designed for managing the underlying data model structure when external tools like Tabular Editor CLI are unavailable.