Databases

Use when building reusable PyPI package with pgdbm - provides complete pattern for libraries that work standalone or embedded without needing examples

Database optimization, security audit, and performance analysis for MyDetailArea Supabase/PostgreSQL. Provides safe query optimization, RLS policy review, index recommendations, and migration strategies with extreme caution and rollback plans. Use when optimizing database performance, auditing security, or creating safe migrations. CRITICAL - All recommendations require validation and testing before production.

Full-stack development expertise covering backend, frontend, database, DevOps, and testing domains

Build and execute WIQL (Work Item Query Language) queries for Azure DevOps. Use when the user wants to query work items, find bugs, list tasks, search by assignee, filter by state, find items in a sprint, or build custom work item queries. Use when user mentions "query", "find work items", "list bugs", "my tasks", "assigned to", "in sprint", or "WIQL".

Managing Claude Code Session Memory & Context. Understand session context limits, use just-in-time retrieval, cache insights, manage memory files. Use when optimizing context usage, handling large projects, or implementing efficient workflows.

Writes, edits, and creates dbt models following best practices. Use when user needs to create new dbt SQL models, update existing models, or convert raw SQL to dbt format. Handles staging, intermediate, and mart models with proper config blocks, CTEs, and documentation.

Comprehensive backend development guide for Python/FastAPI/SQLAlchemy applications. Use when creating routes, services, models, schemas, database operations, or working with FastAPI endpoints, SQLAlchemy/Alembic migrations, Pydantic validation, error handling, dependency injection, or async patterns. Covers layered architecture (routes → services → repositories → models), separation of concerns, error handling, performance, testing strategies, and best practices.

Sets up a new Django project with RAPID architecture using uv. Creates horizontal layer structure with DRF, Docker/PostgreSQL support, and environment-based configuration. Use when the user wants to initialise a Django web application.

Complete Java Spring Boot skill set for building enterprise applications.Includes modular architecture with optional components:- PostgreSQL database with JPA/Hibernate + Flyway migration- Redis caching (optional)- Kafka/RabbitMQ messaging (optional, choose one)- JWT + OAuth2 authentication (optional OAuth2)- RBAC authorization (optional)- TDD with Mockito- Spec-First Development with OpenSpec

Multi-tenant architecture patterns including org_id claim management, JWT token structure with organization context, database isolation strategies for MongoDB and PostgreSQL, theme switching per organization, tenant provisioning workflows, data isolation patterns, and cross-tenant security. Activate for multi-tenancy implementation, tenant isolation, and organization-scoped data access.

Query and manage local Convex documentation mirror (42 docs). Search Convex topics for real-time database, serverless functions, authentication, file storage, and React hooks. Use when implementing Convex backend features or answering Convex-related questions. (user)

Use when receiving code review feedback, before implementing suggestions, especially if feedback seems unclear or technically questionable - requires technical rigor and verification, not performative agreement or blind implementation

Next.js 16 specific features, breaking changes, and migration guide. Use when upgrading from Next.js 15, implementing Cache Components with "use cache", working with Turbopack, or handling the new async request APIs. Released October 2025 with fundamental caching model changes.

Provides expert-level assistance with dbt Semantic Layer, MetricFlow, semantic models, metrics, dimensions, entities, measures, and BI tool integrations. Use this skill when building semantic models, creating metrics (simple, ratio, cumulative, derived, conversion), debugging validation errors, or integrating with BI tools. Extracted from official dbt documentation and optimized for data practitioners.

Generate realistic fake data from JSON schemas, producing 1-50 valid records that conform exactly to the schema. Use when creating sample datasets from schema definitions, populating test databases, or generating example API responses. Returns only valid JSON that passes schema validation.

Complete CodeRabbit feedback processing workflow - query findings, apply fixes, resolve conversations with multi-account/org support

Expert in designing SQLModel schemas and managing Neon PostgreSQL databases. Use this when defining data models, handling relationships, or performing database migrations.

Analyses and optimises performance across frontend, backend and database interactions. Identifies bottlenecks and implements solutions to enhance speed and efficiency.

Zenless 프로젝트 개발 환경을 중지하는 스킬. 사용자가 "프로젝트 중지", "서버 중지", "개발 환경 종료" 등을 요청할 때 사용. 백그라운드에서 실행 중인 백엔드와 프론트엔드 프로세스를 종료하고, PostgreSQL 컨테이너를 중지함. (project)

Write efficient and secure database queries using parameterized statements, preventing SQL injection, and optimizing performance through proper indexing and eager loading. Use this skill when writing database queries, ORM query methods, SQL statements, or repository pattern implementations. Use this skill when optimizing query performance, preventing N+1 query problems, implementing transactions for data consistency, or adding query timeouts and caching strategies. Use this skill when working with SELECT statements, JOIN operations, WHERE clauses, or any code that interacts with the database to fetch or manipulate data. Use this skill when working with files in repositories/, queries/, services/, or data access layers that contain database query logic.