Skill UI

Guidance for implementing Cloud Firestore in Flutter: selecting the database, configuring offline persistence, designing schemas, querying with filters and pagination, writing batched transactions, indexing, optimizing for scale, and avoiding write hotspots.

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.

Automates Notion pages, databases, blocks, comments, and users through Composio’s Notion toolkit via Rube MCP, guiding connection setup, tool sequencing, and schema-aware workflows for operations.

A universal assistant for conducting deep code reviews across major SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). It rigorously analyzes SQL code for critical vulnerabilities (like SQL injection), performance bottlenecks, maintainability issues, and adherence to industry best practices. Features include security audits, index optimization recommendations, query structure analysis, and schema design validation, ensuring robust and secure database development.

Automates Supabase projects by sequencing Composio Rube MCP workflows for database querying, schema inspection, SQL execution, project/org management, storage buckets, edge functions, and health monitoring while always refreshing tool schemas first.

This skill is designed for understanding complex database structures. It allows users to list all available tables, intelligently filter relevant tables based on natural language queries, retrieve detailed schemas (columns, types, primary/foreign keys), and map inter-table relationships. It culminates in generating the M-Schema format, which is essential for accurately preparing the context needed for advanced SQL query generation.

Provides a comprehensive setup guide for running ClickHouse locally using Docker Compose. This includes defining the database schema, seeding mock data, and setting up robust integration tests (using vitest). Ideal for developers building OLAP systems or performing local data analysis to ensure schema and query reliability.

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.

Automate the execution of integration tests against a live ClickHouse database instance within a Continuous Integration (CI) pipeline using Docker containers. This setup eliminates the need for mocks, ensuring thorough schema validation and query reliability in environments mirroring production deployments. Ideal for robust CI/CD setup and schema enforcement.

This skill redirects deprecated requests to the canonical Aurora DSQL skill for managing distributed SQL schemas, migrations, queries, authentication, and performance. It supports application development on AWS Aurora databases. Users should follow the installation instructions in awslabs/agent-plugins for the verified plugin.

This plugin allows developers to build Framer components by syncing data from external data sources (such as APIs or databases) into Framer's Managed Collections. It serves as the primary integration pattern, handling both schema creation and item population. Use this when your design requires displaying dynamic content driven by external systems.

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.