Claude Skills by jeremylongshore

'Master Shopify''s calculated query cost system to avoid throttling.

'Create a minimal working Shopify app that queries products via GraphQL

'Execute Shopify incident response with triage using Shopify status page,

'Install and configure Shopify app authentication with OAuth, session

'Identify and avoid Shopify API anti-patterns: ignoring userErrors, wrong

'Load test Shopify integrations respecting API rate limits, plan capacity

'Configure Shopify local development with Shopify CLI, hot reload, and

'Model custom data with Shopify metafields and metaobjects via the GraphQL

'Migrate e-commerce data to Shopify using bulk operations, product imports,

'Configure Shopify apps across development, staging, and production environments

'Set up observability for Shopify app integrations with query cost tracking,

'Optimize Shopify API performance with GraphQL query cost reduction,

'Implement Shopify app policy enforcement with ESLint rules for API key

'Execute Shopify app production deployment checklist covering App Store

'Handle Shopify API rate limits for both REST (leaky bucket) and GraphQL

'Implement Shopify app reference architecture with Remix, Prisma session

'Implement reliability patterns for Shopify apps including circuit breakers

'Apply production-ready patterns for @shopify/shopify-api including typed

'Apply Shopify security best practices for API credentials, webhook HMAC

'Build headless storefronts with Shopify''s Storefront API and Cart API.

'Optimize Shopify theme performance for Core Web Vitals (LCP, CLS, INP).

'Upgrade Shopify API versions and migrate from REST to GraphQL with breaking

'Register and handle Shopify webhooks including mandatory GDPR compliance

'Simulate flash loan strategies with profitability calculations and risk

'Execute analyzes existing plugins to extract their capabilities, then

'Create production-grade agent skills aligned with the 2026 AgentSkills.io

Audit Snowflake effective access and produce a safe least-privilege change packet. Trace account-role inheritance, primary and secondary roles, managed-access schemas, ownership, direct-to-user/PUBLIC grants, orphaned principals, and existing-versus-future-grant conflicts. Use when access is unexpectedly broad or denied, a role graph needs review, or an authorization cleanup needs evidence. Trigger with phrases like "Snowflake access audit", "trace Snowflake grants", "why can this user read",...

Audit Snowflake warehouse and query-attribution evidence to locate idle compute, unallocated or untagged usage, query-acceleration spend, and serverless visibility gaps without guessing prices or savings. Use when a Snowflake bill increased, a team needs chargeback/showback evidence, warehouse credits appear unexplained, or an operator asks which usage merits investigation. Trigger with "Snowflake bill increased", "find idle Snowflake credits", "Snowflake cost attribution", or "untagged Snowf...

Assess Snowflake data metric function coverage and current quality evidence without reading customer rows. Use when expectations or anomaly monitoring may be violated, stale, suspended, incomplete, mis-scoped, or unavailable, or when an operator needs separate data-quality and monitoring verdicts. Trigger with "Snowflake data quality", "DMF expectation", "expectation violation", "anomaly training", "data quality monitoring gap", or "stale DMF result".

Review and safely diagnose Snowflake infrastructure and database deployments across the snowflakedb/snowflake Terraform 2.x provider, grants/state/imports, schemachange versioned and repeatable migrations, Snowflake CLI/drivers, and behavior-change releases. Use before a production deploy, when a plan wants to replace or revoke grants, state is unreadable, a migration checksum drifts, or a CLI/driver upgrade changes behavior. Produces a zero-change/plan verdict, ordered remediation, and teste...

Assess Snowflake replication and failover-group readiness without performing a refresh, promotion, redirect, cancellation, resume, failover, or failback. Use when defining RPO/RTO, preparing or reviewing a Business Critical disaster- recovery exercise, diagnosing replication history, checking cross-group object dependencies, or verifying an operator-executed failover/failback receipt. Produces a deterministic readiness verdict, evidence gaps, abort gates, and an operator runbook boundary. Tri...

Diagnose production Snowflake pipelines spanning tasks, task graphs, streams, dynamic tables, and Snowpipe. Use when a pipeline is stale, skipped, suspended, lagging, duplicating rows, failing after a schema/object change, or missing file notifications. The skill builds a read-only evidence graph, walks every supplied dependency branch, and returns an ordered recovery plan with post-fix invariants. It never resumes, refreshes, recreates, replays, deploys, or mutates Snowflake automatically. T...

Audit, analyze, and diagnose completed or failed Snowflake queries from query history, Query Insights, and GET_QUERY_OPERATOR_STATS evidence. Use when investigating slow queries, queueing, lock waits, local or remote spill, poor pruning, exploding joins, repeated query-hash regressions, or requests for a defensible query root-cause packet. Trigger with "Snowflake query spilled", "why is this Snowflake query queued", "Snowflake query ID", "exploding join", or "Snowflake pruning regression". Do...

Pilot a Snowflake authentication modernization without lockouts or credential exposure. Inventory PERSON, SERVICE, and LEGACY_SERVICE users; map named workloads to WIF, key pair, OAuth, or bounded PAT; and audit managed MCP/OAuth session controls. Use when replacing Snowflake passwords, reviewing service identities, planning workload identity federation, or scoping MCP OAuth. Trigger with phrases like "Snowflake auth migration", "service user password", "Snowflake WIF", "key pair rotation", o...

'GitHub Actions pipeline for Speak integrations with mocked API tests

'Diagnose and fix common Speak API errors: authentication failures, audio

'Execute Speak primary workflow: AI Conversation Practice with real-time

'Execute Speak secondary workflow: Pronunciation Training with phoneme-level

'Optimize Speak API costs through usage monitoring, tier selection, and

'Handle student audio data, assessment records, and learning progress

'Collect diagnostic information for Speak API issues: auth verification,

'Deploy Speak language learning features to Vercel, Cloud Run, or containerized

'Configure Speak for schools and organizations: SSO, teacher/student

'Create your first Speak AI tutoring session with pronunciation feedback.

'Incident response for Speak API outages: triage, fallback to offline

'Set up Speak language learning API integration and authentication.

'Configure Speak local development with mocked tutors and audio testing.

'Migrate between language learning platforms, import student progress,

'Configure Speak across dev, staging, and production with separate API

'Monitor Speak API health, assessment latency, session metrics, and pronunciation