Skill UI

This comprehensive guide outlines the end-to-end process of building production-grade ETL data pipelines using Databricks and Delta Lake. It implements the robust Medallion Architecture (Bronze, Silver, Gold) for scalable data management. Techniques covered include Auto Loader for incremental streaming ingestion, MERGE INTO for upsert semantics, data cleansing, and advanced aggregation into analytics-ready layers. Ideal for establishing reliable data pipelines in a data lakehouse environment.

Automates Semanticscholar workflows through Composio’s Semanticscholar toolkit via Rube MCP, covering tool discovery, connection verification, session reuse, and schema-compliant multi-tool execution for reliable research automation.

A comprehensive guide and checklist for identifying potential risks when migrating database applications from Oracle to PostgreSQL. It systematically cross-references code and migration artifacts against known behavioral differences, covering issues such as empty string handling, refcursors, type coercion, sorting logic, and timestamp semantics. Use this tool during the planning phase to proactively mitigate risks, or during validation to ensure comprehensive integration test coverage for the new PostgreSQL environment.

Guides Python authors from commit to release with end-to-end steps for structuring src layouts, choosing setuptools/hatchling/flit/poetry backends, enforcing SOLID+type-hinting patterns, orchestrating lint/test/CI, managing PEP 440 semantics, and publishing trusted releases to PyPI.

Master the complexities of building robust Retrieval Augmented Generation (RAG) pipelines using LangChain. This guide addresses common pitfalls in vector search, such as score semantics differences (L2 vs. Cosine), embedding dimension mismatches, and chunking issues for code/Markdown. Learn best practices for selecting between FAISS, Pinecone, Chroma, and PGVector, normalizing scores, and implementing hybrid keyword+vector search for maximum retrieval quality.

Implement robust human-in-the-loop (HITL) approval gates for sophisticated LangGraph workflows. This skill enables the graph to pause execution before critical, irreversible actions (like sending emails or calling tools). It manages complex state serialization, provides clear resume semantics using `Command(resume=...)`, and integrates with external UIs (e.g., Slack) to await human decision, ensuring safe and controlled workflow execution.

A comprehensive reference guide covering idiomatic C++ practices, focusing on modern features from C++17 to C++23. Topics include smart pointers, move semantics, structured bindings, ranges library, concepts, and robust error handling techniques.

This tool diagnoses and validates complex cron expressions (e.g., crontab, Kubernetes CronJob) to prevent silent scheduling failures. It identifies five common pitfalls: impossible dates, misunderstood OR semantics, resource spikes, uneven step drift, and leap year issues. Users can check the syntax, understand the true meaning, and calculate future execution times reliably.

This comprehensive guide outlines industry best practices for designing robust and consistent REST APIs. It covers proper resource naming conventions, standardized HTTP method semantics, detailed HTTP status codes (e.g., 201, 404, 422), structured response formats (including pagination and links), and advanced strategies like cursor-based pagination. Essential for building scalable and maintainable APIs.