geoflow-content-automation

GEOFlow is an open-source PHP and PostgreSQL system for automated GEO and SEO content production. It manages AI model configuration, content task scheduling, draft review workflows, and front-end publishing through a REST API, CLI, and Docker-based architecture.

373
Installs
5
Use cases
9/10
Quality

Is geoflow-content-automation safe to install?

Review the source first

Review the source first: our audit of geoflow-content-automation's source files found 24 shell commands, 1 external URL, file reads and writes (high risk). Every command and URL listed appears verbatim in the skill's source. The tool executes shell commands for system management and makes network requests to external AI APIs. It also performs read and write operations on local files and a PostgreSQL database.

How we audit skills: our security review methodology.

Who is this skill for?

Developers and content managers who need an automated, self-hosted pipeline for generating and publishing SEO-optimized content using OpenAI-compatible AI models.

What can you do with it?

  • Automated SEO content generation using prompt templates
  • Managing content review workflows from draft to publication
  • Scheduling content tasks via cron-based job queues
  • Integrating content publishing pipelines via REST API
  • Managing title, image, and knowledge base pools for AI generation

How good is this skill?

Quality score: 9/10. The documentation is comprehensive, providing clear installation steps, CLI usage, API endpoints, and security best practices.

What does the skill file contain?

SKILL.md
# GEOFlow Content Automation

> Skill by [ara.so](https://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)

```bash
git clone https://github.com/yaojingang/GEOFlow.git
cd GEOFlow
cp .env.example .env
# Edit .env — set APP_SECRET_KEY, SI...

Frequently asked questions

What are the system requirements for GEOFlow?

GEOFlow requires PHP 7.4 or higher, the pdo_pgsql and curl PHP extensions, and a PostgreSQL database instance.

How does the content generation pipeline work?

The scheduler writes tasks to a job_queue table, which the worker processes by calling an AI API to generate content before moving the article through draft, review, and publish states.

Can I use models other than OpenAI?

Yes, GEOFlow supports any OpenAI-compatible API by configuring the API Base URL and Model ID in the AI model management section.

How do I secure my GEOFlow installation?

Change the default admin credentials immediately, set a secure 32-character APP_SECRET_KEY, and restrict access to the admin and API endpoints via network-level firewalls.

Data sourced from aradotso/trending-skills on GitHub. Install counts from skills.sh. The summary and security audit are derived from the skill's source files: every command and URL listed appears verbatim in the source.

Related skills

seo-audit

133.3K

Users seeking to diagnose SEO issues, improve organic search performance, or conduct a health check on their website

The seo-audit skill provides a structured framework for diagnosing and recommending improvements for website search engine optimization. It guides the agent through technical, on-page, and content quality assessments, including specific checks for international SEO and site-type-specific issues.

highseoauditcoreyhaines31

content-strategy

86.4K

Content marketers, founders, and marketing teams planning content roadmaps and editorial calendars

The content-strategy skill assists users in planning content strategies, identifying topics, and building editorial calendars. It guides users through gathering business context, researching customers, analyzing competitors, and mapping content to the buyer's journey. It provides frameworks for searchable and shareable content, pillar identification, and topic clustering.

lowcontent-strategymarketingcoreyhaines31

programmatic-seo

83.5K

Content strategists, SEO specialists, and marketers building large-scale, data-driven website content

The programmatic-seo skill provides a framework for generating SEO-optimized pages at scale using templates and data. It guides users through keyword research, data sourcing, template design, internal linking, and indexation strategies while emphasizing content uniqueness to avoid search engine penalties.

lowseomarketingcoreyhaines31

ai-seo

70.6K

Content creators, SEO professionals, and digital marketers aiming to improve their brand's presence in AI-generated search results

The ai-seo skill provides a framework for optimizing web content to increase visibility and citation rates in AI-powered search engines and LLM-based assistants like ChatGPT, Perplexity, and Google AI Overviews.

lowseoaicoreyhaines31