Skip to content
Search prompts, tools, agents…

Prompt library

8,208 AI prompts, ready to copy

Search every prompt on the site directly, not just the articles. Each one links back to its guide with examples and tips.

257 prompts · Clear

11. Competitive Analysis & Market Positioning Matrix

AI Tools & Prompt Guides
Perform a competitive analysis comparing [Option/Company A] vs. [Option/Company B] vs. [Option/Company C].

Analyze them based on:
1. Target Market Focus
2. Key Features / Strengths
3. Primary Weaknesses / Limitations
4. Pricing Model Overview
5. Best Suited For (Ideal Customer Profile)

Present the comparison in a detailed HTML table, followed by a 2-paragraph strategic recommendation on which option is best for [State Your Specific Need/Constraint].

11. SQL Query Optimizer Agent

AI Tools & Prompt Guides
ROLE: Database Performance Administrator Agent
GOAL: Analyze inefficient SQL queries, rewrite execution plans, and suggest missing indexes.
TOOLS:
- execute_explain_analyze(sql_query: str) -> dict

PROTOCOL:
- Run EXPLAIN ANALYZER on input query.
- Identify sequential scans, high cost nodes, and temporary disk spills.
- Provide optimized SQL query and exact CREATE INDEX statement.

11. The "Devil's Advocate" Strategy Stress-Tester

AI Tools & Prompt Guides
<role>
You are a ruthless risk analyst and contrarian strategist. Your sole purpose is to stress-test ideas and uncover critical vulnerabilities before execution.
</role>

<proposed_plan>
[Insert strategic plan or argument here]
</proposed_plan>

<instructions>
Examine the proposed plan and provide:
1. **Top 3 Fatal Flaws:** Logical fallacies or unrealistic operational assumptions.
2. **Hidden Risk Factors:** External market, technical, or human factors that could cause failure.
3. **Worst-Case Scenario:** Construct a plausible narrative where this plan fails catastrophically.
4. **Hardening Recommendations:** Concrete edits to fix each identified vulnerability.
</instructions>

12. Dense Whitepaper & Study Summarizer

AI Tools & Prompt Guides
Act as a senior research analyst. Review the attached document text and extract the essential insight.

Structure your analysis:
- Core Thesis / Objective: What problem does this paper address?
- Key Data & Metrics: List key statistics, percentages, or quantitative findings.
- Critical Methodology: Brief explanation of how the data was gathered/analyzed.
- Strategic Implications: What does this mean for [Insert Your Industry/Role]?

Document Text:
[Paste text here]

12. Infrastructure-as-Code (Terraform) Generator Agent

AI Tools & Prompt Guides
ROLE: DevOps Cloud Infrastructure Agent
GOAL: Generate modular Terraform scripts for AWS/GCP based on architecture requirements.
TOOLS:
- run_terraform_fmt(code: str) -> str
- run_tflint(code: str) -> dict

PROTOCOL:
- Generate HashiCorp HCL code.
- Format using run_terraform_fmt and lint via run_tflint.
- Deliver code only after 0 linting errors are returned.

12. Natural Language to SQL Query Generator

AI Tools & Prompt Guides
Act as a Senior Database Administrator. Write an optimized SQL query for [Insert SQL Dialect, e.g., PostgreSQL / Snowflake] based on the request below.

Database Schema:
- Table `users`: id, name, created_at, country
- Table `orders`: id, user_id, total_amount, status, created_at
- Table `order_items`: id, order_id, product_id, quantity

Request: "Find the top 5 countries by total revenue generated from completed orders over the last 90 days, including average order value per country."

Deliverable:
1. Valid SQL query with clean formatting and aliases.
2. Step-by-step query explanation (indexes recommended for optimization).

12. The Multi-Perspective Brainstormer (Six Thinking Hats)

AI Tools & Prompt Guides
<task>
Analyze the following challenge from six distinct cognitive perspectives:
</task>

<challenge>
[Insert challenge here, e.g., "Should our company pivot from B2B software sales to a self-serve PLG model?"]
</challenge>

<perspectives>
1. **White Hat (Facts & Data):** What empirical data do we have or lack?
2. **Red Hat (Emotions & Instincts):** How will team members and users feel about this?
3. **Black Hat (Caution & Risk):** What are the downside risks and obstacles?
4. **Yellow Hat (Optimism & Benefits):** What are the best-case advantages?
5. **Green Hat (Creativity & Alternatives):** What innovative tweaks could alter the plan?
6. **Blue Hat (Process Control):** What should be our immediate next steps?
</perspectives>

13. Task Time Estimator & Schedule Optimizer

AI Tools & Prompt Guides
Act as a productivity coach. I have a working day from [Start Time] to [End Time] with a [Duration] lunch break. 

Here are the tasks I need to complete today along with my estimated effort levels:
[List tasks and rough priorities]

Create a realistic time-blocked schedule incorporating 10-minute breaks between deep work sessions. Account for realistic focus limits and place the hardest task during peak morning hours.

13. Technical Architecture & System Design Draft

AI Tools & Prompt Guides
Act as a Lead Cloud Solutions Architect. Create a high-level System Design document for an application that handles: [Insert System Purpose, e.g., Real-time Chat Application scaling to 1 million users].

Cover the following components:
1. **Frontend Architecture**: Suggested stack and state management.
2. **Backend Services**: API pattern (REST vs GraphQL/gRPC), Microservices vs Monolith breakdown.
3. **Database Layer**: Primary DB choice (SQL vs NoSQL), caching strategy (Redis), and data persistence model.
4. **Scalability & Security**: Load balancing, rate limiting, and authentication framework (e.g., OAuth2 + JWT).

13. Technical Troubleshooting & Root Cause Analysis

AI Tools & Prompt Guides
Act as a Lead Systems Engineer and Principal Problem Solver. I am encountering the following error/issue:

Issue Description: [Describe problem, software bug, or operational bottleneck]
Context/Environment: [Include OS, platform, software stack, or workflow setup]
Error Logs / Symptoms: [Paste logs or step-by-step behavior]

Provide:
1. Top 3 probable root causes ordered by likelihood.
2. Step-by-step diagnostic actions to isolate the exact cause.
3. Recommended fix or temporary workaround for each scenario.

13. The Technical Step-by-Step Task Planner

AI Tools & Prompt Guides
<project_goal>
[Insert engineering or operational goal, e.g., "Migrating a legacy monolithic DB to PostgreSQL in AWS RDS"]
</project_goal>

<instructions>
Develop a step-by-step implementation blueprint formatted as follows:

1. **Phase Breakdown:** Group tasks into logical sequential phases.
2. **Prerequisites & Dependencies:** Detail what must be completed before each step begins.
3. **Verification Checklist:** Define clear test criteria to validate successful completion of each step.
4. **Rollback Strategy:** Outline immediate recovery steps if critical failures occur during migration.
</instructions>

14. Automated SQL Data Analyst Agent

AI Tools & Prompt Guides
ROLE: Business Intelligence SQL Agent
GOAL: Translate natural language business questions into SQL queries, run them, and chart outcomes.
TOOLS:
- get_database_schema() -> dict
- execute_sql_readonly(query: str) -> list

PROTOCOL:
- Retrieve schema. Formulate READ-ONLY SQL query (SELECT queries only).
- Run query via execute_sql_readonly. Summarize trends from the dataset in 3 key takeaways.

14. Quantitative Data Insight Synthesizer

AI Tools & Prompt Guides
<task>
Analyze the raw performance metrics below and derive actionable business insights.
</task>

<metrics_data>
[Paste numerical metric tables, conversion funnels, or sales reports]
</metrics_data>

<analysis_framework>
1. **Key Anomalies:** Highlight statistical outliers or unexpected metric spikes/drops.
2. **Correlation Highlights:** Identify metrics that appear positively or negatively correlated.
3. **Core Drivers:** What primary factors account for 80% of current performance outputs?
4. **Actionable Experiments:** Recommend 3 data-backed experiments to test next sprint.
</analysis_framework>

14. Spreadsheet Formula & Script Builder

AI Tools & Prompt Guides
Act as an expert Data Analyst. I need a solution for [Excel / Google Sheets].

Goal: [Explain what you want to achieve, e.g., VLOOKUP/XLOOKUP across multiple sheets based on two conditions, or auto-highlight rows meeting criteria].
Dataset Structure:
- Column A: [Describe Column A content]
- Column B: [Describe Column B content]
- Column C: [Describe Column C content]

Provide:
1. The exact formula to paste into the cell.
2. A step-by-step explanation of how each function in the formula works.
3. Common pitfalls or edge cases (e.g., blank cells, missing values) to watch out for.

15. Advanced Regular Expression (Regex) Builder & Explainer

AI Tools & Prompt Guides
Build a Regular Expression pattern to match: [Insert Validation Criteria, e.g., Strong passwords containing at least 8 characters, one uppercase, one lowercase, one number, and one special character].

Deliverable:
1. The exact Regex string in code format.
2. Breakdown of each token and symbol in the regex string.
3. 3 valid test case examples and 3 invalid test case examples showing why they fail.

15. Competitor Pricing Intelligence Agent

AI Tools & Prompt Guides
ROLE: Market Research Data Extraction Agent
GOAL: Track, normalize, and highlight competitor pricing changes from structured web data.
TOOLS:
- fetch_page_content(url: str) -> str
- normalize_currency(amount: str, target_currency: str) -> float

PROTOCOL:
- Scrape competitor pricing tables.
- Normalize all tier values to USD using normalize_currency.
- Generate comparative delta summary against current client pricing.

15. Edge Case & Failure Scenario Simulator

AI Tools & Prompt Guides
<system_description>
[Insert system architecture, API spec, or policy workflow]
</system_description>

<task>
Act as a Reliability Engineer. Identify 5 non-obvious edge cases, unexpected user inputs, or race conditions where this system could break or behave unpredictably.

For each edge case provide:
- **Trigger Condition:** Exactly what input or event triggers the edge case.
- **System Failure Behavior:** How the current spec responds poorly.
- **Mitigation Fix:** Specific architectural logic to fix the gap.
</task>

15. Rational Decision Matrix Evaluator

AI Tools & Prompt Guides
Act as a Management Consultant. I am trying to make a critical strategic decision:

Decision: [State decision, e.g., Build an in-house tool vs. Purchase an enterprise SaaS vendor]
Options Available: [List Option 1, Option 2, Option 3]
Key Evaluation Criteria: [List criteria, e.g., Implementation Speed, Cost, Scalability, Security, Customizability]

Instructions:
1. Assign a weight (1-5) to each criterion based on importance.
2. Score each option on a scale of 1-10 against each criterion.
3. Calculate total weighted scores and display everything in a clean decision table.
4. Provide a final reasoned recommendation based on the data.

16. Anomaly Detection Guard Agent

AI Tools & Prompt Guides
ROLE: Real-Time Telemetry Anomaly Agent
GOAL: Monitor server metric metrics and isolate abnormal spikes.
TOOLS:
- get_metric_stream(timeframe: str) -> list
- trigger_pagerduty_alert(service: str, details: str) -> bool

PROTOCOL:
- Evaluate time-series data against 3-sigma statistical thresholds.
- If anomaly detected, invoke trigger_pagerduty_alert and document root cause hypothesis.

16. The Feynman Technique Concept Explainer

AI Tools & Prompt Guides
Explain the complex topic of "[Insert Topic, e.g., Quantum Entanglement / Zero-Knowledge Proofs]" using the Feynman Technique.

Provide explanations across 3 progressive levels of understanding:
- Level 1: Explain it like I am 10 years old (use an intuitive real-world analogy).
- Level 2: Explain it to a university undergraduate student (introduce core domain terminology and mechanics).
- Level 3: Industry Application (explain how this concept is implemented in real-world systems today).

17. Dialectic Socratic Tutor for Critical Thinking

AI Tools & Prompt Guides
Act as a Socratic University Professor specializing in [Insert Subject Field]. I want to learn and test my understanding of [Insert Specific Topic].

Do NOT give me the answers directly. Instead:
1. Ask me one challenging question at a time to test my understanding.
2. Wait for my response.
3. Evaluate my answer, point out any logical gaps or misconceptions, and ask the next follow-up question to push my thinking further.

Let's begin. Ask me your first question.