Coding Prompts

Kubernetes NetworkPolicy for Zero-Trust with Observability

This prompt guides platform and security engineers in generating Kubernetes NetworkPolicy manifests. It ensures a zero-trust security posture across multiple namespaces while explicitly preserving crucial observability traffic. The output includes K8s YAML, Helm/Kustomize guidance, and a deployment strategy.

Secure, Compact Multi-Stage Docker for Node.js APIs

Craft a secure, lightweight multi-stage Dockerfile for Node.js APIs, targeting sub-150MB images on a distroless base. This solution provides a Dockerfile, Docker Compose setup, and essential notes on build, runtime, security, and image size optimization, helping engineers ship production-ready services efficiently.

Optimize Docker Images: Reduce 1.2GB to under 150MB for CI/CD

This guide helps platform engineers optimize Docker images, shrinking them from 1.2GB to under 150MB. It provides a detailed process to achieve significant size reduction and enhance security, all while ensuring application runtime stability for efficient CI/CD pipelines.

Build a Docker Compose Local Development Stack

Generate a full Docker Compose configuration for a local development environment, integrating your application, PostgreSQL, Redis, and MailHog. It includes named volumes for data persistence, a `wait-for-db` entrypoint for service reliability, and provides essential guidance on image size and security for a robust setup.

Optimize Node.js 20 pnpm Dockerfiles for Production

Generate a multi-stage Dockerfile for Node.js 20 applications using pnpm, focusing on dependency caching and a compact runtime image. This ensures faster builds and smaller deployment artifacts, critical for production environments. Includes Docker Compose and build argument guidance.

Retrieve Top-3 Orders by Customer Revenue with Window Functions

Develop an optimized SQL query to identify the top three orders per customer based on revenue using window functions. This solution includes DDL, the query, expected plan notes, and index recommendations, ensuring efficient performance on large datasets.

SQL Duplicate Row Cleanup with Transactional Safety

Generate a comprehensive SQL solution for data engineers to identify and safely remove duplicate customer records. The output prioritizes transactional safety, preserving the earliest entry by `created_at`, and includes DDL, test data, cleanup query, execution plan notes, and

Postgres JSONB Query Patterns for Event Data

Generate PostgreSQL JSONB query patterns for DDL, filtering, GIN indexing, and nested field updates on event data. This workflow provides practical SQL solutions to common semi-structured data challenges, improving query performance and maintainability for database engineers.

SQL Pivot Monthly Revenue: Filter-Aggregate Approach

Generate a portable SQL solution to pivot monthly revenue data by product category. This approach uses standard SQL FILTER-aggregate syntax, eliminating the need for database-specific extensions. The output includes DDL, the pivot query, expected execution plan notes, index recommendations, and test data for immediate implementation.

Hourly Event Aggregation with Time Zone and Empty Buckets

This workflow guides data engineers through creating an hourly time-bucketed aggregation of event data using PostgreSQL's generate_series. It addresses time zone complexities and ensures all hours are represented, even those without events, for comprehensive analytics.

SQL Recursive CTE for Organizational Hierarchy Tree

Generate a comprehensive organizational hierarchy using a recursive CTE, deriving an employee tree from manager relationships. The solution provides DDL, an optimized query with depth and full path, index recommendations, and test data. This simplifies hierarchical data traversal and reporting for engineers.

Code Review

Build a FastAPI CRUD Service with Pydantic V2 and SQLModel

Generate a complete FastAPI CRUD application for a Task resource. It uses Pydantic V2 for robust data schemas, SQLModel for database interaction, and incorporates dependency injection for session management, providing a production-minded Python solution with code, tests, and dependency setup.