AI-SEO System Desktop GUI Development

We are building a desktop GUI application to manage and monitor our AI-powered SEO Automation System. The system already runs on Ubuntu with Python, PostgreSQL, and Qdrant, and includes competitor scraping, SEO audits, and cron-based automation. We now need a user-friendly local GUI to simplify control and monitoring.

Project Scope

Wrap existing Python CLI scripts in a GUI (start/stop modules, run scrapers, trigger audits).

Display logs in real time (from /opt/ai-seo/logs/).

Database integration (PostgreSQL):

View task history (task_logs)

Review audit results (page_audits, audit_issues)

Show competitor data (competitor_pages)

Controls for system tasks:

Run daily/weekly scrapes

Trigger backups / verify jobs

Toggle review vs auto mode (from .env/config)

Basic dashboards (summaries of backlinks, citations, content drafts, errors).

Technical Requirements

Python GUI framework: PyQt5/PySide (preferred) or Tkinter/Kivy.

Alternative option: Electron.js or Tauri desktop app that integrates with Python scripts.

DB experience: PostgreSQL (psycopg2/SQLAlchemy).

System knowledge: Familiarity with CLI tools, cron jobs, subprocess handling.

Packaging: Deliverable must be installable as a local desktop app (.exe for Windows and/or .deb/.AppImage for Linux).

Deliverables

Cross-platform GUI app with clean UI (tabs or sidebar navigation).

Integrated controls to run/stop scripts and display results.

Database connections for read-only dashboards.

Installation package + documentation for setup.

Source code (well-commented, modular, version-controlled).

Ideal Candidate

Strong background in Python GUI development (PyQt / PySide / Tkinter).

Experience integrating Python automation scripts into desktop apps.

Familiar with PostgreSQL, logging, and API connectors.

Able to design a clean, functional UI for technical operators.

Bonus: SEO tools or data scraping experience.