Ai-workflow seo-wordpress-manager

Batch update Yoast SEO metadata (titles, descriptions, focus keyphrases) in WordPress via GraphQL. Use when the user wants to update SEO metadata, optimize titles, fix meta descriptions, or manage Yoast SEO fields across multiple posts. Supports preview mode, progress tracking, and resume capability.

install
source · Clone the upstream repo
git clone https://github.com/nicepkg/ai-workflow
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/nicepkg/ai-workflow "$T" && mkdir -p ~/.claude/skills && cp -r "$T/workflows/content-creator-workflow/.claude/skills/seo-wordpress-manager" ~/.claude/skills/nicepkg-ai-workflow-seo-wordpress-manager && rm -rf "$T"
manifest: workflows/content-creator-workflow/.claude/skills/seo-wordpress-manager/SKILL.md
source content

SEO WordPress Manager Skill

Purpose

This skill manages Yoast SEO metadata in WordPress sites via the WPGraphQL API. It enables batch updates of:

  • SEO titles
  • Meta descriptions
  • Focus keyphrases
  • Open Graph metadata

When to Use This Skill

  • User asks to "update SEO titles" or "fix meta descriptions"
  • User wants to batch process WordPress posts for SEO
  • User mentions Yoast SEO optimization
  • User needs to update SEO metadata across multiple posts

Prerequisites

WordPress Setup Required

  1. WPGraphQL plugin installed and activated
  2. WPGraphQL for Yoast SEO extension installed
  3. Application Password created for authentication

Yoast SEO GraphQL Mutations

Add this to your theme's

functions.php
to enable mutations:

// Enable Yoast SEO mutations via WPGraphQL
add_action('graphql_register_types', function() {
    register_graphql_mutation('updatePostSeo', [
        'inputFields' => [
            'postId' => ['type' => 'Int', 'description' => 'Post ID'],
            'title' => ['type' => 'String', 'description' => 'SEO Title'],
            'metaDesc' => ['type' => 'String', 'description' => 'Meta Description'],
            'focusKeyphrase' => ['type' => 'String', 'description' => 'Focus Keyphrase'],
        ],
        'outputFields' => [
            'success' => ['type' => 'Boolean'],
            'post' => ['type' => 'Post'],
        ],
        'mutateAndGetPayload' => function($input) {
            $post_id = absint($input['postId']);

            if (!current_user_can('edit_post', $post_id)) {
                throw new \GraphQL\Error\UserError('You do not have permission to edit this post.');
            }

            if (isset($input['title'])) {
                update_post_meta($post_id, '_yoast_wpseo_title', sanitize_text_field($input['title']));
            }
            if (isset($input['metaDesc'])) {
                update_post_meta($post_id, '_yoast_wpseo_metadesc', sanitize_textarea_field($input['metaDesc']));
            }
            if (isset($input['focusKeyphrase'])) {
                update_post_meta($post_id, '_yoast_wpseo_focuskw', sanitize_text_field($input['focusKeyphrase']));
            }

            return [
                'success' => true,
                'post' => get_post($post_id),
            ];
        }
    ]);
});

Configuration

Create a

config.json
in the skill directory:

{
  "wordpress": {
    "graphql_url": "https://your-site.com/graphql",
    "username": "your-username",
    "app_password": "your-app-password"
  },
  "batch": {
    "size": 10,
    "delay_seconds": 1
  },
  "state_file": "./seo_update_progress.json"
}

Or use environment variables:

  • WP_GRAPHQL_URL
  • WP_USERNAME
  • WP_APP_PASSWORD

Workflow

Step 1: Analyze Posts for SEO Issues

python scripts/analyze_seo.py --all --output analysis.json

This fetches posts and identifies SEO issues (missing titles, too long descriptions, etc.). Output includes instructions for Claude to generate optimized SEO content.

Step 2: Generate Optimized SEO Content

Claude analyzes the

analysis.json
output and generates a
changes.json
file with:

  • Optimized SEO titles (50-60 chars)
  • Compelling meta descriptions (150-160 chars)
  • Relevant focus keyphrases

Step 3: Preview Changes (Dry Run)

python scripts/preview_changes.py --input changes.json

Step 4: Apply Updates

python scripts/yoast_batch_updater.py --input changes.json --apply

Step 5: Resume if Interrupted

python scripts/yoast_batch_updater.py --resume

Input Format

The skill expects a JSON file with changes:

{
  "updates": [
    {
      "post_id": 123,
      "post_title": "Original Post Title",
      "current": {
        "seo_title": "Old Title | Site Name",
        "meta_desc": "Old description"
      },
      "new": {
        "seo_title": "New Optimized Title | Site Name",
        "meta_desc": "New compelling meta description under 160 chars"
      }
    }
  ]
}

Output

The skill produces:

  1. Preview report showing before/after for each post
  2. Progress state file for resuming interrupted batches
  3. Final report with success/failure counts

Safety Features

  • Dry-run mode by default - preview before applying
  • Confirmation prompt before batch updates
  • Progress tracking - resume interrupted sessions
  • Rate limiting - configurable delay between API calls
  • Backup - logs current values before changing

Example Usage

User: "Update the meta descriptions for all posts in the 'tutorials' category to be more compelling"

Claude will:

  1. Run
    analyze_seo.py
    to fetch posts and identify SEO issues
  2. Analyze each post's content and current SEO data
  3. Generate optimized titles, descriptions, and keyphrases
  4. Create a
    changes.json
    file with the improvements
  5. Run
    preview_changes.py
    to show before/after comparison
  6. Ask for confirmation
  7. Run
    yoast_batch_updater.py --apply
    to apply changes
  8. Report results with success/failure counts