3. Data, Science & AI

Validates bookmark data quality, detects duplicates, identifies missing information, and suggests tags based on URL patterns to improve collection health.

Analyzes market regimes (BULL/BEAR/SIDEWAYS) to quantify profit contribution and prevent regime mismatch in trading strategies.

Builds and updates vector indexes for Bilibili video knowledge bases using embeddings and PostgreSQL/pgvector, enabling semantic search capabilities.

Automates Bilibili video crawling (by UP/BVID) and database storage, with transcript export to TXT for knowledge base preparation.

Coordinates multiple AI agents for complex tasks using Claude Code's TeammateTool and Task system, enabling parallel workflows and self-organizing queues.

Provides real-time snow conditions, forecasts, and ski reports for over 1000 mountain resorts worldwide using OpenSnow API. Supports quick lookups via SnowTick codes and favorite resorts.

Configures and optimizes analytics tracking implementations including Google Analytics 4, Google Tag Manager, and UTM parameters for accurate data collection.

Generates CSV import functionality for bank transactions with column mapping, duplicate detection, and data preview to streamline financial data processing.

Manages PostgreSQL 16 databases using Prisma ORM, including schema migrations, data seeding, and advanced query patterns.

Extracts and structures book content from raw text into standardized application data formats for efficient storage and retrieval.

Guides creation of Model Context Protocol (MCP) servers to integrate external APIs with LLMs, supporting Python (FastMCP) and Node/TypeScript (MCP SDK).

Manages database schema evolution through versioned SQL scripts using Flyway for consistent database migrations.

Processes natural language requests and executes MCP tools for TaskFlow natural language task management.

Converts EPUB ebook files into Markdown format for seamless editing, documentation integration, and content reuse.

Automates receipt data extraction from scanned documents and stores details in a searchable database for easy retrieval and analysis.

Generates contextual data for spreadsheet rows by adding new columns, enhancing dataset utility through automated data enrichment.

Generates data visualizations and insights from TaskFlow application data to analyze productivity metrics and create reports.

Provides foundational principles for building AI-powered development workflows, including agent design, token optimization, and modular architecture patterns.

Manages database schema evolution through versioned SQL migrations using Flyway, ensuring consistent and traceable database changes.

Assists in planning, designing, and implementing A/B tests and experiments for data-driven product and marketing decisions.

Enables autonomous task iteration for complex LLM workflows exceeding context window limits, ensuring seamless multi-step execution.

Retrieves real-time stock prices, fundamentals, earnings, and financial metrics from Yahoo Finance using the yfinance library.

Expert assistance in designing, optimizing, and managing database schemas and SQL queries for efficient data handling.

Manages PostgreSQL databases including schema design, Alembic migrations, and troubleshooting for smartem-decisions.