Skill UI

polars-bio accelerates genomic interval math and bioinformatics I/O by combining Polars, Arrow, and DataFusion to handle BED/VCF/BAM/GFF/FASTA streams, SQL queries, and cloud storage with overlap, coverage, and nearest APIs plus streaming fallbacks.

Master the use of the `gh` CLI to interact with core GitHub features. This guide covers managing issues, checking Pull Request statuses, listing and debugging CI workflow runs, and executing advanced data queries via the GitHub API. Essential for automating DevOps workflows and debugging CI/CD pipelines directly from the terminal.

A powerful operational companion for database developers. This skill assists with the daily lifecycle of database interactions, including translating natural language requirements into optimized SQL queries, generating database migrations, performing comprehensive schema introspection across multiple dialects (PostgreSQL, MySQL, SQLite, SQL Server), and identifying performance bottlenecks through detailed query optimization and index recommendations. It also supports ORM patterns like Prisma and SQLAlchemy.

A comprehensive guide for integrating and utilizing Firebase Data Connect within Flutter applications. Learn how to set up schemas, write typed GraphQL queries and mutations, handle real-time data streams, implement robust offline capabilities, and apply best practices for security and performance.

Guides multi-round investigation of any GitHub repository, combining API queries, discovery searches, and deep dives to produce structured markdown reports with summaries, timelines, metrics tables, and Mermaid diagrams for executive-ready briefs.

A deep dive into best practices for optimizing application performance across the entire stack, including frontend rendering, backend logic, and database queries. Learn the systematic workflow—Measure, Identify, Fix, Verify—using core metrics like Web Vitals (LCP, INP, CLS) and techniques to resolve common anti-patterns such as N+1 queries and render-blocking resources. Essential for improving user experience and addressing performance regressions.

This comprehensive guide covers best practices for building robust database systems. It teaches crucial concepts like schema normalization, effective indexing strategies, selecting the right database (e.g., SQLite vs PostgreSQL) and ORM, and optimizing queries to prevent common performance issues like N+1 problems. It emphasizes making context-aware architectural decisions.

This guide provides comprehensive patterns for migrating Enzyme unit tests to React Testing Library (RTL), especially when upgrading to React 18. It emphasizes the crucial philosophical shift from testing internal implementation details (like state or props) to asserting visible user behavior. Learn best practices for rewriting shallow/mount/simulate calls into modern, accessible, and resilient RTL queries, ensuring your tests reflect how a user genuinely interacts with the component.

This script provides a lightweight, standalone Python integration for Google Sheets, offering full read and write access without needing a dedicated server. Users can retrieve spreadsheet data in multiple formats (plain text, CSV, JSON), extract specific ranges, find sheets via search queries, and perform advanced write operations like updating, appending, or clearing cell values. It is highly suitable for automating data reporting, extraction, and workflow integrations involving Google Workspace.

Automates Linear issues, projects, cycles, labels, comments, and GraphQL workflows through Rube MCP’s Composio toolkit so teams can manage states, tasks, and custom queries without juggling direct APIs.

Assistant for PostgreSQL developers that highlights native features, advanced data types, performance tuning patterns, and extension usage to optimize queries, indexes, and analytics in PostgreSQL projects.

Automates Salesforce CRM workflows through Rube MCP's Composio toolkit, letting you manage leads, contacts, accounts, opportunities, SOQL queries, and tasks with guided tool sequences and prerequisites.