Databases

Automatic cache invalidation system với Laravel Observers và Next.js On-Demand Revalidation. Tự động sync data real-time giữa backend và frontend khi admin update. USE WHEN cần setup cache management, sync frontend-backend, API cache strategy, hoặc user phàn nàn "phải Ctrl+F5 mới thấy data mới".

FastAPI backend development with SQLAlchemy 2.0, Pydantic v2, and async Python. Use for API endpoints, database models, migrations, authentication, and background tasks.

Gestion du projet MyGGV GPS dans Archon. Utiliser pour la documentation, les tâches, la recherche dans la knowledge base (Supabase docs, MapLibre docs, etc.), et le suivi de projet.

Database management with Prisma (schema, migrations, optimization). TRIGGERS: 'Prisma', 'schema', 'migration', 'database', 'query optimization', 'modelo de dados'. Use when modifying database schema, creating migrations, optimizing queries, troubleshooting database issues, data modeling.

Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and distributed systems integration. Use when building distributed AI systems, multi-agent coordination, or advanced vector search applications.

Define database models and schemas with proper data types, constraints, relationships, and validation rules for PostgreSQL (Supabase/Bun.sql) and Firestore (Firebase). Use this skill when creating or modifying database models, ORM entity definitions, Prisma schemas, or Firestore document structures. Apply when working on model files (models/*.ts, entities/*.ts, schema.prisma, models/*.py, Models/*.cs), defining database relationships, setting up validation rules, or implementing data integrity constraints. This skill ensures snake_case naming for SQL and camelCase for NoSQL, required timestamps (created_at/updated_at), UUIDs for SQL and auto-generated IDs for Firestore, foreign key constraints with indexed columns, Row Level Security (RLS) policies for Supabase, strict Firestore security rules, normalized data for SQL (3NF) with denormalization for Firestore read performance, and pgvector setup for AI embeddings.

Build robust backend systems with modern technologies (Node.js, Python, Go, Rust, .NET), frameworks (NestJS, FastAPI, Django, ASP.NET Core), databases (PostgreSQL, MongoDB, Redis), APIs (REST, GraphQL, gRPC, Minimal APIs), authentication (OAuth 2.1, JWT), testing strategies, security best practices (OWASP Top 10), performance optimization, scalability patterns (microservices, caching, sharding), DevOps practices (Docker, Kubernetes, CI/CD), and monitoring. Use when designing APIs, implementing authentication, optimizing database queries, setting up CI/CD pipelines, handling security vulnerabilities, building microservices, or developing production-ready backend systems.

Expert Rust code review agent that analyzes Rust code for correctness, safety, idiomatic patterns, performance, and best practices. Use when reviewing Rust code files (.rs), providing feedback on Rust projects, checking for unsafe code patterns, evaluating borrow checker compliance, suggesting idiomatic improvements, or conducting thorough code quality assessments for Rust codebases.

Research-driven Cube semantic layer development. Injects research steps for data modeling, dbt integration, metrics, dimensions, REST API, GraphQL API, and SQL API (Postgres wire protocol). Use when building semantic layer, consumption APIs, metrics layer, Cube integration tests, or working with Cube MEASURE() syntax and psycopg2 connections.

Comprehensive pytest skill for async Python testing with proper mocking, fixtures, and patterns from production-ready test suites. Use when writing or improving async tests for Python applications, especially FastAPI backends with database interactions.

Migrate from Prisma 5 to Prisma 6 handling breaking changes including Buffer to Uint8Array, implicit m-n PK changes, NotFoundError to P2025, and reserved keywords. Use when upgrading Prisma, encountering Prisma 6 type errors, or migrating legacy code.

Explore external reference source code to understand implementations, draw inspiration, debug issues, or answer questions. Use when exploring repos like InstantDB, Trigger.dev, Vercel AI SDK, HeroUI Native, or any external codebase. Handles two modes - "inspiration" (adaptive, translating concepts to user's stack) or "understanding" (direct, definitive answers about the source). Always cite file:line references.

Configure and debug WebF runtime caching in Flutter using HttpCacheMode (stale content, offline-first, cache busting, clearing caches with WebF.clearAllCaches). Use when the user mentions HttpCacheMode, WebF.clearAllCaches, offline-first, stale remote bundles, or cache adapter behavior.

Expert UI/UX designer who evaluates and improves user interfaces, creates design mockups, and ensures professional, accessible designs. Use when designing new features, improving existing UI, or getting design feedback. Follows modern design principles and accessibility standards.

Plans and executes data migrations between systems, databases, and formats

Build Next.js 16 applications with correct patterns and distinctive design. Use when creatingpages, layouts, dynamic routes, upgrading from Next.js 15, or implementing proxy.ts. Coversbreaking changes (async params/searchParams, Turbopack, cacheComponents) and frontend aesthetics.NOT when building non-React or backend-only applications.

Systematic approach to diagnose and resolve backend service issues including dependency conflicts, database schema mismatches, import errors, and middleware configuration problems in FastAPI applications.

Security-first WordPress development with nonces, sanitization, validation, and escaping to prevent XSS, CSRF, and SQL injection vulnerabilities.

Clean temporary files, caches, and build artifacts.LOAD THIS SKILL WHEN: User says "清理", "clean", "刪除暫存", "清除快取" | disk space issues | before archiving | end of workflow.CAPABILITIES: Python cache (__pycache__, .pytest_cache), Node.js (dist, .cache), safe deletion with confirmation, protected files list.

Expert guide for real-time features using Supabase Realtime, WebSockets, live updates, presence, and collaborative features. Use when building chat, live updates, or collaborative apps.