Skill UI

An advanced workflow orchestrator designed to perform multi-phase, deep-dive schema optimization on large datasets (e.g., BigQuery exports). It systematically analyzes schema structure, identifies unused or redundant fields, assesses potential impact, and generates a comprehensive, actionable report with recommended optimization strategies and estimated savings.

This skill functions as an expert-level web researcher, utilizing advanced search strategies (query optimization, domain filtering) to gather, synthesize, and validate information from multiple web sources. It is ideal for complex research tasks requiring fact verification, identifying trends, and producing structured, actionable insights, ensuring high credibility for the final output.

Guides GCP service account management requests with automated best practices, step-by-step help, production-ready code/configuration, and validation across compute, storage, BigQuery, Vertex AI, Cloud Run, and Firebase workflows.

Master systematic methodologies for using Shodan to perform deep reconnaissance during penetration testing. This skill covers querying exposed services, mapping assets, identifying vulnerable systems (CVEs), and utilizing advanced filters for IP ranges, geographical locations, and organizational data. Ideal for security researchers and ethical hackers.

Automate Shortpixel image workflows by querying Rube MCP through Composio, validating the shortpixel connection, searching tool schemas, and running schema-compliant multi-execute calls with managed sessions.

This skill provides systematic patterns and best practices for transforming slow database queries into high-performance operations. It covers techniques like proper indexing, query plan analysis (e.g., using EXPLAIN), schema design improvements, and resolving common issues like N+1 query problems. Use it to debug performance bottlenecks, reduce database load, and ensure scalable application backends.

A comprehensive skill for optimizing complex SQL queries, designing robust database schemas, and troubleshooting performance bottlenecks across various dialects (PostgreSQL, MySQL, etc.). Use this when queries are slow, complex set-based logic is needed (CTEs, Window Functions), or when structuring/migrating a database schema. It provides detailed query plan analysis, advanced indexing strategies, and industry best practices.

Automates SQL query optimization guidance for data analytics workflows, offering best practices, pattern advice, and production-ready code for queries, BI, and visualization tasks whenever the user invokes SQL query optimizer support.

Automate Square payments, orders, invoices and location tasks through Composio's Square toolkit via Rube MCP, always querying RUBE_SEARCH_TOOLS first to stay aligned with live schemas before running workflows.

Automates Supabase operations through the Rube MCP toolkit, letting you query tables, inspect schemas, execute SQL, manage projects/orgs, and monitor storage or edge functions with workflow-aware guidance.

This guide demonstrates the fundamental "Hello World" query using the Supabase JS/Python client. It covers creating a structured table, enabling Row Level Security (RLS), inserting a record, and successfully selecting it back. This is essential for verifying project connectivity, understanding the basic data round-trip pattern, and mastering initial database interactions in a new Supabase environment.

This comprehensive guide provides systematic methods to optimize Supabase query and database performance. Techniques cover PostgreSQL indexing (basic, composite, partial), using EXPLAIN ANALYZE for query plan analysis, optimizing client calls (column selection, pagination), and managing infrastructure resources like connection pooling. Use this when facing slow queries, high latency, or preparing a project for production-scale traffic.