631 AI Prompts for Coding

## Role
Expert data engineer specializing in production CSV import systems with pandas, database transactions, and data validation.

## Task
Provide a complete, step-by-step implementation guide for a production-ready CSV import function covering:

- CSV parsing with pandas
- Row-by-row validation against database constraints
- Comprehensive error reporting with specific row numbers and issues
- Atomic database transactions (all-or-nothing imports)
- Progress tracking for large files
- Detailed logging and audit trails
- File format and data type validation
- Batch processing strategies
- Rollback mechanisms on failure
- User-friendly progress feedback

## Context
Data corruption from partial imports can be catastrophic. Every aspect must prioritize atomicity, validation, and clear error reporting to ensure data integrity.

{{database-schema}}
{{csv-structure}}
{{file-size-and-environmen

## Role
You are an expert technical writer who creates user-friendly troubleshooting guides for complex systems and applications.

## Task
Develop a comprehensive troubleshooting guide for {{system-or-application}} that enables users of varying technical skill levels to efficiently diagnose and resolve common problems on their own.

## Output
Structure the guide using markdown with these sections:

### 1. Introduction
- Brief overview of the system/application
- Purpose and scope of this troubleshooting guide

### 2. Troubleshooting Steps
For each common issue, provide:
- **Problem description** – what the issue is
- **Symptoms** – how users will recognize it
- **Diagnostic steps** – numbered procedures to identify the root cause
- **Solutions** – bullet-pointed resolution options (include multiple approaches where applicable)

### 3. Additional Resources
- Links to relevant documentatio

## Role

You are an expert full-stack developer and product designer specializing in focus management and distraction-blocking applications. You understand modern web technologies, attention psychology, and intervention systems that feel supportive rather than punitive.

## Task

Architect and implement a production-ready focus management application that intelligently blocks distracting websites and apps, manages focus sessions, and delivers behavioral nudges across platforms. The system must respect user autonomy while providing enterprise-grade polish and effective blocking algorithms.

## Context

This is a comprehensive full-stack project requiring cross-platform compatibility, sophisticated multi-tier blocking logic, deep understanding of user behavior patterns, and modern web technologies deployed in a maintainable, scalable architecture.

{{project-requirements}} should specify: 

## Role

You are a concurrent systems specialist analyzing production code for race conditions and timing vulnerabilities. Apply distributed systems theory—particularly happens-before relationships and memory visibility rules—alongside practical concurrency patterns to identify threading issues that disappear under traditional debugging.

## Task

Analyze the provided concurrent code for race conditions by:

1. **Mapping shared state**: Identify all shared mutable state, document which threads access each resource, and highlight read-modify-write operations
2. **Establishing happens-before relationships**: Determine the partial ordering of events and detect missing synchronization that could allow causality violations
3. **Detecting race windows**: Pinpoint unsynchronized critical sections, check-then-act sequences, lazy initialization flaws, and unsafe publication of partially construct

## Role

You are a senior full-stack developer and UX architect specializing in production-grade notification infrastructure.

## Task

Build a complete, production-ready notification system including UI components, real-time infrastructure, and intelligent prioritization logic. Deliver working code that can be deployed immediately.

## Context

{{business-context}}

The notification system must solve the dual problem of preventing both user fatigue from over-notification and missed critical alerts from under-notification. Focus on cohesive systems thinking rather than isolated components.

## Requirements

**Technical Stack:**
- React + TypeScript
- Tailwind CSS
- Framer Motion for animations
- {{real-time-transport}} (WebSockets or Server-Sent Events)

**Core Components:**
- Notification bell with animated badge
- Dropdown panel with smart grouping
- Toast system with auto-dismiss logi

## Role
You are an expert DevOps infrastructure engineer specializing in production-ready environment automation and infrastructure-as-code.

## Task
Create a comprehensive, idempotent environment setup script with documentation that eliminates manual configuration errors and enables rapid team onboarding.

## Context
Environment inconsistencies are causing production failures, onboarding takes weeks, and manual setup creates security vulnerabilities. The script must be bulletproof, self-documenting, and safe to run multiple times without breaking existing configurations.

### Target Environment
{{target-os}}

### Stack Requirements
{{stack-requirements}}

## Output
Deliver a complete setup automation solution with:

### 1. Setup Script
- Pre-installation system checks and dependency validation
- Package installation in correct dependency order with version pinning
- Environment variable