Databases

Query Deutsche Bahn train connections and prices.

Authentication and access control skill for Next.js 15 + Supabase applications. Use when implementing user authentication, protecting routes, managing user sessions, enforcing role-based access control (admin/member), or working with multi-tenant family-based data isolation. Covers login/logout, registration with email verification, OAuth (GitHub), route protection for Server Components and Server Actions, admin-only features, and multi-tenant data access patterns.

Frontend development guidelines for React/TypeScript applications. Modern patterns including Suspense, lazy loading, useSuspenseQuery, file organization with features directory, MUI v7 styling, TanStack Router, performance optimization, and TypeScript best practices. Use when creating components, pages, features, fetching data, styling, routing, or working with frontend code.

Modern Node.js backend stack: NestJS/Hono, Drizzle ORM, Vitest, TypeScript.Use when: building Node.js APIs, TypeScript backends, or serverless functions.Triggers: "nestjs", "node backend", "express", "hono", "drizzle", "vitest","typescript api", "node api", "bun".

Design and implement RESTful backend API endpoints following REST principles and conventions. When creating or modifying API endpoints, route handlers, controllers, or any files that define HTTP endpoints (e.g., routes.ts, api.ts, controllers/*, handlers/*). When working on files that handle HTTP requests and responses, implement versioning strategies, or define resource-based URL structures. When building REST APIs with proper HTTP methods (GET, POST, PUT, PATCH, DELETE), implementing query parameter handling for filtering and pagination, or setting up rate limiting and HTTP status code responses.

Patterns standard pour les API Next.js. Utiliser pour créer, modifier ou débugger des endpoints.AUTO-ACTIVATE when user mentions (FR/EN): - API, endpoint, route, /api/, NextResponse - GET, POST, PUT, DELETE, PATCH - 500 error, 400 error, API error - créer API, create API, new endpoint - Prisma dans API, fetch, response

OAuth 2.1 Bearer Token usage guide. Use when implementing access token transmission, Authorization header support, resource server validation, and security requirements. Covers query parameter prohibition and token protection. Based on OAuth 2.1 Section 5 requirements.

Static analysis security vulnerability scanner for Ruby on Rails applications. Use when analyzing Rails code for security issues, running security audits, reviewing code for vulnerabilities, setting up security scanning in CI/CD, managing security warnings, or investigating specific vulnerability types (SQL injection, XSS, command injection, etc.). Also use when configuring Brakeman, reducing false positives, or integrating with automated workflows.

Comprehensive Next.js v16 development with Cache Components, feature-based architecture, and best practices. Use for ANY Next.js 16 task to know - (1) Project structure with features folder pattern, (2) Where to fetch data with use cache, (3) Server vs Client component decisions, (4) One file per query/type/schema/hook pattern, (5) Cache invalidation with updateTag/revalidateTag, (6) Proper component organization within features. Apply to all Next.js 16 development tasks.

Master Directus backend internals: API extensions, hooks, flows, services, and database operations

Performance optimization patterns for Mem0 memory operations including query optimization, caching strategies, embedding efficiency, database tuning, batch operations, and cost reduction for both Platform and OSS deployments. Use when optimizing memory performance, reducing costs, improving query speed, implementing caching, tuning database performance, analyzing bottlenecks, or when user mentions memory optimization, performance tuning, cost reduction, slow queries, caching, or Mem0 optimization.

RAG (Retrieval Augmented Generation) implementation patterns including document chunking, embedding generation, vector database integration, semantic search, and RAG pipelines. Use when building RAG systems, implementing semantic search, creating knowledge bases, or when user mentions RAG, embeddings, vector database, retrieval, document chunking, or knowledge retrieval.

A skill for implementing robust API request validation in Python web frameworks like FastAPI using Pydantic. Covers Pydantic models, custom validators (email, password), field-level and cross-field validation, query/file validation, and structured error responses. Use when you need to validate incoming API requests.

Use when working with Notion databases, creating/updating pages, querying data, syncing between systems, or building knowledge management workflows

V1.0 - Supabase database management, security fixes, and advisor issue resolution for the Dashboard project.

TanStack Query v5 patterns for data fetching, caching, and server state management. Use when working with useQuery, useMutation, useSuspenseQuery, query invalidation, cache management, or React Query patterns.

Create Supabase database migrations. Use when user says "add table", "create migration", "update schema", "add column", "database change", or asks to modify the database.

Master database design and management. Learn SQL, PostgreSQL, MongoDB, Redis, data modeling, performance optimization, replication, and blockchain technology.

Database migration management for SQLAlchemy projects using Alembic

Frontend development guidelines for React/TypeScript applications. Modern patterns including Suspense, lazy loading, useSuspenseQuery, file organization with features directory, MUI v7 styling, TanStack Router, performance optimization, and TypeScript best practices. Use when creating components, pages, features, fetching data, styling, routing, or working with frontend code.