Skill UI

Automates Snowflake data warehouse workflows via the Composio MCP, letting you list databases, schemas, and tables, run SQL (SELECT, DDL, DML), and integrate those operations into cross-app pipelines for faster data ops.

Conduct rigorous, multi-database literature reviews with systematic workflows, verified citations in styles like APA or Nature, and AI-enhanced schematics for publication-ready markdown and PDF outputs in biomedical and technical domains.

This skill manages the complexities of Clari API version changes, ensuring smooth transitions (e.g., v3 to v4). It guides developers through detecting schema drift, performing data field compatibility checks, and executing necessary database migrations (SQL/Python), ensuring reliable data pipelines after platform updates.

Conduct comprehensive systematic literature reviews across biomedical and scientific domains using multiple academic databases. Synthesize findings, verify citations, and generate professional markdown or PDF documents. Includes AI-generated scientific schematics for visual enhancement. Ideal for research synthesis, meta-analyses, and thesis writing.

A comprehensive guide detailing the process of migrating data warehouses to Snowflake from major sources like Amazon Redshift, Google BigQuery, or on-premise databases. This resource covers critical steps including schema conversion (handling dialect differences like STRUCT/ARRAY to VARIANT), robust data transfer methods (S3/Cloud Storage, Python/Pandas), data validation techniques (checksums, row counts), and essential SQL syntax translation patterns.

This powerful tool compares identical tables across two SQL Server instances (e.g., Production vs. Staging). It efficiently detects missing rows, extra columns, schema drifts, and data mismatches. Leveraging Python and Apache Arrow for fast columnar data transfer, it provides a comprehensive reconciliation report, making it essential for data migration validation and ETL verification.

A comprehensive skill for interacting with Weaviate vector databases. It enables advanced operations including semantic search, hybrid keyword querying, schema inspection, data exploration, collection creation, and bulk data import (CSV, JSON, PDF). Use this skill when you need to query data conceptually, retrieve specific raw objects, or manage the lifecycle of Weaviate collections.

Generates SQL validation notebooks for dbt PR changes with before/after comparison queries. Supports GitHub PR URLs and local repositories. Creates interactive notebooks for database validation across Snowflake, BigQuery, Redshift, and Athena. Includes schema inference from dbt_project.yml and model configs.

Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth write protection. Ideal for schema exploration, data retrieval, and analysis without risking accidental writes.

A comprehensive skill for interacting with Weaviate vector databases. It enables advanced operations including semantic search, hybrid keyword querying, schema inspection, data exploration, collection creation, and bulk data import (CSV, JSON, PDF). Use this skill when you need to query data conceptually, retrieve specific raw objects, or manage the lifecycle of Weaviate collections.