資料庫

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.

Manage SQL Server database connections with ADODB, connection pooling, and retry logic. Use this skill for robust database connectivity in the extraction pipeline.

Use when processing code review feedback. Technical evaluation of feedback, verify before implementing. No performative agreement or gratitude.

Translation Manager for this repo: Supabase-backed translations, admin UI under /admin/translation-manager with Home live preview and click-to-select translation, Edge Functions (translations-get/admin/suggest), build-time translation pipeline, and security hardening. Use when planning or editing translation manager UI, Supabase schema/migrations, translation scripts (seed/pull), Edge Functions, translation auth, or troubleshooting translation data/AI suggestions.

Master NoSQL databases: MongoDB, Redis, DynamoDB, and more.

TanStack Query setup for data fetching and caching. Use when implementing server state management.

Comprehensive backend development guide for Node.js/Express/TypeScript microservices. Use when creating routes, controllers, services, repositories, middleware, or working with Express APIs, Prisma database access, Sentry error tracking, Zod validation, unifiedConfig, dependency injection, or async patterns. Covers layered architecture (routes → controllers → services → repositories), BaseController pattern, error handling, performance monitoring, testing strategies, and migration from legacy patterns.

Record project activity, decisions, and outputs; query history and status. Provides institutional memory across sessions.

Personal knowledge base for Shapira family daily life. Use when querying or storing information about hotels, swim meet venues, travel logistics, restaurants, service providers, or any location-based preferences. Triggers on phrases like "remember this hotel", "where did we stay", "next time in [city]", "log this location", or references to past stays/visits.

Prisma 5+ ORM with schema-first design, type-safe client, migrations, and database integrations (Supabase, PlanetScale, Neon). Use for TypeScript/JavaScript database access.

Guide for working with newsletter campaigns, RSS processing workflows, article generation, MailerLite integration, multi-tenant isolation, campaign status management, Vercel workflows, advertorial rotation, and publication automation. Use when creating campaigns, processing RSS feeds, generating articles, managing workflow steps, handling campaign statuses, or working with newsletter-related database operations.

SQL Specialist for BigQuery SQL statement implementation including ad-hoc analysis, materialized views, and data preparation. Use when generating or modifying BigQuery SQL code.

Export query results to various formats (CSV, JSON, Excel, Markdown tables) with proper formatting and headers. Use when saving analysis results to files.This skill provides data export utilities for multiple formats:- CSV: Comma-separated with headers, customizable delimiters- JSON: Structured data with pretty-print option- Excel: Multiple sheets, cell formatting, formulas- Markdown: Tables for documentationTriggers: "export data", "save results", "output CSV", "output JSON", "output Excel", "データ出力", "結果保存", "エクスポート"