3. Data, Science & AI

Resolves conflicts between skills, facts, or agent recommendations using predefined precedence rules.

Builds, debugs, and optimizes Splunk Enterprise 10.0 SPL queries using local knowledge bases and validation tools for efficient data analysis.

Provides best practices for ClickHouse query optimization, data engineering patterns, and high-performance analytical workloads.

Executes batch prediction requests for Gemini model using Google Cloud Vertex AI, including input preparation and API setup.

Determines consensus or disagreement from a 5-agent debate, exposing disagreements as actionable developer decisions.

Provides API integration for Longbridge OpenAPI to manage stock trading, access real-time market data, and query account information in Hong Kong and US markets.

Enables interactive database schema inspection and SQL query execution for PostgreSQL, MySQL, and SQLite using Bun's native capabilities.

Framework for assessing and enhancing codebase readiness for autonomous AI agents, identifying gaps in tooling, documentation, and testing.

Converts ML Product Requirements Documents (PRDs) into prd.json format required by ML-Ralph, streamlining AI project setup.

Guide for maintaining and extending the National Rice Pest Monitoring Network, covering data collection protocols, analysis, and system scalability.

Transforms CSV data into structured JSON format for seamless data integration and application use.

Architects the cognitive structure and reasoning framework for AI agents prior to code generation, ensuring coherent agent behavior.

SQLite-based storage solution for time-series SEO metrics, enabling efficient data retention and retrieval for search engine optimization analytics.

Comprehensive guide for building Claude Code subagents, covering architecture, patterns, tools, and best practices for agent system design.

Generates code through iterative refinement using four agent roles (Orchestrator, Generator, Critic, Refiner) to converge on working solutions.

Enables efficient RDBMS access patterns for DuckDB, MySQL, PostgreSQL, SQL Server, and DBISAM via ODBC and native drivers.

Transcribes audio files into text using OpenRouter and AI models like Gemini and GPT-4o-audio.

Internal operational manual for AI agent workflows, including task execution and software engineering integration.

Provides comprehensive tools for creating, editing, and analyzing spreadsheets with support for formulas, formatting, data analysis, and visualization across multiple formats.

Manages SQLite database schemas and operations for StateManager, enabling persistence of runs, rounds, and agent data with better-sqlite3.

Generates pivot tables from detailed datasets to enable data summarization, analysis, and visual presentation for business insights.

Central meta-skill for building and unifying AI agent capabilities, managing analysis, workflows, tools, and scaffolding through orchestration.

Optimizes database schemas, advanced SQL queries, and Supabase Row Level Security (RLS) configurations for secure and efficient data operations.

Enhances user prompts using LLM best practices, identifying gaps and providing actionable improvements for better model responses.