Database

Few-shot example prompting to guide model behavior through demonstration

Multi-step prompt chains that decompose complex tasks into sequential LLM calls

RAG prompt patterns for grounding model responses in retrieved context documents

Role and persona prompting to shape model expertise, tone, and perspective

Techniques for reliably extracting structured JSON and typed data from language models

System prompt design for establishing persistent model behavior and constraints

Svelte component composition patterns including props, snippets, context, and advanced reuse techniques

SvelteKit form actions for progressive enhancement with server-side form handling

SvelteKit server and universal load functions for fetching and passing data to pages and layouts

Svelte 5 runes system for fine-grained reactivity with $state, $derived, and $effect

Svelte stores and state management patterns including writable, readable, derived, and custom stores

Authentication patterns in SvelteKit using hooks, cookies, sessions, and OAuth flows

SvelteKit file-based routing system including layouts, groups, and advanced route patterns

Svelte transitions and animations for smooth enter/exit effects and layout changes

Building reusable custom composables in Vue 3 with proper typing, lifecycle management, and state sharing

Patterns and best practices for Vue 3 Composition API including refs, reactive, computed, watchers, and lifecycle hooks

Nuxt 3 file-based routing, dynamic routes, layouts, middleware, and navigation patterns

Nuxt 3 server routes, API endpoints, server middleware, and Nitro engine patterns for full-stack development

Pinia state management for Vue 3 including store design, actions, getters, plugins, and SSR hydration

Vue 3 provide/inject for dependency injection, deeply nested component communication, and plugin design

Vue Router 4 advanced patterns including navigation guards, lazy loading, scroll behavior, and typed routes

Vue 3 component testing with Vitest and Vue Test Utils covering unit tests, integration tests, and async patterns

Testing Angular applications with Jest for unit tests and Cypress for end-to-end tests

Angular dependency injection system including providers, injection tokens, and hierarchical injectors

Reactive forms, form validation, dynamic forms, and typed form controls in Angular

NgRx state management with store, effects, selectors, and the component store

Angular Router configuration including lazy loading, guards, resolvers, and nested routes

RxJS reactive patterns for data fetching, state management, and event handling in Angular

Angular Signals for fine-grained reactivity and efficient change detection

Standalone components, directives, and pipes for module-free Angular development

Celery patterns for distributed task queues, scheduling, retries, and worker management

Django admin customization patterns for list views, forms, inlines, actions, and permissions

Django ORM patterns for models, querysets, migrations, and database optimization

Django REST Framework patterns for building, serializing, and securing RESTful APIs

FastAPI patterns for async APIs, dependency injection, Pydantic models, and OpenAPI integration

Flask application patterns for routing, blueprints, extensions, and application factories

WebSocket patterns for real-time communication using FastAPI, Django Channels, and the websockets library

SQLAlchemy ORM and Core patterns for models, sessions, queries, and async database access

Application monitoring, health checks, metrics, and observability with Spring Boot Actuator and Micrometer

Batch processing with Spring Batch including jobs, steps, chunk processing, readers, writers, and job scheduling

Core Spring Boot concepts including auto-configuration, starters, dependency injection, and application lifecycle

Microservices architecture with Spring Cloud including service discovery, API gateway, circuit breakers, and distributed configuration

Data persistence with Spring Data JPA including repositories, entity mapping, queries, and transaction management

Authentication, authorization, and security configuration with Spring Security including JWT, OAuth2, and method-level security

Testing patterns for Spring Boot applications including unit tests, integration tests, sliced tests, and test containers

Reactive programming with Spring WebFlux including Mono, Flux, non-blocking I/O, and reactive data access

Common Table Expressions and recursive queries for hierarchical data, graph traversal, and complex query composition

Index types, design strategies, and maintenance for optimal query performance in relational databases

JSON storage, querying, indexing, and manipulation in PostgreSQL and MySQL for semi-structured data

Database schema migration strategies for safe, reversible, and zero-downtime changes to production databases

Use this skill when working with PostgreSQL specifically. Activate when users mention postgres, postgress, postgresql, psql, EXPLAIN ANALYZE, VACUUM, autovacuum, bloat, WAL, connection pooling with pgbouncer, JSONB, partitioning, logical replication, RLS, or when they need Postgres-specific tuning, migration safety, or incident diagnosis.

Techniques for analyzing and optimizing SQL query performance using execution plans, statistics, and query rewrites

Stored procedures, functions, and triggers for encapsulating business logic and automating actions within the database

Transaction management, ACID properties, isolation levels, and concurrency control in relational databases

SQL window functions for analytics, ranking, and running calculations over partitioned result sets

Disk partitioning, filesystems, LVM, RAID, mount management, and storage monitoring on Linux

Linux file permissions, ownership, special bits, ACLs, and file attribute management

Log management with journalctl, rsyslog, logrotate, and centralized logging strategies on Linux

Linux networking tools including ss, ip, iptables, nftables, and diagnostic utilities

Process lifecycle, monitoring, signals, cgroups, and performance analysis on Linux systems