Agent skill · writing content · aradotso
geoflow-content-automation
GEOFlow open-source GEO/SEO content production system with AI generation, review workflow, and publishing pipeline built on PHP and PostgreSQL.
Why this skill is useful
Provides specific commands and configurations for setting up and managing the GEOFlow content automation system, which the AI wouldn't reliably generate on its own.
What it needs
Requires docker, php, postgresql installed locally. Requires openai account access. About 7k tokens when loaded. Last updated 2026-07-09. 70 stars on the source repository.
What this skill does
GEOFlow Content Automation Skill by ara.so — Daily 2026 Skills collection. GEOFlow is an open-source PHP/PostgreSQL system for automated GEO/SEO content production. It chains model configuration, material management, task scheduling, draft review, and front-end publishing into a single pipeline. It supports any OpenAI-compatible API, runs on Docker Compose, and exposes both a REST API and a CLI. --- Installation Docker (Recommended) Local PHP Server Requirements: PHP 7.4+, extensions pdopgsql and curl, PostgreSQL instance. --- Environment Variables Generate a secure key: --- Default Credentials After first boot, log in at /geoadmin/ with: Username: admin Password: admin888 Change both immediately and rotate APPSECRETKEY before any public deployment. --- Docker Services Service Purpose Profile --- --- --- web Front-end + admin HTTP always postgres PostgreSQL database always scheduler Scans tasks, writes job queue scheduler worker Calls AI API, generates content scheduler --- Content Generation Pipeline --- Admin Workflow 1. Add an AI Model Navigate to AI配置中心 → AI模型管理 and fill in: API Base URL (e.g. https://api.openai.com/v1) Model ID (e.g. gpt-4o) API Key (stored encrypted; reference $AIAPIKEY in your env) 2. Create Materials 标题库 — Title pool the task draws from 图片库 — Image pool for article illustrations 知识库 — Reference knowledge injected into prompts 提示词模板 — Prompt templates with placeholders 3. Create a Task Navigate to 任务管理 → 新建任务: 4. Monitor Execution 任务管理 — Task status, retry controls 文章管理 — Draft/review/published states 审核中心 — Review queue for human approval --- CLI (bin/geoflow) The CLI is the programmatic interface used by automation scripts and the companion skill yaojingang/yao-geo-skills. --- REST API (/api/v1) All endpoints require Bearer token authentication. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aradotso/geoflow-content-automation