Prompts

SQL Stored Procedure Design

Design maintainable stored procedures and functions with proper error handling, testing patterns, and clear boundaries between DB and app logic.

SQL JSON/JSONB Operations

Query, index, and manipulate JSON/JSONB data in SQL databases effectively while maintaining query performance and data integrity.

SQL Analytical Queries

Build analytical SQL for cohort analysis, funnel metrics, retention curves, and time-series aggregations used in product and business intelligence.

SQL Safe Migration Patterns

Execute schema migrations safely with zero-downtime techniques, backward compatibility, and rollback strategies for production databases.

SQL Data Integrity Constraints

Enforce data correctness at the database level using constraints, triggers, and domain types so invalid data can never enter the system.

SQL Index Strategy

Design optimal index strategies using B-tree, partial, composite, covering, and expression indexes to accelerate queries without bloating writes.

SQL Transaction Design

Design correct, safe transactions with proper isolation levels, locking strategies, and deadlock prevention for concurrent database access.

SQL Window Functions Mastery

Master window functions for ranking, running totals, moving averages, and gap analysis without collapsing rows like GROUP BY.

SQL Query Performance

Diagnose and fix slow SQL queries using EXPLAIN plans, index analysis, query rewriting, and statistics-aware optimization techniques.

SQL Query Design Patterns

Write clean, maintainable SQL queries using CTEs, proper joins, subquery patterns, and set-based thinking instead of procedural workarounds.

Swift Performance Optimization

Profile and optimize Swift code for speed and memory using Instruments, compiler flags, and data structure choices backed by benchmarks.

Swift Generics & Type System

Master Swift generics with constrained types, opaque returns, primary associated types, and conditional conformances for type-safe abstractions.

Swift Error Handling Patterns

Design robust error handling using typed throws, Result types, and recovery strategies that make failure modes explicit and recoverable.

Swift Test Design

Build reliable, fast, and maintainable test suites using XCTest and Swift Testing with proper isolation, mocks, and assertion patterns.

Swift Memory Management

Eliminate retain cycles, reduce allocations, and manage object lifetimes correctly using ARC, weak/unowned references, and value semantics.

Swift Protocol-Oriented Design

Design flexible, composable Swift systems using protocols, associated types, protocol extensions, and existentials instead of deep class hierarchies.

Swift Concurrency (async/await)

Design correct, performant concurrent Swift code using structured concurrency, actors, async/await, and task groups without data races.

Idiomatic Swift Code

Write Swift code that follows Apple conventions, leverages value types, and uses the language features the way they were designed to be used.

JVM Reactive Programming

Design reactive JVM applications using Project Reactor, RxJava, or Kotlin Flow with proper backpressure and error handling.

JVM Dependency Injection

Design dependency injection for JVM applications using Spring, Dagger, Koin, or manual wiring with proper scoping and testing.

Kotlin DSL Design

Design type-safe Kotlin DSLs using lambda-with-receiver, builder patterns, and scope control with DslMarker.

Kotlin Coroutines Patterns

Design structured concurrent Kotlin programs using coroutines, flows, channels, and proper cancellation handling.

Idiomatic Kotlin Code

Write clean, idiomatic Kotlin using null safety, extension functions, data classes, scope functions, and Kotlin conventions.

Java Streams & Functional

Master Java Streams API with proper collector design, parallel streams, and functional patterns for data processing.