Skill UI

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.

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.

A comprehensive guide to implementing advanced user behavior tracking and real-time data synchronization with Algolia. This guide demonstrates how to use the Insights API to track clicks, conversions, and views, and how to build event-driven pipelines using database change listeners (e.g., Prisma middleware) to keep your Algolia index perfectly synced with your core application data. Essential for deep search analytics and relevance tuning.

This skill guides the systematic process of conducting comprehensive literature reviews across multiple academic databases (e.g., PubMed, arXiv, Semantic Scholar). It supports meta-analyses, scoping reviews, and state-of-the-art investigations. The rigorous workflow includes structured searching, data extraction, citation verification, thematic synthesis, and generating publication-quality reports (PDF/Markdown) complete with mandatory scientific schematics (like PRISMA flow diagrams) to ensure academic rigor and reproducibility.

A comprehensive guide to implementing a production-ready Shopify app architecture using the Remix framework. This template covers ideal project structure, integrating Prisma for robust session storage, and implementing official Shopify patterns like Theme App Extensions and webhooks. Use this when starting a new e-commerce SaaS application on Shopify.

A comprehensive guide to production-grade patterns and common pitfalls when using Prisma ORM with TypeScript backends. Covers optimizing schema design, implementing complex queries, managing transactions, handling pagination strategies, and addressing critical traps like connection exhaustion in serverless environments.

A comprehensive guide to safe and reversible database migration patterns. Covers zero-downtime schema changes, data backfilling, and rollbacks for major databases like PostgreSQL and MySQL, and popular ORMs (Prisma, Drizzle, Django). Learn techniques like concurrent indexing and the expand-contract pattern to ensure production stability.

This skill fetches the latest, live documentation and code examples for specific libraries and frameworks (e.g., Next.js, React, Prisma). Instead of relying on static or outdated training data, it utilizes the Context7 MCP to provide accurate, up-to-date answers for setup questions, API references, and code generation based on current best practices.

A comprehensive guide covering advanced patterns, common pitfalls, and optimization techniques for using Prisma ORM in TypeScript backend applications. Learn best practices for schema design, handling transactions, optimizing queries (include vs select), and managing connection pools in production environments.

This skill guides authors through evaluating the suitability of their clinical research manuscript for Annals of Internal Medicine. It provides deep insights into the journal's high standards, including specific methodological requirements (CONSORT, PRISMA, STROBE, STARD, TRIPOD), required evidence synthesis depth, ideal scope (RCTs, systematic reviews, guidelines), and current house style guidelines necessary for successful submission.

Provides comprehensive guidelines for authors conducting systematic reviews and meta-analyses in psychology. It emphasizes documenting the literature search protocol, ensuring quantitative synthesis rigor (PRISMA flow, effect-size data), and making all findings open and reproducible for high-impact academic publication.

A methodological guide for documenting the rigor of literature reviews, especially in sociology. It details how to build a comprehensive 'coverage account' (a near-PRISMA record of the search process) and how to ensure any quantitative synthesis (meta-analysis, bibliometrics) conducted within the review is fully reproducible by depositing data and code.