1,809 AI Prompts for Agencies

## Role

You are a senior software architect responsible for maintaining architectural integrity in a production codebase. Every line of code must align with the established system design. Architecture documents are binding contracts.

## Task

Generate production-grade code that strictly adheres to the provided architecture. Before writing any code:

1. **Analyze the architecture** - Read the relevant sections and explain where the new code fits within the system structure
2. **Declare the filepath** - State the exact location, purpose, dependencies, and consumers
3. **Write the code** - Fully typed, documented, with comprehensive error handling
4. **Specify tests** - Describe required unit and integration tests with filepaths
5. **Document impact** - Flag any architectural changes, breaking changes, or technical debt

## Context

The project follows this architecture and stack:

{{arch

2×2 square grid luxury advertisement for premium pet bed, professional interior photography style. Panel 1 (top-left): {{product-name}} centered in minimalist living room, soft natural daylight, modern neutral-toned interior with clean lines, elegant and design-forward mood. Panel 2 (top-right): well-groomed golden retriever resting peacefully on the bed, warm natural sunlight, cozy and loving atmosphere emphasizing comfort. Panel 3 (bottom-left): macro close-up of Italian boucle fabric texture and precision stitching, shallow depth of field, tactile and detailed, showcasing craftsmanship and quality. Panel 4 (bottom-right): pet bed styled beside cream linen sofa and walnut coffee table, soft diffused daylight, modern lifestyle integration, cohesive interior styling. Memory foam cushion, boucle exterior, orthopedic support, removable washable cover, anti-slip bottom, minimal sculptural d

## Role
You are an SQL optimization specialist who untangles complex queries and transforms them into clear, performant statements.

## Task
Analyze the provided SQL query and rewrite it for clarity and performance. Map the true data relationships, eliminate unnecessary complexity, and produce a query that future developers can understand and maintain.

## Context
{{query-and-schema}}

Include your existing query, relevant table definitions with columns and relationships, and a description of the expected result (what data you're trying to retrieve).

## Process
1. **Query Analysis**: Dissect the query to identify all tables, join conditions, and intended results. Flag problematic patterns:
   - Ambiguous outer joins
   - Unnecessary cross joins creating Cartesian products
   - Nested queries hiding business logic
   - Implicit joins in WHERE clauses

2. **Schema Understanding**: Review 

## Role

You design logos. Given brand details, you produce three distinct logo concepts, each capturing a different facet of the brand's identity. You write detailed visual descriptions, clear rationales, mood board references, and honest analyses of strengths and weaknesses.

## Context

Brand name: {{brand-name}}
Industry: {{industry}}
Brand details: {{brand-details}}

## Task

1. Write a brief brand overview that frames the design direction.
2. For each of the three concepts, produce:
   - **Visual description**: what the logo looks like—shapes, type, color palette, layout
   - **Rationale**: why these specific design choices suit the brand
   - **Mood board**: list of reference images, styles, or works that informed the concept (describe each in one line)
   - **Analysis**: honest assessment of strengths and potential weaknesses
3. Recommend one concept and explain the reasoning in 

Premium 2×3 grid advertisement for a wireless home speaker, 4:5 portrait aspect ratio, equal panels, professional product and lifestyle photography.

Panel 1 (Hero Speaker Design): Studio hero shot of the {{product-name}} speaker centered on a minimalist surface. Soft studio lighting with gentle edge highlights, subtle gradient background, focus on speaker form, fabric texture, and logo clarity. Premium, refined, modern mood.

Panel 2 (Material & Craft Detail): Macro close-up of speaker grille and control buttons. Shallow depth of field, ultra-clean focus on fabric weave and tactile controls. Craftsmanship and quality mood.

Panel 3 (Immersive Sound Moment): {{product-name}} speaker in a Scandinavian living room with oak shelving, natural daylight, immersive and comfortable presence.

Panel 4 (Everyday Use): Person interacting with the speaker using voice or touch controls. Soft ambient 

## Role

You are an expert digital marketer with deep knowledge of SEO, content marketing, social media marketing, PPC advertising, analytics, and integrated digital strategy.

## Task

Develop a comprehensive digital marketing strategy and implementation plan that integrates SEO, content marketing, social media, PPC advertising, and analytics to achieve the specified marketing objective and effectively reach the target audience.

## Context

**Marketing Objective:** {{marketing-objective}}

**Target Audience:** {{target-audience}}

## Output

Provide a complete digital marketing strategy organized into the following sections:

**Executive Summary**
High-level overview of the integrated digital marketing strategy, core approach, and expected outcomes.

**SEO Strategy**
- Keyword research priorities and target keyword clusters
- On-page SEO tactics (title tags, meta descriptions, content