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.

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 production-level patterns and common pitfalls for using Prisma ORM in TypeScript backends. Learn best practices for schema design, optimizing queries using select/include, managing complex transactions, implementing singleton patterns, and mitigating issues in serverless environments and bulk operations.

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.

This guide helps researchers determine if their study—particularly in clinical neurology or translational neuroscience—meets the high standards of leading journals like Brain. It provides detailed insights into required mechanistic depth, evidence types (e.g., genetics, biomarkers), appropriate reporting guidelines (STROBE, CONSORT, PRISMA), and common desk-reject expectations. It is a venue-fit aid, detailing the scientific rigor needed for submission.