AI Prompt Library - Page 3

Act as a front-end debugging specialist. My web page shows this error in the browser console:

[PASTE CONSOLE ERROR]

The related code is:

[PASTE HTML/JS]

What I expected: [EXPECTED BEHAVIOUR]. What actually happens: [ACTUAL BEHAVIOUR]. Explain the root cause, give the corrected code, and tell me how to use the browser DevTools (breakpoints, console.log, Network tab) to confirm the fix. If the error could come from code I have not shown, tell me exactly which part to paste next.

Tip: Open DevTools with F12, copy the red error text and the file and line number it points to.

You are a senior Laravel developer. I am getting this error in my Laravel [VERSION] app:

[PASTE ERROR AND STACK TRACE]

Relevant files (route, controller, model, view or migration):

[PASTE CODE]

Explain what Laravel is complaining about, the most likely cause, and the fix. Include any artisan commands I need to run (for example clearing config or cache, or running migrations) and explain what each one does. If the error might be caused by the server setup (PHP version, extensions, .env values), tell me what to check without asking me to share secret values.

Tip: Blank out database passwords, APP_KEY and API keys before pasting anything from your .env file.

Act as a rubber-duck debugging partner. I have a bug but I am not sure where it is. Do not guess a fix yet. Instead, ask me one question at a time to narrow down the problem: what I expected, what happened, what changed recently, how to reproduce it, and what I have already tried. After each answer, tell me briefly what you have ruled out. When you are fairly confident, suggest the most likely cause and a small experiment to confirm it. The bug: [SHORT DESCRIPTION]. Language/framework: [STACK].

Tip: Answer honestly and run the small experiments it suggests. This works well for bugs with no clear error message.

You are a senior software engineer doing a careful code review. Here is the diff of my pull request:

[PASTE DIFF]

Context: the change is meant to [PURPOSE]. Review it for correctness, edge cases, security, performance, readability and test coverage. Give your feedback as a table with columns: Severity (blocker, should fix, nitpick), File/line, Issue, Suggested change. Then write a short overall summary and say whether you would approve, approve with changes, or request changes. Be direct but respectful.

Tip: Get the diff with 'git diff main...your-branch'. Use this as a self-review before asking your team to review.

Act as a friendly mentor reviewing code from a beginner. I have been learning [LANGUAGE] for [TIME]. Here is a program I wrote:

[PASTE CODE]

First tell me three things I did well. Then list up to five improvements, starting with the most important. For each improvement, explain why it matters in simple words and show a small before-and-after example. Do not rewrite my entire program. End with one concept I should study next based on what you saw.

Tip: Share a program you finished yourself. Apply the suggestions one at a time so you understand each change.

You are an expert in clean code and safe refactoring. This function is too long and hard to maintain:

[PASTE FUNCTION]

Language: [LANGUAGE]. Refactor it without changing its behaviour. Steps: 1) describe what the function currently does, including edge cases, 2) list the code smells you see, 3) propose a refactoring plan in small steps, 4) show the final refactored code with smaller, well-named functions, 5) suggest tests I should write before refactoring so I can prove nothing broke.

Tip: Write or run the suggested tests before replacing the old function in your real project.

Act as a Node.js expert. I have older code that uses nested callbacks (or .then chains) and is hard to read:

[PASTE CODE]

Rewrite it using async and await with proper try/catch error handling. Keep the same behaviour, including the order of operations. Where operations are independent, show how Promise.all could run them in parallel and explain whether that is safe here. Add brief comments where the logic changed. Finally, list anything in the original code that was actually a bug.

Tip: Test both versions with the same inputs before switching. Mention your Node.js version if it is old.

You are a Python testing expert. Write unit tests using pytest for this code:

[PASTE CODE]

Cover: normal cases, edge cases (empty input, zero, negative numbers, very large values, wrong types), and expected exceptions. Use parametrize where it reduces repetition, give each test a descriptive name, and use fixtures if setup is repeated. Before the code, give me a short list of the scenarios you are testing and any behaviour in my function that seems unclear or possibly buggy. Also tell me the command to run the tests with a coverage report.

Tip: If tests fail, check whether the test or your function is wrong before changing anything, then ask the AI to explain the failure.

Act as a front-end testing specialist. Write tests for this React component using Jest and React Testing Library:

[PASTE COMPONENT]

Test what the user sees and does, not implementation details: rendering, user interactions (clicks, typing), loading and error states, and any API calls (mock them). Use accessible queries such as getByRole where possible. Explain in a short list why you chose each test. If the component is hard to test, suggest small changes that would make it more testable.

Tip: Tell the AI whether you use Vite, Create React App or Next.js, since the test setup differs slightly.

You are a Laravel testing expert. Write PHPUnit (or Pest, if I say so) feature tests for this endpoint:

Route: [METHOD AND URL]
Controller code: [PASTE]
Validation rules: [PASTE]

Cover: successful request, each validation failure, unauthenticated and unauthorised users, and database changes (use assertDatabaseHas). Use factories and RefreshDatabase. Name each test clearly. After the code, list any scenarios you could not test because information was missing.

Tip: Say whether you use PHPUnit or Pest, and paste your model factory if you already have one.

Act as a technical writer who writes excellent open-source documentation. Write a README.md for my project. Details: name [NAME], what it does [DESCRIPTION], tech stack [STACK], how to install [STEPS OR 'figure out from files below'], environment variables needed [LIST, no real values], and screenshots available [YES/NO]. Include sections: short description, features, demo or screenshots, installation, usage examples, configuration, project structure, roadmap, contributing, and license placeholder. Use clean Markdown with code blocks. Keep it scannable for a recruiter who spends 30 seconds on it.

Tip: Paste your package.json, composer.json or requirements.txt so the install steps are accurate.

You are a senior developer who writes helpful, not noisy, documentation. Add documentation to this [LANGUAGE] code:

[PASTE CODE]

Rules: add a docstring or doc comment to every public function and class in the standard style for this language (for example Google style for Python, JSDoc for JavaScript, PHPDoc for PHP), describing purpose, parameters, return value and exceptions. Add inline comments only where the reason behind the code is not obvious. Do not comment on obvious lines. Do not change any logic. Return the full documented code.

Tip: Use this before handing code to a teammate or client. Check that the descriptions match what the code really does.

Act as an API documentation specialist. Based on the routes and controller code below, write an OpenAPI 3 specification in YAML:

[PASTE ROUTES AND CONTROLLERS]

Include for each endpoint: summary, description, parameters, request body schema with an example, possible responses (success and errors) with example bodies, and authentication requirements. Define reusable schemas under components. After the YAML, list any endpoints where the behaviour was unclear so I can confirm it.

Tip: Paste the YAML into Swagger Editor to preview and check it. Fix anything the AI marked as unclear.

You are a regular expression expert. I need a regex that matches [DESCRIBE WHAT TO MATCH] and does NOT match [DESCRIBE WHAT TO REJECT]. It will be used in [LANGUAGE OR TOOL, e.g. JavaScript, Python, VS Code search, Google Sheets REGEXMATCH]. Here are examples that should match: [EXAMPLES] and examples that should not: [EXAMPLES]. Give me the regex, then break it down piece by piece in a table (Part, Meaning). Show a short test code snippet in my language. Mention any edge cases where it might fail.

Tip: Test the result on regex101.com with your own samples before using it in production code.

Act as a web developer building a sign-up form for Pakistani users. Write validation patterns and code in [LANGUAGE, e.g. JavaScript and PHP] for: Pakistani mobile numbers written in common formats (03XXXXXXXXX, +923XXXXXXXXX, with or without dashes), the CNIC number format with dashes (5 digits, 7 digits, 1 digit), and a postal code of 5 digits. Explain each regex, show how to normalise phone numbers to one format before saving, and give user-friendly error messages. Note that format validation does not prove a number or CNIC is real, and suggest how to handle that honestly.

Tip: Validate on both the front end and the server. Never store CNIC numbers unless your app truly needs them.

You are a patient regex teacher. Explain this regular expression to me:

[PASTE REGEX]

It is used in [LANGUAGE/CONTEXT]. Give: 1) a one-sentence summary of what it matches, 2) a piece-by-piece breakdown in a table, 3) five example strings that match and five that do not, 4) any bugs or edge cases you notice, 5) a simpler or more readable version if one exists (using named groups or verbose mode if my language supports it).

Tip: Copy the regex exactly, including flags such as /i or /g, because they change the meaning.

Act as a senior data analyst who writes clean SQL. My database is [MySQL / PostgreSQL / SQL Server / SQLite]. Here are the relevant table structures:

[PASTE CREATE TABLE STATEMENTS OR COLUMN LISTS]

I want to know: [YOUR QUESTION IN PLAIN ENGLISH, e.g. top 10 customers by total spending in the last 3 months, per city]. Write the query with clear aliases and comments. Explain how it works step by step, mention any assumptions you made about the data, and suggest one index that would make it faster if the tables are large.

Tip: Run it on a copy or with LIMIT first, and check a few results by hand to confirm the logic.

You are a database performance expert. This query is slow on [DATABASE AND VERSION]:

[PASTE QUERY]

Table sizes: [APPROX ROW COUNTS]. Existing indexes: [PASTE SHOW INDEX OUTPUT]. EXPLAIN output: [PASTE EXPLAIN OR EXPLAIN ANALYZE]. Explain in plain words why it is slow, based on the EXPLAIN output. Suggest improvements in order of impact: indexes to add, query rewrites, and schema changes. Show the rewritten query and the exact CREATE INDEX statements. Warn me about any trade-offs, such as slower inserts.

Tip: Test changes on a staging copy of the database first, and compare timings before and after.

Act as a database architect. Design a relational database for a school management system for a private school in Pakistan with classes from [RANGE, e.g. Playgroup to Matric]. It must handle students, guardians, teachers, classes and sections, subjects, attendance, exams and results, and monthly fee vouchers with fines and discounts. Give me: an entity list with key attributes, relationships (one-to-many, many-to-many) in a table, the full MySQL CREATE TABLE script with primary keys, foreign keys and sensible indexes, and a short note on design decisions. Ask me up to three questions first if key requirements are unclear.

Tip: Answer the clarifying questions carefully, as they shape the design. Then ask for sample queries such as 'students with unpaid fees'.

You are a data modelling expert. I track [WHAT, e.g. orders, inventory, clients] in one big spreadsheet. Here are the column headers and 5 sample rows:

[PASTE]

Explain which problems this layout causes (repeated data, update errors). Then normalise it into proper tables up to third normal form, explaining each step simply. Give the CREATE TABLE statements for [DATABASE] and a strategy, with SQL or Python, to import the existing spreadsheet data into the new tables without losing anything.

Tip: Replace real customer names and phone numbers in the sample rows with fake ones before pasting.

Act as an API architect. I am building [APP DESCRIPTION] with these main features: [FEATURES]. Design a REST API for it. Give me a table of endpoints with columns: Method, URL, Purpose, Request body, Response, Auth required. Follow good conventions for naming, plural resources, status codes, pagination, filtering and error format. Include a standard JSON error response example and explain how you would version the API. Point out any feature that might be better as a background job or webhook instead of a normal endpoint.

Tip: Share your list of features clearly. Afterwards, ask the AI to generate the routes and controllers for your framework.

You are a JavaScript developer who writes robust code. Write a function that calls this API endpoint: [URL AND METHOD], sending [REQUEST DATA] and expecting [RESPONSE SHAPE]. Use fetch with async and await. Handle: network failures, non-200 status codes, invalid JSON, timeouts (with AbortController) and a loading state for the UI. Show how to display friendly messages to the user in each case. Keep API keys out of front-end code and explain where they should live instead.

Tip: Use the official API documentation for the endpoint details. Test by turning off your internet to see the error handling work.

Act as a backend developer experienced with online payments. I want to accept payments on my [PLATFORM, e.g. Laravel site, WooCommerce store] using [GATEWAY, e.g. JazzCash, Easypaisa, a bank gateway]. I will give you the official documentation details: [PASTE RELEVANT DOCS OR SUMMARY]. Based only on that, explain the payment flow in steps, the data I send and receive, how to verify the response securely (hash or signature checks), how to handle failed, pending and duplicate payments, and what to log. Give a checklist for testing in the sandbox before going live. Do not invent endpoints or parameters that are not in the docs.

Tip: Always paste the gateway's current official documentation, since integration details change. Keep merchant credentials in environment variables.

Act as a front-end developer who writes clean, modern CSS. Build a responsive [SECTION, e.g. landing page hero, pricing table, services grid, restaurant menu page] for [BUSINESS, e.g. a bakery in Lahore]. Requirements: semantic HTML, mobile-first CSS using Flexbox or Grid, no frameworks, looks good from 360px to 1440px wide, accessible colours and alt text. Content: [TEXT AND ITEMS]. Give the HTML and CSS in separate code blocks and explain the key layout decisions in 5 bullet points.

Tip: Open the result in your browser and use DevTools device mode to check phone sizes, then ask for tweaks.

You are a CSS expert. My layout is broken. What I want: [DESCRIBE OR SKETCH IN WORDS]. What I see instead: [DESCRIBE, e.g. items overflow on mobile, footer floats in middle, elements not centred]. Here is the HTML and CSS:

[PASTE]

Explain the cause in simple words (for example margin collapse, flex-shrink, a fixed width or position issues), give the corrected CSS with changes marked in comments, and suggest a DevTools trick to spot this kind of problem faster next time.

Tip: Paste only the section that is broken plus its parent elements. A screenshot description helps a lot.

Act as a senior React developer. Build a reusable [COMPONENT, e.g. product card, searchable dropdown, image gallery, modal] component using React with [JavaScript or TypeScript] and [STYLING, e.g. Tailwind, CSS modules]. Requirements: [LIST]. Use function components and hooks, clear prop names with default values, accessibility (keyboard support, ARIA where needed) and no unnecessary re-renders. Show the component, an example of how to use it, and a short explanation of each prop.

Tip: Specify your React version and styling approach. Ask for Storybook stories or tests as a follow-up.

You are a React architect. My app: [DESCRIPTION, size, number of screens, team size]. Currently I manage state with [CURRENT APPROACH] and the pain points are [PROBLEMS]. Compare options for my case: local state with props, Context, a reducer, Zustand, Redux Toolkit, and a server-state library such as TanStack Query. Give a comparison table (learning curve, boilerplate, fits my case, when it becomes a problem). Recommend one approach and show a small code example of how my [SPECIFIC FEATURE] would look with it.

Tip: Be honest about your app's size. Small apps often do not need a big library.

Act as a Laravel mentor. Help me build a complete CRUD module for [RESOURCE, e.g. products with name, price in PKR, stock and category] in Laravel [VERSION] with Blade views. Walk me through, in order: migration, model with fillable fields and relationships, form request validation, resource controller, routes, Blade views for index (with pagination and search), create, edit and show, and flash messages. Give the artisan commands at each step. Keep code clean and explain briefly why each piece exists.

Tip: Follow the steps in a fresh project first. Ask for an API version or authorisation with policies as a next step.

You are an experienced WordPress plugin developer. Write a simple, secure plugin that [FUNCTION, e.g. adds a WhatsApp chat button, shows a notice bar, adds a custom post type for testimonials]. Follow WordPress coding standards: proper plugin header, prefixed function names, nonces and capability checks for any form, sanitising input and escaping output, and a settings page if needed. Give the full file structure and code, then explain how to install and test it on a local site.

Tip: Test on a staging or local site first. Ask the AI to explain any security function you do not recognise.

Act as a WordPress performance consultant. My site [DESCRIPTION, e.g. WooCommerce store for a clothing brand in Karachi] loads slowly. Hosting: [TYPE]. Theme and page builder: [NAMES]. Plugins installed: [LIST]. PageSpeed or GTmetrix results: [PASTE KEY NUMBERS AND WARNINGS]. Give me a prioritised action plan in a table: Issue, Likely cause, Fix, Difficulty, Expected impact. Include caching, image optimisation, database cleanup, plugin bloat and hosting considerations. Tell me what to back up before each risky change.

Tip: Run PageSpeed Insights for both mobile and desktop and paste the main warnings. Change one thing at a time and retest.

You are a Flutter developer who writes clean, maintainable widgets. Build a [SCREEN, e.g. login screen, product details page, order history list] for my app. Design description: [LAYOUT, colours, elements]. Requirements: responsive on small and large phones, separate widgets for reusable parts, form validation if there are inputs, and support for dark mode using ThemeData. Use only standard Flutter packages unless I say otherwise. Give the full Dart code and explain the widget tree in a short outline.

Tip: Mention your Flutter version. Paste a screenshot description or Figma notes for a closer match.

Act as a senior Flutter architect. My app is [DESCRIPTION, number of screens, whether it uses APIs, offline data, authentication]. I am a [LEVEL] developer working [alone / in a team of N]. Compare setState, Provider, Riverpod, Bloc/Cubit and GetX for my situation in a table: learning curve, testability, community support, suitability for my app. Recommend one, explain why, and show a minimal example of [FEATURE, e.g. a cart counter] using it, with a suggested folder structure.

Tip: Pick one approach and stick with it for the whole project; mixing several makes code hard to maintain.

You are a Git expert who stays calm in emergencies. Here is what happened: [DESCRIBE, e.g. I committed to the wrong branch, I ran git reset --hard, I pushed a secret file, merge conflict chaos]. Output of git status: [PASTE]. Output of git log --oneline -10: [PASTE]. Tell me first whether my work is likely recoverable. Then give me exact commands step by step, explaining what each one does, with the safest option first. Warn me clearly before any command that rewrites history or affects teammates.

Tip: Do not run more commands until you get an answer. If you pushed a secret, rotate that key immediately as well.

Act as an engineering lead. We are a team of [NUMBER] developers at a [TYPE, e.g. software house in Islamabad, startup, freelance group] working on [PROJECT TYPE]. We deploy [HOW OFTEN]. Recommend a Git workflow that fits us (for example trunk-based, GitHub Flow or Git Flow). Explain branch naming, pull request rules, code review, handling hotfixes, tagging releases and protecting the main branch. Give a one-page team guide in Markdown that I can put in our repository.

Tip: Keep it simple for small teams. Ask the AI to adjust the guide after your team tries it for two weeks.

You are a developer who writes excellent commit messages. Based on this diff:

[PASTE git diff --staged OUTPUT]

Write a commit message following the Conventional Commits style: a type (feat, fix, refactor, docs, test, chore), a short summary under 60 characters in the imperative mood, and a body explaining what changed and why in 2 to 4 bullet points. If the diff contains unrelated changes, tell me how to split it into separate commits instead.

Tip: Stage your changes first, then paste the staged diff. Adjust the message if the AI misunderstood the reason behind a change.

Act as a Linux system administrator teaching a developer who is new to servers. I just got a [UBUNTU/DEBIAN] VPS to host [PROJECT]. Teach me the 25 most useful commands for my situation, grouped by task: moving around files, viewing logs, permissions, processes, disk and memory, networking, package installation and services. For each give the command, a real example and one warning if it is dangerous. End with a short practice exercise I can do safely on my own server.

Tip: Practise on a test server or a local virtual machine before trying commands on a live server.

You are a DevOps engineer. Write a Bash script that backs up [WHAT, e.g. a MySQL database and the /var/www/myapp folder] on a Linux server. Requirements: date-stamped compressed backup files, keep only the last [N] backups, log output to a file, exit with a clear error if any step fails (use set -euo pipefail), and read database credentials from a protected config file rather than the script. Explain each section and give the cron line to run it daily at [TIME]. Also explain how to test a restore.

Tip: A backup is only useful if you can restore it. Test a restore on a separate machine at least once.

Act as a DevOps engineer. Help me containerise my [STACK, e.g. Laravel with MySQL and Redis, Node.js API with PostgreSQL, Django app]. Give me: a Dockerfile following best practices (small base image, layer caching, non-root user), a docker-compose.yml for local development with the app, database and any other services, volumes for persistent data, a .dockerignore file and the commands to build, start, view logs and stop. Explain each file briefly and list common beginner mistakes with Docker.

Tip: Share your framework and version. If the build fails, paste the full error output back to the AI.

You are a CI/CD specialist. Write a GitHub Actions workflow for my [LANGUAGE/FRAMEWORK] project that runs on every push and pull request to main. It should: install dependencies with caching, run the linter, run tests, and [OPTIONAL: build a Docker image / deploy to STAGING]. Use secrets for any credentials. Give the full YAML file with comments, explain each step, and tell me how to add a status badge to my README. Mention how to make the main branch require this check before merging.

Tip: Place the file under .github/workflows/. Check the Actions tab after pushing to see the run results.

Act as a server administrator. Guide me to deploy my [APP TYPE, e.g. Laravel app, Node.js app, static React build] on a fresh [Ubuntu version] VPS. Cover: creating a non-root user with SSH keys, basic firewall rules, installing the needed software, configuring Nginx as a web server or reverse proxy, setting environment variables, free SSL with Let's Encrypt, keeping the app running with a process manager or service, and viewing logs. Number each step and give the exact commands. Point out steps that can lock me out of the server if done wrong.

Tip: Keep your hosting provider's web console open as a backup in case SSH access breaks.

You are an application security reviewer helping me defend my own application. Review this [LANGUAGE/FRAMEWORK] code for security weaknesses:

[PASTE CODE]

Check for: SQL injection, XSS, CSRF, broken authentication or authorisation, insecure file uploads, secrets in code, weak password storage, and missing input validation. For each finding give: severity, the vulnerable line, why it is risky in plain words, and the fixed code. Finish with a short list of security habits I should adopt for the rest of the project.

Tip: Only review code you own or are authorised to work on. Remove real keys and passwords before pasting.

Act as a security-focused backend developer. I am building login and signup for my [STACK] app used by [AUDIENCE, e.g. students, small business customers]. Give me a practical security checklist grouped into: password storage, login rate limiting and lockouts, session or token handling, password reset flow, email or phone verification, two-factor authentication options, logging and alerts, and privacy of personal data. For each item give a one-line explanation and how to implement it in my stack.

Tip: Use the checklist during development and again before launch. Prefer your framework's built-in auth features over custom code.

You are a Python performance expert. My script takes [TIME] to run on [DATA SIZE] and I need it faster. Here is the code:

[PASTE CODE]

First, tell me how to profile it with cProfile or line_profiler and how to read the output. Then, based on the code, point out the likely bottlenecks (for example loops over big lists, repeated file or database access, wrong data structures). Suggest improvements in order of expected impact, with rewritten code, and estimate the complexity before and after using Big-O notation.

Tip: Run the profiler and paste its top lines back to the AI for more accurate advice.

Act as a front-end performance engineer. My site [URL or DESCRIPTION, framework used] has a Lighthouse performance score of [SCORE] on mobile. Key metrics: LCP [VALUE], CLS [VALUE], INP or TBT [VALUE]. Top warnings: [PASTE]. Explain what each metric means in simple words and what is hurting mine. Give a prioritised fix list with code examples where useful (image formats and sizes, lazy loading, font loading, reducing JavaScript, caching headers). Keep in mind many of my users are on slower mobile data connections.

Tip: Test in an incognito window so browser extensions do not affect the results. Retest after every change.

You are a computer science teacher preparing students for university exams and job interviews. Explain Big-O notation simply: what it measures, and the common classes O(1), O(log n), O(n), O(n log n), O(n^2) and O(2^n), each with a short code example and a real-life comparison. Then analyse the time and space complexity of this code I wrote:

[PASTE CODE]

Show your reasoning step by step, and suggest a more efficient approach if one exists.

Tip: Try to guess the complexity yourself before reading the AI's analysis, then compare.

Act as a coding interview coach. I am practising this problem: [PASTE PROBLEM OR NAME]. Do not give me the solution. Instead: 1) ask me to explain my first idea, 2) give hints in three levels, from vague to specific, only when I ask for the next one, 3) once I write code, review it for correctness, edge cases and complexity, 4) then show the optimal approach and compare it with mine. My language is [LANGUAGE].

Tip: Ask for one hint at a time and give the problem a real try between hints. This builds problem-solving skill, not memorisation.

You are an interviewer at a [COMPANY TYPE, e.g. product company, software house, remote startup] hiring a [ROLE AND LEVEL]. Conduct a 45-minute mock technical interview with me in chat. Ask one coding question at an appropriate difficulty, then follow-up questions about complexity and edge cases, then two short conceptual questions about [TOPICS, e.g. databases, OOP, JavaScript]. Wait for my answer each time. At the end, give me a scorecard in a table (problem solving, code quality, communication, fundamentals) with ratings out of 5 and specific advice to improve.

Tip: Answer as you would in a real interview, including explaining your thinking before writing code.

Act as an algorithms tutor. Explain the [ALGORITHM, e.g. binary search, merge sort, Dijkstra's algorithm, BFS] to me. Start with the idea in two sentences, then trace it step by step on this input: [INPUT or 'choose a small example']. Show the state of the data (array, queue, distances) after each step in a table. Then give clean code in [LANGUAGE] with comments, its time and space complexity, and two classic problems where this algorithm is used.

Tip: Trace the algorithm yourself on paper with a different input after reading, then ask the AI to check your trace.

You are a senior engineer who is excellent at choosing data structures. Here is my problem: [DESCRIBE, e.g. store and look up 1 million product codes quickly, keep a live leaderboard, schedule tasks by priority]. The operations I need and how often: [LIST]. Compare suitable data structures (array, linked list, hash map, set, heap, tree, trie, graph) in a table showing the cost of each operation. Recommend the best fit, explain why, and show a short implementation in [LANGUAGE].

Tip: Be specific about which operations happen most often, since that decides the best choice.

Act as a competitive programming mentor. I find dynamic programming confusing. Teach me using the five most common DP patterns (for example 0/1 knapsack, unbounded knapsack, longest common subsequence, grid paths, and interval DP). For each pattern: the key idea, how to spot it in a question, the recurrence relation, a solved example with a small table, and one practice problem name for me to try. Then give me a general four-step method for approaching any new DP problem. Use [LANGUAGE] for code.

Tip: Study one pattern per day and solve its practice problem before moving to the next.

You are a staff engineer running a system design interview. Give me this question: design [SYSTEM, e.g. a URL shortener, a chat app, a news feed, a ride-hailing service]. Play the interviewer: let me ask clarifying questions, then ask me to propose requirements, API, data model, high-level architecture, scaling approach and trade-offs, one stage at a time. Push back where my design is weak, as a real interviewer would. At the end, show a strong reference design and a feedback summary of what I missed.

Tip: Draw your design on paper or in a diagram tool while you answer, and describe it in text.

Act as a solutions architect. Design the system for a food and grocery delivery app launching in [CITIES, e.g. Lahore and Faisalabad], expecting [NUMBER] orders per day in year one. Features: customer app, rider app, restaurant dashboard, live order tracking, cash on delivery and digital wallet payments, and SMS or push notifications. Consider patchy mobile internet for riders. Give: main components and how they talk to each other, database choices, how live tracking works, how to handle payment failures, and what to build first as an MVP versus later. Include a simple text diagram and a rough list of cloud services needed.

Tip: Adjust the order numbers to your real estimate. Ask follow-ups about cost or a specific component.

You are a data analyst who is expert in pandas. I have a CSV file with these columns and sample rows:

[PASTE HEADERS AND 5-10 ROWS]

Problems I have noticed: [e.g. mixed date formats, prices with 'Rs' and commas, duplicate rows, city names spelled differently like 'Karachi' and 'khi']. Write a well-commented pandas script that loads the file, cleans each problem, standardises column names, handles missing values sensibly (explain your choice), removes duplicates, and saves a clean file. Print a before-and-after summary of row counts and null values.

Tip: Replace personal data in the sample rows with fake values. Run the script in Jupyter or Google Colab to see each step.

Act as a business data analyst. I have sales data in a pandas DataFrame with columns: [LIST, e.g. date, city, product, category, quantity, price_pkr]. Write pandas code to answer: total revenue by month, top 10 products by revenue, revenue by city and category as a pivot table, month-over-month growth percentage, and the best day of the week for sales. Explain each step of the code briefly. Then suggest three further questions this data could answer for the business owner.

Tip: Load your data first and print df.head() and df.dtypes so you can tell the AI the exact column names and types.

You are a data visualisation expert using Python. I have a pandas DataFrame with columns [LIST] and I want to show [MESSAGE, e.g. how monthly signups changed, which cities perform best] to [AUDIENCE, e.g. my manager, a client]. Recommend the best chart type for each message and why. Write matplotlib or seaborn code for each chart with a clear title, axis labels, readable fonts, sensible colours and number formatting (for example thousands separators for PKR). Show how to save each chart as a PNG for a report or slide.

Tip: Tell the AI your audience; a chart for a client should be simpler than one for analysts.

Act as an Excel expert. My sheet has these columns: [DESCRIBE COLUMNS AND WHAT IS IN EACH, with an example row]. I need a formula in column [COLUMN] that [WHAT IT SHOULD DO, e.g. finds the price from another sheet, calculates late fees after the due date, marks rows as Paid or Pending]. I use [Excel 365 / Excel 2016 / Google Sheets]. Give the formula, explain each part in simple words, show a version that handles blanks and errors cleanly, and mention if a newer function (like XLOOKUP, FILTER or LET) would make it simpler.

Tip: Say which version you use, as some functions are not available in older Excel.

You are an Excel troubleshooting expert. This formula is giving me [ERROR, e.g. #N/A, #VALUE!, #REF!, wrong result]:

[PASTE FORMULA]

The cells it refers to contain: [DESCRIBE WITH EXAMPLES]. What I expected: [EXPECTED RESULT]. Explain what the error means, the most likely reasons in my case (for example numbers stored as text, extra spaces, wrong ranges, absolute vs relative references), how to check each one, and the corrected formula.

Tip: Describe the actual cell contents, including whether numbers are left-aligned (often a sign they are stored as text).

Act as a Google Apps Script developer. I want to automate this task in Google Sheets: [TASK, e.g. send an email reminder when a due date is 3 days away, copy new form responses into monthly tabs, generate a PDF invoice from a template row]. My sheet structure: [TABS, COLUMNS, SAMPLE ROW]. Write the script with comments, explain how to paste it into the Apps Script editor, how to set a time-based or on-edit trigger, what permissions it will ask for and why, and how to test it safely on a copy of the sheet.

Tip: Always test on a copy of your sheet first. Read the permission screen carefully before allowing it.

You are a spreadsheet designer helping a small academy or tuition centre in [CITY]. Design a Google Sheets fee tracker for about [NUMBER] students. Include: a student list tab (name, class, guardian contact, monthly fee in PKR, discount), a monthly payments tab, a summary dashboard showing collected vs pending fees per month and a list of defaulters, and conditional formatting to highlight unpaid fees. Give me the exact column layout for each tab and every formula needed, explained simply. Suggest simple data validation to prevent typing mistakes.

Tip: Build the tabs exactly as described, then ask for extra features such as a WhatsApp reminder message column.

Act as an Excel VBA developer. Every [DAY/WEEK] I manually do this in Excel: [DESCRIBE STEPS IN DETAIL, e.g. open a file, remove blank rows, format columns, split data into sheets by city, save as PDF]. Write a VBA macro that automates this. Add comments on each section, include basic error handling, and avoid hard-coded file paths where possible (use a file picker). Explain how to add the macro, assign it to a button, and save the workbook as .xlsm. Warn me about anything that cannot be undone.

Tip: Keep a backup of your file, since macro actions cannot be undone with Ctrl+Z.