skills.rest
anxun-agent
anxun-agentCOMMUNITY
Explore all skills by this author →
GitHub

Keyword Fetcher

Extract and deduplicate SEO keywords from ODPS databases into JSON.

Updated Apr 13, 2026
Search Tags:#SEO optimization#JSON output#keyword collection#ODPS#keyword deduplication
One-click install
npx skills add https://github.com/anxun-agent/seov2 --skill keyword-fetcher
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Keyword Fetcher
Source: https://github.com/anxun-agent/seov2/tree/main/keyword-fetcher
Command: npx skills add https://github.com/anxun-agent/seov2 --skill keyword-fetcher

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires odps, sqlrunner, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

Streamlines the process of collecting SEO keywords from ODPS data仓库, providing a standardized JSON output for further processing in GEO-related workflows.

Core Features & Use Cases

  • ODPS Data Access: Retrieves and filters SEO keywords from the Open Data Processing Service (ODPS) data warehouse.
  • Standardized Output: Outputs a keywords.json file formatted for consumption by GEO generation tools like geo-blog-topic-generator and geo-article-pipeline.
  • Use Case: Simplifies the deduplication and validation of keywords for article generation pipelines.

Quick Start

Use the Keyword Fetcher skill to extract keywords from your specified ODPS SQL query and generate the keywords.json file.

Frequently Asked Questions about Keyword Fetcher

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I extract SEO keywords from an ODPS data warehouse?▼

To extract SEO keywords from an ODPS data warehouse, you can use custom SQL queries to retrieve and filter data directly from the database, ensuring specific keywords are collected for downstream processing.

What is the best way to format ODPS keywords for GEO article generation pipelines?▼

The best way to format ODPS keywords for GEO article generation is to generate a standardized keywords.json file, which ensures seamless integration with downstream content generation tools.

Can I use custom SQL queries to filter and deduplicate keywords for SEO optimization?▼

Yes, you can use custom SQL queries to filter keywords from ODPS, and the skill supports keyword deduplication and validation to ensure clean inputs for SEO optimization.

Does ODPS keyword collection support language-specific processing for SEO?▼

Yes, ODPS keyword collection supports language-specific processing to handle varied SEO optimization requirements, ensuring keywords are validated correctly before generating the final JSON output.

What are the limitations of using ODPS for keyword collection in GEO workflows?▼

The primary limitation is the strict dependency on ODPS and SQLRunner environments, meaning you cannot use this keyword collection method without establishing proper data warehouse connectivity first.

Related Skills

Explore More Marketing & Sales Skills→
stahurastahura
19

sql-query

Execute raw SQL queries against dataset aliases and parse columnar responses into row objects.

Community
Intermediate
jamesrochabrunjamesrochabrun
194

content-brief-generator

Generate structured content briefs with audience, SEO, and tone guidance.

Community
Advanced
fkubotafkubota
7

sql-format

Format SQL queries with lowercase keywords, line-start commas, and CTE formatting.

Community
Intermediate
lastmjslastmjs

episode-generate-metadata

Generate title, notes, and keywords from podcast episode text into JSON.

Community
Basic