Set up a data ingestion or sync pipeline — from source to destination, with transformation. Supports Airbyte, custom ETL scripts, and webhook-based ingestion. Use when the user says "sync data from X", "pull data into the DB", "set up a pipeline", or "ingest from API".

Generate and run realistic seed data for the project's database. Use when the user says "seed the database", "add some fake data", "I need test data", or the app looks empty during a demo.

Operate Railway infrastructure: create projects, provision services and databases, manage object storage buckets, deploy code, configure environments and variables, manage domains, troubleshoot failures, check status and metrics, and query Railway docs. Use this skill whenever the user mentions Railway, deployments, services, environments, buckets, object storage, build failures, or infrastructure operations, even if they don't say "Railway" explicitly.

Add a demo mode to the app that bypasses auth and loads mock data, so the app works flawlessly during a hackathon presentation without needing a real account or live backend. Use when the user says "set up demo mode", "make it work without login", or "I need it to look good for the judges".

Generate a structured mental model of an unfamiliar codebase — entry points, data flow, key abstractions, and gotchas. Use when starting on a new repo, when the user says "explain this codebase", "how does this work", "onboard me", or before making large changes to unfamiliar code.

Autonomous multi-source security intelligence agent. Scans GitHub PRs for vulnerabilities using cross-source context from Slack and codebase architecture. Finds risks that single-source scanners miss by correlating data across tools.

Generate a structured implementation plan before writing any code. Produces a spec with requirements, data model, API surface, edge cases, and open questions. Use when starting a non-trivial feature, when the user says "plan this out", or before any implementation that touches more than 2 files.

Sets up and operates Airbyte Agent Connectors — strongly typed Python packages for accessing 51+ third-party SaaS APIs through a unified entity-action interface. Supported services include Salesforce, HubSpot, Stripe, GitHub, Slack, Jira, Shopify, Zendesk, Google Ads, Notion, Linear, Intercom, Gong, and 36 more connectors spanning CRM, billing, payments, e-commerce, marketing, analytics, project management, helpdesk, developer tools, HR, and communication platforms. Make sure to use this skill when the user wants to connect to any SaaS API, install an airbyte-agent connector package, integrate third-party service data into a Python application or AI agent, query or search records from any supported service, or configure Airbyte MCP tools for Claude. Covers Platform Mode (Airbyte Cloud) and OSS Mode (local Python SDK).

Audit the app for real-time performance bottlenecks and fix them — slow queries, missing indexes, N+1 problems, cache misses, and polling that should be websockets. Use when the user says "make it faster", "it's slow under load", "optimize the DB", or "add real-time updates".