stripe

Sync Stripe entities into PostgreSQL via managed webhooks and backfill.

Updated Dec 10, 2025
One-click install
npx skills add https://github.com/KhaledMKhaled/FodaStore --skill stripe-khaledmkhaled
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: stripe
Source: https://github.com/KhaledMKhaled/FodaStore/tree/main/.local/skills/stripe
Command: npx skills add https://github.com/KhaledMKhaled/FodaStore --skill stripe-khaledmkhaled

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill prevents broken Stripe payment setups by guiding a correct end-to-end integration pattern: initializing the Stripe sync layer, configuring the webhook safely, and wiring read/write code paths so Stripe remains the source of truth for products, prices, and related entities.

Core Features & Use Cases

  • Managed Stripe sync with PostgreSQL: runs migrations to create the stripe schema and uses backfill plus webhooks to keep the local database in sync with Stripe.
  • Correct webhook handling in Express: ensures the webhook route is registered before JSON body parsing so signature verification and Buffer payload processing work reliably.
  • Stripe-first data model: recommends never creating duplicate product/customer tables in the stripe schema and instead querying synced stripe.* tables for products/prices/subscriptions while storing only Stripe IDs in your application tables.
  • Common endpoints scaffolding: supports typical flows like listing products with prices, creating checkout sessions, and retrieving user subscription state.

Quick Start

Use the stripe skill to set up the managed Stripe migrations, create the webhook handler and route under /api/stripe/webhook before express.json(), then implement storage queries that read from the synced stripe.* tables while creating products and prices via Stripe API scripts.

Frequently Asked Questions about stripe

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I sync Stripe data with a PostgreSQL database in Node Express?

To sync Stripe data with PostgreSQL, run stripe-replit-sync migrations before initialization to create the stripe schema, then use backfill and managed webhooks to keep products, prices, and customers updated in your Node Express backend.

Why is my Stripe webhook failing signature verification in Express?

Stripe webhook signature verification fails if the route is registered after express.json(). You must register the raw-buffer webhook route before body parsing to ensure the payload remains intact for verification.

What is the correct initialization order for stripe-replit-sync?

The correct initialization order requires running stripe-replit-sync migrations before calling getStripeSync, and registering the raw-buffer webhook route before express.json to process payloads correctly.

Should I create my own product tables when integrating Stripe with PostgreSQL?

No, you should not create duplicate product tables. Stripe remains the source of truth; query the synced stripe.* tables for products and prices, and store only Stripe IDs in your application tables.

How do I create checkout sessions using synced Stripe data?

You can create checkout sessions by using common endpoint scaffolding that reads product and price data from your synced stripe.* tables, allowing you to build typical flows like listing products and handling user subscriptions.

Can I use this Stripe integration pattern for Replit backends?

Yes, this pattern is designed for Replit Express backends, providing CRUD-like workflows for subscriptions and checkout sessions while ensuring safe defaults and reliable webhook processing.