Databases

Database migration toolkit for Supabase projects. Use when: (1) Creating new migration files, (2) Writing schema changes (CREATE TABLE, ALTER, etc.), (3) Adding indexes, triggers, or RLS policies, (4) Fixing RLS performance issues (auth function wrapping, policy consolidation), (5) Validating migration conventions, (6) Running migrations locally, (7) Naming database objects

Implements Supabase Authentication with email, OAuth, magic links, and phone auth. Use when building apps with Supabase, needing auth integrated with Row Level Security, or implementing passwordless login.

Query active USGS stream gauges using the USGS Water Services API. Returns stream gauge locations and metadata as a GeoDataFrame with current status information.

Use when the user asks to review code or a pull request - performs focused review checking for obvious defects only, provides minimal feedback with clear approval/rejection format

Proactive skill for validating dbt models against coding conventions. Auto-activates when creating, reviewing, or refactoring dbt models in staging, integration, or warehouse layers. Validates naming, SQL structure, field conventions, testing coverage, and documentation. Supports project-specific convention overrides and sqlfluff integration.

提供v3_metadata数据库的SQL查询模板，包括对象编码（object_code）、对象名称、事件、按钮配置、自定义字段、元数据字段、插件中心等表的查询。查询对象编码、对象名称、自定义对象时使用。使用 exec_sql 工具执行查询。

Architecture decision guides for Kailash SDK including framework selection (Core SDK vs DataFlow vs Nexus vs Kaizen), runtime selection (Async vs Sync), database selection (PostgreSQL vs SQLite), node selection, and test tier selection. Use when asking about 'which framework', 'choose framework', 'which runtime', 'which database', 'which node', 'architecture decision', 'when to use', 'Core SDK vs DataFlow', 'PostgreSQL vs SQLite', 'AsyncLocalRuntime vs LocalRuntime', or 'test tier selection'.

Prisma ORM for TypeScript - Type-safe database toolkit with schema-first development, auto-generated client, migrations, relations, and Prisma Studio. Use when building Node.js or Next.js apps requiring database access with full type safety, complex relations, transactions, or when both development tools (Studio) and production performance are needed.

Load when creating sales outreach emails, negotiation scripts, follow-upsequences, or any sales-related communication. Contains templates andbest practices for professional sales communication.

Build Retrieval-Augmented Generation (RAG) systems for LLM applications with vector databases and semantic search. Use when implementing knowledge-grounded AI, building document Q&A systems, or integrating LLMs with external knowledge bases.

Transform Bronze layer data using DuckDB for joins, aggregations, and business logic. Use this skill for high-performance data transformations in the pipeline.

Rust/WASM backend in api-rust/. High-performance alternative using workers-rs, utoipa for OpenAPI, and Supabase REST API. Port 9999 for local dev. 10-100x faster than Python.

Essential fuzzing payloads: SQL injection, command injection, special characters. Curated essentials for vulnerability testing.

補助金ナビ開発スキル。JグランツAPI連携、Supabase操作、補助金データ処理のベストプラクティス。使用タイミング: (1) JグランツAPIからデータ取得 (2) 補助金データのDB保存・検索 (3) HTMLフィールドの処理 (4) Slack通知実装

Database insertion via Prisma for MenFem content. Use when inserting articles, companies, culture picks, events, product reviews, explore features, or exchange listings into the database through conversational propose-approve-insert workflow. Trigger phrases include "insert article", "add to database", "create in prisma", "seed the database", or "populate the site".

Facilitate a cross-functional design review capturing decisions, feedback, and implementation guidance.

Migrate and sync vector database collections across environments

S16Z PMS shared library development skill. Use when creating or maintaining shared libraries in the libs/ directory. Covers configuration management with registerAs, DTO validation with class-transformer, HTTP client patterns with BaseHttpClient, Prisma transaction handling, and testing strategies. Triggers when working with libs/ directory, creating new libraries, implementing API clients, or setting up shared services.

Build tiered fallback systems that degrade performance, not availability. Cache layers, API resilience, and automatic failover patterns for platform reliability.

Supabaseのクエリ、RLSポリシー、マイグレーション作成を支援。データベース操作、認可設定、Supabase関連の実装時に使用。