Databases

Supabase RLS パフォーマンス最適化。セキュリティ境界と最適化フィルタの区別、および堅牢な関数定義を規定。

A skill for managing database migrations with Alembic. Use this for tasks involving Alembic initialization, configuration, creating new migration scripts (both autogenerated and manual), defining upgrade and downgrade logic, handling data migrations, testing migrations, performing rollbacks, and following production deployment best practices for database changes.

Development skill for CaseMark's Court Recording Transcriber - an AI-powered application for transcribing court recordings with speaker identification, synchronized playback, search, and legal document exports. Built with Next.js 16, PostgreSQL, Drizzle ORM, wavesurfer.js, and Case.dev APIs. Use this skill when: (1) Working on or extending the court-record-transcriber codebase, (2) Integrating with Case.dev transcription APIs, (3) Working with audio playback/waveforms, (4) Building transcript export features, or (5) Adding speaker identification logic.

Use when implementing game animations, player feedback, character movement, or interactive entertainment in Unity, Unreal, or other game engines.

Database normalization for CSV files. Analyzes data structure, detects functional dependencies, and decomposes into normalized tables (1NF-BCNF). Outputs multiple CSV files, SQL DDL, and Mermaid ERD. Use when: (1) converting flat CSV data into relational database schema, (2) reducing data redundancy, (3) preparing denormalized exports for database import, (4) user mentions "normalize", "1NF/2NF/3NF/BCNF", "functional dependencies", or "database design".

Expert system for investigating CockroachDB test failures, especially KV failures.

Use macOS text-to-speech via the `say` command for voice feedback, audio narration, and spoken output.

Generate Prisma schema files with models, relations, enums, and database configuration for TypeScript ORM setup. Triggers on "create Prisma schema", "generate Prisma model", "prisma.schema for", "database schema Prisma".

Neon serverless Postgres with autoscaling, instant database branching, and zero-downtime deployments. Use when building serverless applications, implementing database branching for dev/staging, or deploying with Vercel/Netlify.

Validate Laravel database configuration and test actual connections. Use when user reports "database connection error", "hosts array is empty", "could not connect to database", or wants to verify database setup is correct.

Design database schemas for PostgreSQL, Neon, Convex, or Supabase. Use when users need to create tables, define relationships, plan migrations, optimize indexes, or implement data models. Covers normalization, denormalization strategies, and platform-specific features.

Turn the model into a SQLAlchemy-focused Python coding agent for designing models, writing queries, debugging database issues, and integrating SQLAlchemy with Alembic and FastAPI in new or existing Python projects.

This skill should be used when the user asks to "create MongoDB model", "define Beanie document", "write MongoDB query", "create aggregation pipeline", "run database migration", "index MongoDB collection", or mentions Beanie, Motor, MongoDB documents, or async database operations. Provides MongoDB/Beanie ODM patterns for FastAPI.

Write Python code to interact with ClickHouse using clickhouse-connect. Use when creating ETL scripts, data pipelines, analytics applications, or any Python code that needs to query or insert data into ClickHouse.

Create new database tables with Drizzle ORM schemas and Valibot validation. 使用 Drizzle ORM 创建新的数据库表模式和 Valibot 验证。 Use when: - Adding new database tables - Creating entity schemas - User mentions "new table", "database schema", "add entity", "新增表", "数据库模式"

Solo RPG mechanical tools for dice rolling, tarot draws, oracles, name generation, character/location/memory management, and story retrieval. Use when the user asks to roll dice, draw tarot cards, consult oracles, generate names, load characters or locations, track memories, or pull from story collections during RPG sessions.

Use when creating or editing marimo reactive Python notebooks. Covers cell structure, UI elements (mo.ui), reactivity, SQL integration, markdown, and deployment as apps. Triggers on .py notebook creation, marimo edit/run commands, reactive notebook development, or interactive data exploration. Extends python-development skill.

Supabase database query patterns, RLS policies, migration records, and nested join patterns. Use this skill when writing database queries, understanding RLS behavior, debugging query errors, or implementing new migrations.

Background jobs with PgBoss for Wasp applications. Use when implementing async tasks, scheduled jobs, email queues, or background processing. Requires PostgreSQL database.

Master microbiome data operations across Supabase, Neo4j, Upstash Vector, and Redis. Generates comprehensive BrilliantBiome reports with BrilliantScore calculations, species analysis, AMR assessments, and population insights. Use when querying microbiome data, generating reports, analyzing taxonomic relationships, or performing similarity searches across the two-lane architecture (clinical + research).