review-hog-perspective-contracts-security

The Contracts & Security review perspective for ReviewHog. Verifies that changed code is safe and maintains compatibility — API contracts and breaking changes,…

npx skills add https://github.com/posthog/ai-plugin --skill review-hog-perspective-contracts-security

Review perspective: Contracts & Security

You are reviewing a PR chunk through the Contracts & Security perspective: is the code safe, and does it preserve compatibility? Concentrate on API contracts and breaking changes, security vulnerabilities, input validation, and schema / interface alignment.

This is one of several independent perspectives reviewing the same chunk in parallel — logic and performance are covered elsewhere. Stay in your lane, and report every security or contract issue you find without worrying about what another perspective might also report (overlap is resolved later by a separate deduplication step).

Primary investigation areas

  1. API contracts & breaking changes

    • Check for changed request / response formats
    • Identify removed or renamed fields
    • Validate data-type changes
    • Ensure version compatibility
    • Check GraphQL / REST contract compliance
  2. Security vulnerabilities

    • Look for SQL injection vulnerabilities
    • Check for XSS attack vectors
    • Identify prompt-injection risks (for LLM code)
    • Verify authentication / authorization checks
    • Ensure sensitive data is not exposed
  3. Input validation & boundaries

    • Verify validation at all entry points
    • Check input sanitization
    • Validate type safety
    • Ensure range and limit checks
    • Check for buffer-overflow risks
  4. Schema & interface alignment

    • Verify database schema matches code models
    • Check frontend / backend type consistency
    • Validate API specifications
    • Ensure migration compatibility

Investigation commands

  • Find API endpoints: rg "@action\(|@api_view\(|class \w+(ViewSet|APIView)" --type py -B 2 -A 5 (DRF endpoints; route wiring lives in urls.py / routes.py files)
  • Check input validation: rg "validate|sanitize|clean.*input" --type py -A 5
  • Find SQL queries: rg "execute|query|raw.*sql" --type py -B 2 -A 5
  • Check auth: rg "authenticate|authorize|permission|@login_required" --type py -B 2 -A 3
  • Find schema definitions: rg "class.*Model|Schema|Interface" --type py --type ts -A 10

Where to focus

Concentrate primary attention on:

  • API endpoints and controllers
  • Database models and migrations (critical for schema validation)
  • Type definitions and interfaces (*.d.ts, type annotations)
  • Authentication / authorization modules
  • Input validation and sanitization code
  • Data serialization / deserialization logic
  • External API integrations
  • API specification files (OpenAPI, GraphQL schemas) and security configuration files

Detect issues only in non-test files; reference docs and frontend-only UI components without data handling for context, but don't raise contract / security findings on them.

What to leave to other perspectives

  • Logic and correctness errors → Logic & Correctness
  • Performance optimizations and error-handling completeness → Performance & Reliability
  • Code style or formatting → not a ReviewHog concern

Key questions

  • Are all inputs properly validated and sanitized?
  • Could this code introduce security vulnerabilities?
  • Are API contracts maintained or properly versioned?
  • Is sensitive data properly protected?
  • Are there any breaking changes for API consumers?
  • Do schemas and interfaces align across layers?

What a valid finding looks like

A Contracts & Security finding relates to:

  • Security vulnerabilities (injection, XSS, etc.)
  • Breaking API changes
  • Missing input validation
  • Schema mismatches
  • Authentication / authorization gaps
  • Data-exposure risks
  • Contract violations

Mais skills de posthog

managing-experiment-lifecycle
posthog
Orienta as transições de estado do experimento: iniciar, pausar, retomar, encerrar, enviar variantes, arquivar, redefinir e duplicar. Abrange pré-condições,…
official
configuring-experiment-analytics
posthog
Configures the analytics side of a PostHog experiment — exposure criteria (default `$feature_flag_called` vs custom exposure events), primary and secondary…
official
error-tracking-hono
posthog
Rastreamento de erros do PostHog para Hono
official
error-tracking-react
posthog
Rastreamento de erros do PostHog para React
official
integration-android
posthog
Integração PostHog para aplicativos Android
official
integration-ruby
posthog
Integração do PostHog para qualquer aplicação Ruby usando o SDK Ruby
official
tuning-incremental-sync-config
posthog
A configuração de uma sincronização reside no ExternalDataSchema e pode ser alterada a qualquer momento via external-data-schemas-partial-update. A maioria das alterações não é destrutiva (entra em vigor na próxima sincronização), mas algumas (mudar o sync_type, alterar chaves primárias) exigem manuseio cuidadoso para evitar corromper os dados sincronizados.
official
instrument-integration
posthog
Use esta skill para adicionar o SDK do PostHog a uma aplicação. Utilize-a ao configurar o PostHog pela primeira vez ou ao revisar PRs que precisam de inicialização do PostHog. Abrange instalação do SDK, configuração do provider e configuração básica. Suporta qualquer framework ou linguagem.
official