João Guirunas
Community@joaoguirunas
João Guirunas maintains 64 skills spanning social media production, paid traffic analytics, Next.js frontend engineering, data platforms, and B2B sales proposal operations.
Agent Skills by João Guirunas
Showing 64 vetted skills indexed across 1 GitHub repositories.
joaoguirunassocial-format-specs
Validates video and photo exports against platform-specific format specifications for social media.
joaoguirunasdev-error-handling
Implements retry, circuit breaker, timeout, and structured error handling patterns for TypeScript services.
joaoguirunassites-seo-keywords
Plans keyword research, search intent classification, and page-level keyword mapping for SEO content strategy.
joaoguirunasui-ux-pro-max
Generates design system recommendations and searches UI/UX guidelines via a BM25-based CLI.
joaoguirunasdev-security-patterns
Implements authentication, authorization, RLS, input validation, and OWASP mitigations for web applications.
joaoguirunastraffic-google-ads-mcp
Queries Google Ads account and campaign data via the official read-only Google Ads MCP server using GAQL.
joaoguirunassocial-meta-publishing
Publishes and schedules approved content to Instagram and Facebook via Meta MCP.
joaoguirunassites-page-cro
Structures landing page optimization guidance covering hierarchy, trust signals, and friction reduction.
joaoguirunassocial-key-visual
Creates key visual identities for social media campaigns including palette, typography, and format derivations.
joaoguirunasdata-supabase-patterns
Applies Postgres and Supabase best practices for indexing, RLS, pooling, and migrations.
joaoguirunassocial-stitch-workflow
Generates social media key visuals and design variants via Google Stitch MCP.
joaoguirunasdata-analytics-engineering
Design dbt models, semantic layers, and data quality tests for analytics pipelines.
joaoguirunasverify-before-done
Enforces evidence-based verification before declaring tasks, stories, or QA verdicts complete.
joaoguirunassales-discovery-intake
Convert sales meeting transcripts and emails into a structured client intake sheet.
joaoguirunasweb-design-guidelines
Reviews UI code against Vercel Web Interface Guidelines and reports violations in file:line format.
joaoguirunassites-deployment
Deploy Next.js sites to Vercel, Netlify, and Cloudflare Pages with CI/CD pipelines.
joaoguirunassites-scroll-motion
Implements scroll-driven animations, parallax, and 3D scenes for Next.js websites using CSS, Framer Motion, and Three.js.
joaoguirunassocial-heygen-avatar
Generates AI avatar videos, image animations, and multilingual dubbing via the HeyGen API.
joaoguirunassocial-apify-research
Scrapes Instagram and TikTok via Apify MCP to analyze trends, competitors, and hashtags.
joaoguirunasdeep-research
Generates citation-tracked research reports through a multi-phase pipeline with evidence persistence and claim verification.
joaoguirunassocial-freepik-generation
Generates AI image prompts for Freepik with photographic styles and social media format specifications.
joaoguirunasdev-api-design
Defines REST and tRPC API design standards including error responses, versioning, and requestId propagation.
joaoguirunasai-ml-data-science
Guides end-to-end ML workflows from EDA and feature engineering to model evaluation and production handoff.
joaoguirunassales-pricing-payback
Calculates pricing, discount cost, breakeven, and client payback for commercial proposals.
Frequently Asked Questions About João Guirunas
FAQPage SchemaWhat tasks can I accomplish with João Guirunas's skill collection?▼
The 64 skills cover five areas: social content production (copywriting, scriptwriting, carousel design, ffmpeg video editing, Meta publishing), paid traffic (Google Ads GAQL queries, GA4 reporting, budget pacing), Next.js frontend (SEO, accessibility, scroll animation, deployment), data engineering (Supabase/Postgres, SQL optimization, dbt, lakehouse), and B2B sales (proposals, pricing, negotiation).
Who is the target audience for these skills?▼
The skills target marketing operators running social and paid campaigns, frontend engineers building Next.js sites with Tailwind and shadcn/ui, data engineers working with Postgres/Supabase and analytics stacks, and sales teams producing proposals, decks, and pricing models. Several skills reference Claude Code agent squads for coordinated execution.
How do the Google Ads and GA4 integration skills work in practice?▼
The traffic-google-ads-mcp and traffic-ga4-mcp skills use the official Google MCP servers. They provide GAQL query cookbooks, account discovery, read-only reporting limits, realtime tracking validation, funnel analysis, and dimension/metric dictionaries for auditing campaign performance and reconciling platform discrepancies.
Are these skills open source and what do they cost?▼
Licensing varies per skill: accessibility and negotiation are explicitly MIT-licensed, while most skills declare no license in their frontmatter. The skills themselves are prompt/instruction packages with no stated cost, though some depend on external paid services like HeyGen, Freepik, Apify, and Google Ads API access.
What prerequisites or dependencies do these skills require?▼
Dependencies are skill-specific: social publishing requires Meta MCP access, ads analytics requires the official Google Ads and GA4 MCP servers, video editing requires ffmpeg, frontend skills assume Next.js App Router with Tailwind v4 and shadcn/ui, and team-os skills require Claude Code with CLAUDE_CODE_EXPERIMENTAL_AGENT_TEAMS enabled.