Skills

Designs and scaffolds AI agent architectures including tool definitions, system prompts, memory strategies, and orchestration logic. Supports multi-agent workflows, ReAct patterns, function calling schemas, and MCP server configurations. Helps structure agents that are reliable, observable, and easy to debug.

Analyzes SQL queries and database schemas to identify performance bottlenecks and suggest optimizations. Recommends index strategies, query rewrites, denormalization opportunities, and partitioning schemes. Explains EXPLAIN plans and provides before/after comparisons with expected performance improvements.

Plans and generates migration strategies for framework upgrades, language versions, database changes, and architecture shifts. Produces step-by-step migration guides with rollback plans, risk assessment, and automated codemods where possible.

Contract-first yaklaşımıyla RESTful ve GraphQL API'leri tasarlar. Endpoint yapısını, istek ve yanıt şemalarını, hata yönetimini, sürümlemeyi, pagination'ı, kimlik doğrulamayı ve rate limiting'i kapsar. OpenAPI/Swagger spesifikasyonları ve uygulama iskeletleri üretir.

Translates code between programming languages while preserving logic, idioms, and best practices of the target language. Handles differences in type systems, error handling, concurrency models, and standard library APIs. Produces idiomatic target code, not line-by-line transliteration.

Performs comprehensive security analysis of code and configurations. Identifies OWASP Top 10 vulnerabilities, insecure patterns, missing input validation, authentication flaws, and secrets exposure. Provides remediation steps with secure code examples.

Designs normalized database schemas from business requirements. Covers entity relationships, indexing strategies, migration planning, and performance considerations. Supports PostgreSQL, MySQL, MongoDB, and other databases with dialect-specific optimizations.

Designs, optimizes, and iterates on prompts for LLM applications. Covers system prompt design, few-shot examples, chain-of-thought reasoning, output formatting, and prompt testing strategies. Helps build reliable AI-powered features.

Identifies and resolves performance bottlenecks in code and systems. Covers algorithmic complexity analysis, memory optimization, caching strategies, database query tuning, and frontend performance (Core Web Vitals). Follows a measure-first approach.

Guides systematic code refactoring while preserving exact behavior. Identifies code smells, suggests appropriate refactoring patterns, and executes transformations incrementally with verification at each step. Follows Chesterton's Fence principle — understands why code exists before changing it.