Does it provide a database schema?

Yes, the skill includes a SQL schema requirement for a 'subscribers' table optimized for Supabase/PostgreSQL.

What Stripe events are supported out of the box?

It includes logic for checkout.session.completed, subscription updates, subscription deletions, and invoice payment success/failure events.

Does this skill handle Stripe signature verification?

Yes, it includes standard code patterns for verifying Stripe webhook signatures to ensure request authenticity and security.

How does the cascading upsert strategy work?

The strategy prioritizes updates by user ID, then email address, and finally Stripe customer ID to ensure data is correctly mapped regardless of the user's signup state.

Can I use this with the Next.js App Router?

Absolutely, it is specifically designed for Next.js App Router route handlers using TypeScript and the force-dynamic configuration.

Stripe Supabase Webhooks

Name: Stripe Supabase Webhooks
Author: rrh1441

byrrh1441

E-commerce Solutions

Synchronizes Stripe subscription events with Supabase databases using Next.js App Router handlers.

About

This skill simplifies the complex process of managing subscription lifecycles by providing production-ready patterns for Stripe webhooks in Next.js environments. It features a robust cascading upsert strategy to ensure data consistency between Stripe and Supabase, handles signature verification for security, and includes pre-built logic for major events like successful checkouts, subscription updates, and payment failures. It is ideal for developers building SaaS applications who need reliable, real-time synchronization of billing status with user database records.

Key Features

Cascading database upsert strategy for reliable syncing
Comprehensive subscription lifecycle event handling
0 GitHub stars
Secure Stripe signature verification patterns
Production-ready Supabase SQL schema templates
Next.js App Router API route integration

Use Cases

Syncing payment status to user profiles in real-time
Automating transactional emails based on billing events
Building a SaaS with recurring subscriptions

About

Key Features

Cascading database upsert strategy for reliable syncing
Comprehensive subscription lifecycle event handling
0 GitHub stars
Secure Stripe signature verification patterns
Production-ready Supabase SQL schema templates
Next.js App Router API route integration

Use Cases

Syncing payment status to user profiles in real-time
Automating transactional emails based on billing events
Building a SaaS with recurring subscriptions