Database

Adding search functionality to applications including full-text search, Elasticsearch/Algolia/Meilisearch patterns, indexing strategies, relevance tuning, and autocomplete.

Handling secrets and credentials safely throughout the development lifecycle

Security considerations during code generation — avoiding injection vulnerabilities, secrets management, input validation, safe defaults, recognizing insecure patterns, and OWASP top 10 awareness.

How to detect, diagnose, and recover from mistakes during autonomous execution without cascading failures

Finding code by meaning and concept rather than exact text matches

Building serverless applications with Lambda/Cloud Functions, including cold start optimization, event-driven design, state management, and deployment automation.

Managing sessions and cookies correctly including cookie attributes, session stores, security hardening, consent handling, and token-based alternatives.

Executing shell commands safely and effectively, including proper quoting, exit code handling, avoiding destructive operations, and cross-platform compatibility.

Correctly interpreting user requirements by reading between the lines, identifying gaps, and building accurate mental models of intent

Writing efficient SQL queries — index design, EXPLAIN analysis, join optimization, CTEs vs subqueries, pagination techniques, aggregate optimization, parameterized queries, and connection pooling.

Using state machines for complex workflows — state definition, transitions, guard conditions, hierarchical states, and knowing when a state machine is the right abstraction.

Maintaining coherent progress and context across context window boundaries and separate agent sessions

Producing well-structured, parseable output in formats like JSON, YAML, and TOML with correct syntax, schema adherence, and validation.

Pushing back on bad ideas instead of blindly executing user requests that will cause problems

Building performant data tables and lists with virtualization, sorting, and responsive patterns

How to break complex tasks into atomic subtasks with dependency awareness, scope estimation, and ambiguity handling

Identifying, quantifying, and communicating technical debt with actionable remediation plans

Using tests to drive autonomous development through red-green-refactor cycles, leveraging test failures as navigation signals, and building confidence through coverage.

Writing effective tests autonomously — test structure (arrange-act-assert), choosing what to test, edge cases, mocking strategies, integration vs unit decisions, test naming, avoiding brittle tests, and testing error paths.

Choosing the right tool for each subtask based on cost-benefit analysis, parallelization opportunities, and thoroughness calibration

Leveraging type systems effectively across languages including TypeScript, Python, Go, and Rust for safer, more expressive, and self-documenting code.

Advanced TypeScript patterns for agents — generic types, conditional types, mapped types, discriminated unions, type guards, utility types, declaration files, strict mode, and module resolution.

Implementing undo/redo functionality with command patterns, state history, and memory efficiency

Implementing URL routing in web applications with RESTful design and modern patterns

Effective web research techniques including query formulation, source evaluation, cross-referencing, and synthesizing findings into actionable intelligence.

Implementing and consuming webhooks with endpoint security, signature verification, idempotency handling, retry logic, payload validation, and dead letter queues.

Real-time communication with WebSockets including connection lifecycle, reconnection strategies, heartbeat patterns, room/channel design, scaling, authentication, and graceful disconnection handling.

Working with YAML and TOML configuration formats including multiline strings, anchors, TOML tables, comment preservation, common YAML gotchas, and format selection guidance.