AI Prompts for Software

engineer specializing in large-scale refactoring. Your task is to refactor the

codebase. Before you make any changes to

. Your task is to create a migration plan for the

model Product { id String @id @default(cuid()) name String description String? price Float createdAt DateTime @default(now()) updatedAt DateTime @updatedAt }

. I need you to first explain it, and then re-implement it in a more efficient and readable way in

[Paste code snippet, e.g., a function handling user input or a database query]

file and identify potential risks. **File Content:**

function. While the EU AI Act's Article 50 transparency obligations do not apply to source code itself, I want to adopt its principles for internal governance. **Code Snippet:**

that needs to perform a specific task. **Task Description:** The Lambda function needs to read objects from the

[[Paste the full git diff here]]

CREATE TABLE users ( id SERIAL PRIMARY KEY, name VARCHAR(100), email VARCHAR(100) UNIQUE, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); CREATE TABLE orders ( id SERIAL PRIMARY KEY, user_id INTEGER REFERENCES users(id), amount DECIMAL(10, 2), created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() );

. Analyze the following slow query and the table schema, then provide an optimized version. **Table Schema:**

[from myapp.models import Author, Book recent_prolific_authors = Author.objects.filter( book__publication_date__gte='2026-01-01' ).annotate( num_books=Count('book') ).filter( num_books__gt=5 ).order_by('-num_books')]

function calculateDiscount(price, quantity, userTier) { // ... function implementation ... }

developer debugging a production error. I will provide a stack trace and the relevant code. Your job is to identify the most likely root cause. **Environment:**

2. **Explanation:** Break down the regex part by part in a table, explaining what each component does (e.g.,

(for interacting with the Prisma schema and CLI) *

(for creating GitHub issues) **Scenario:** The "new user registration" feature has been deployed to the staging environment at

. 3. Analyze the function signature, the Zod validation schema, and the main logic. 4. Create a new file

Design a system like `[[Twitter's timeline service]]`." **Your Role:** 1. Start by asking me clarifying questions to scope the problem (e.g., "What are the key features?" "What is the expected scale?"). 2. As I propose components (e.g., load balancers, databases, caches), challenge my decisions. Ask about trade-offs, failure modes, and scalability bottlenecks. 3. Force me to do back-of-the-envelope calculations for storage, bandwidth, and QPS. 4. Do not give me the answers. Guide me toward a robust design by asking critical questions. 5. Conclude the interview by giving me feedback on my design, highlighting 3 strengths and 3 areas for improvement.

# ADR-001: Adopt ScyllaDB as the Primary Database **Date:** `[[September 3, 2026]]` **Status:** Accepted **Context:** *(Describe the business/technical problem we are trying to solve.)* **Decision:** *(State the decision clearly.)* **Consequences:** * **Positive:** * *(List the expected benefits, e.g., improved write throughput, lower read latency, horizontal scalability.)* * **Negative:** * *(List the downsides and risks, e.g., loss of ACID transactions, need for new developer skills, migration complexity.)* **Options Considered:** 1. **ScyllaDB:** *(Briefly describe why this was chosen.)* 2. **PostgreSQL with CitusDB:** *(Briefly describe why this was not chosen.)* 3. **CockroachDB:** *(Briefly describe why this was not chosen.)*

[[a real-time chat application for large online communities]]

to me. **Instructions:** * Assume I am an experienced developer who has only ever worked with garbage-collected languages like

[I accidentally committed a large binary file to my feature branch. I have made several other commits on top of it. I want to remove that file and its commit from my branch history before I create a pull request. I have not pushed the branch to the remote yet.]

/ ├── app/ │ ├── layout.tsx │ └── page.tsx ├── components/ │ └── ui/ ├── lib/ │ └── utils.ts ├── public/ ├── package.json ├── tsconfig.json ├── next.config.mjs └── tailwind.config.ts

Generate a functional prototype for a mobile app called 'PlantPal'. It's for new plant owners. Key Screens: - **Onboarding:** A simple 3-step intro to the app's features. - **Login/Sign-up:** Email and password authentication. - **My Plants:** A dashboard showing a grid of plants the user has added. Each card should show a photo, the plant's name, and a 'Water Now' button. - **Add Plant:** A form to add a new plant with fields for name, species (dropdown), and a photo upload. - **Plant Details:** A view showing more information about a specific plant, including a watering schedule and care tips. The database should have a 'Users' table and a 'Plants' table, with a relationship between them.

Analyze the following TypeScript function. Write a complete TSDoc comment for it. Explain what the function does, describe each parameter (including its type and purpose), and describe the return value. [[Paste your code here]]

I need to refactor a React component located at `src/components/OldProfile.tsx`. **Goal:** Create a new component `src/components/ProfileHeader.tsx` by extracting the header logic from `OldProfile.tsx`. **Context:** - The new `ProfileHeader` should accept `user` object as a prop. The user type is defined in `src/types/user.ts`. - It needs to display the user's avatar, full name, and username. - It must use our existing UI components: `<Avatar>`, `<Heading>`, and `<Text>` from `src/components/ui/`. - Styling must use Tailwind CSS classes only. **Task:** 1. Create the new file `src/components/ProfileHeader.tsx`. 2. Implement the component according to the context above. 3. Remove the corresponding code from `OldProfile.tsx`. 4. Import and use the new `ProfileHeader` component within `OldProfile.tsx`, passing the correct props.

I have a slow PostgreSQL query. Here is the query and the `EXPLAIN ANALYZE` output. **Query:** [[Paste your slow SQL query here]] **EXPLAIN ANALYZE Output:** [[Paste the full EXPLAIN ANALYZE output here]] **Schema:** - `users` table: (id, name, email, created_at) - `orders` table: (id, user_id, amount, created_at) - The `user_id` column in `orders` is a foreign key to `users.id`. **Task:** 1. Identify the bottleneck in the query plan. 2. Suggest one or more optimized versions of the query. 3. For each suggestion, explain *why* it is more performant. 4. Recommend any database indexes that would improve the performance of the original query. Provide the exact SQL `CREATE INDEX` statement.

# Python, using SQLAlchemy and FastAPI # Database model (models.py): # class Item(Base): # __tablename__ = "items" # id = Column(Integer, primary_key=True, index=True) # name = Column(String, index=True) # description = Column(String) # Pydantic schema (schemas.py): # class Item(BaseModel): # id: int # name: str # description: str | None = None # # class Config: # orm_mode = True # Prompt: # Write a SQLAlchemy function `get_item_by_id` that takes a database session and an item_id. # It should query the `Item` model and return the first result. # If no item is found, it should return None.

Write a Terraform configuration (HCL) to create a private S3 bucket. The bucket should have versioning enabled, server-side encryption using AWS KMS, and block all public access. Include a bucket policy that only allows access from a specific IAM role ARN.

import requests def get_user_profile(user_id): """ Fetches a user's profile from an external API and returns their name. """ if not isinstance(user_id, int) or user_id <= 0: raise ValueError("User ID must be a positive integer.") try: response = requests.get(f"https://api.example.com/users/{user_id}") response.raise_for_status() # Raises an HTTPError for bad responses data = response.json() return data.get("name") except requests.exceptions.RequestException as e: # Log the error, for example print(f"API request failed: {e}") return None