Geoflow Content Automation

GEOFlow is a PHP/PostgreSQL pipeline for automating SEO content at scale. It chains AI model config, material libraries, task scheduling, draft review, and publishing into one system with both a web admin panel and REST API. The skill helps you stand up the Docker stack, wire up OpenAI-compatible models, create content tasks that pull from title and image libraries, and monitor the scheduler/worker pair that actually calls the API and generates articles. It's built for teams running content farms or affiliate sites who want human approval gates before auto-publish. The CLI and API examples are solid if you're scripting bulk operations or integrating with external CMSes.

skills.sh installs: 335
GitHub stars: 26
last updated: Jun 3, 2026

View on GitHub

Install

$ npx -y skills add aradotso/trending-skills --skill geoflow-content-automation --agent claude-code

Installs into .claude/skills of the current project.

Files

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)

git clone https://github.com/yaojingang/GEOFlow.git
cd GEOFlow
cp .env.example .env
# Edit .env — set APP_SECRET_KEY, SITE_URL, and DB credentials
vi .env

# Start web + postgres + scheduler + worker
docker compose --profile scheduler up -d --build

# Front-end
open http://localhost:18080
# Admin panel
open http://localhost:18080/geo_admin/

Local PHP Server

git clone https://github.com/yaojingang/GEOFlow.git
cd GEOFlow

export DB_DRIVER=pgsql
export DB_HOST=127.0.0.1
export DB_PORT=5432
export DB_NAME=geo_system
export DB_USER=geo_user
export DB_PASSWORD=geo_password
export APP_SECRET_KEY=$(openssl rand -hex 32)
export SITE_URL=http://localhost:8080

SKILL.md on GitHub