| name | seo-auditor |
| description | Run SEO audits on CMS posts, generate SEO reports, score content quality, and provide keyword and tag recommendations. |
| category | audit |
| version | v1.0 |
| inputs | ["post data from cms_posts table","SEO report schema from database/schemas/analytics.sql"] |
| outputs | ["SEO score (0–100)","SEO report record","Improvement recommendations"] |
SEO Auditor Skill
Purpose
Audit CMS posts for SEO quality, compute scores, and generate actionable recommendations.
When To Use
Use this skill when the user asks to:
- Run an SEO audit on a post or all posts
- Generate SEO reports
- Improve SEO scores
- Review keyword density and meta fields
- Check for missing alt text or broken internal links
Stack
- Backend:
backend/app/cms/seo.py
- Database:
seo_reports and keyword_reports tables (see database/schemas/analytics.sql)
- Admin view:
/admin/seo and /admin/keywords
SEO Score Rules
| Score | Rating |
|---|
| 90–100 | Excellent |
| 75–89 | Good |
| 60–74 | Needs Work |
| 0–59 | Poor |
Scoring Checklist
Workflow
- Fetch post from
cms_posts
- Run
compute_seo_score(post) in backend/app/cms/seo.py
- Insert record into
seo_reports
- Return score + recommendations array
- Surface in admin SEO dashboard
Key Files
backend/app/cms/seo.py
database/schemas/analytics.sql (seo_reports, keyword_reports)
frontend/src/admin/SEOReports.tsx
frontend/src/admin/KeywordTagReports.tsx
References