Platform Knowledge Skill

Overview

Platform Overview

GitHub Actions

• Purpose: CI/CD automation
• Key Features: Workflow automation, testing, deployment
• Config Files:

  .github/workflows/*.yml

• CLI:

  gh

Railway

• Purpose: Application hosting and deployment
• Key Features: Auto-deployments, instant rollbacks, environment management
• Config Files:

  railway.toml

  ,

  nixpacks.toml

  ,

  Procfile

• CLI:

  railway

Supabase

• Purpose: Backend-as-a-Service (Postgres, Auth, Storage, Realtime)
• Key Features: Managed Postgres, authentication, file storage, realtime subscriptions
• Config Files:

  supabase/config.toml

  , migrations
• Access: MCP tools, Dashboard, CLI

Postgres

• Purpose: Relational database
• Key Features: ACID compliance, extensions, full-text search, JSON support
• Config: Connection strings, postgresql.conf
• Access: SQL queries via MCP or psql

Platform Interaction Map

┌──────────────┐     ┌──────────────┐
│   GitHub     │     │   Railway    │
│   Actions    │────▶│   (App)      │
│   (CI/CD)    │     │              │
└──────────────┘     └──────┬───────┘
                            │
                            ▼
                     ┌──────────────┐
                     │   Supabase   │
                     │   (Backend)  │
                     │              │
                     │ ┌──────────┐ │
                     │ │ Postgres │ │
                     │ └──────────┘ │
                     └──────────────┘

Quick Reference

Tool Access by Platform

gh

gh run view --log

railway

railway logs

supabase

get_logs

psql

get_logs

Common Operations

railway up

gh run view --log

railway logs

get_logs

gh run list

railway status

get_project

Troubleshooting Decision Tree

Issue Reported
     │
     ▼
┌─────────────────────────────────────┐
│ Where does the issue manifest?      │
└─────────────────────────────────────┘
     │
     ├─► Build/Deploy fails ──► GitHub Actions / Railway
     │
     ├─► API errors ──► Supabase API / Edge Functions
     │
     ├─► Auth issues ──► Supabase Auth
     │
     ├─► Database errors ──► Postgres
     │
     ├─► App crashes ──► Railway / Edge Functions
     │
     └─► Performance ──► All platforms (profile each)

Platform-Specific Guides

• GitHub Actions - CI/CD workflows, secrets, debugging
• Railway - Deployment, configuration, troubleshooting
• Supabase - Auth, API, Realtime, Storage
• Postgres - Queries, performance, administration

Cross-Platform Issues

Deployment Chain Failure

1. GitHub Actions - Build/test passed?
2. Railway - Deploy successful?
3. Supabase - Migrations applied?
4. Environment - Variables set?

Environment Variable Issues

• Set in wrong environment
• Typo in variable name
• Not propagated after change

# GitHub Actions - Check secrets
# (Can't view, only verify existence)

# Railway
railway variables

# Supabase - Check project settings
# Dashboard or MCP

Connection Issues Between Services

• Check Supabase URL format
• Verify API key (anon vs service_role)
• Check connection pooling settings
• Verify IP restrictions

• Check secrets are accessible
• Verify network egress allowed
• Check for rate limiting

Performance Troubleshooting Matrix

Configuration Files Reference

GitHub Actions

# .github/workflows/deploy.yml
name: Deploy
on: [push]
jobs:
  build:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      # ... more steps

Railway

# railway.toml
[build]
builder = "nixpacks"
buildCommand = "npm run build"

[deploy]
startCommand = "npm start"
healthcheckPath = "/health"

Supabase

# supabase/config.toml
[api]
port = 54321
schemas = ["public", "graphql_public"]

[db]
port = 54322

Postgres

-- Key settings
SHOW max_connections;
SHOW statement_timeout;
SHOW work_mem;