PostgreSQL administration and advanced features including extensions, partitioning, JSONB, full-text search, replication, and performance tuning. Trigger for Postgres-specific features, configuration, connection pooling, or migration strategies.
Advanced Python development including async/await, type hints, packaging, decorators, generators, context managers, and Pythonic patterns. Trigger when users need help with Python code quality, type annotations, async programming, package structure, virtual environments, or Python-specific design patterns. Also…
Expert-level React development including React 19, Server Components, hooks composition, state management, and performance optimization. Trigger when the user asks to build, debug, or optimize React components, implement custom hooks, manage complex state, work with RSC/Suspense/streaming, or fix React performance…
Rust systems programming including ownership, lifetimes, async/await, traits, unsafe code, FFI, and zero-cost abstractions. Trigger when users write Rust code, fight the borrow checker, design trait hierarchies, implement async Rust, or need help with Rust error handling and pattern matching.
Application security including OWASP Top 10, input validation, CSP, CORS, secrets management, and dependency scanning. Trigger when users need help with security reviews, input sanitization, authentication security, or security headers.
Shell scripting including Bash best practices, error handling, process management, and task automation. Trigger for shell script writing, Bash debugging, or CLI tool development.
SQL query optimization including EXPLAIN analysis, index strategies, window functions, CTEs, query rewriting, and performance tuning. Trigger when users have slow queries, need help reading EXPLAIN output, want index recommendations, or need to write complex analytical queries with window functions or CTEs.
Svelte and SvelteKit development including runes, reactive declarations, stores, transitions, and SvelteKit routing. Trigger for Svelte component development or SvelteKit application architecture.
Tailwind CSS including design systems, custom plugins, responsive patterns, dark mode, and component styling. Trigger for Tailwind configuration, custom utility creation, or Tailwind-based UI development.
Terraform infrastructure as code including modules, state management, workspaces, providers, and best practices. Trigger when users write Terraform configs, manage cloud infrastructure, need help with state management, or design reusable modules.
Testing strategies including unit tests, integration tests, E2E tests, mocking, coverage analysis, and TDD workflow. Trigger when users need help writing tests, choosing testing frameworks, implementing mocking strategies, or setting up test infrastructure.
Advanced TypeScript development including generics, conditional types, template literal types, mapped types, decorators, and type-level programming. Trigger when the user needs help with complex type definitions, generic constraints, type inference issues, type narrowing, discriminated unions, or TypeScript compiler…
Vue.js development including Composition API, Pinia, Nuxt 3, Vue Router, and reactivity system patterns. Trigger when users build Vue applications or need help with Vue-specific patterns.
WebSocket and real-time communication including Socket.IO, scaling, presence, rooms, and reconnection strategies. Trigger for real-time features, WebSocket implementation, or Socket.IO patterns.