What tables are created by these migrations?

The migrations create tables for all core Stripe objects including customers, products, prices, subscriptions, invoices, charges, and payment intents.

How do I run migrations in a serverless environment?

The skill provides code templates to create API endpoints in frameworks like Next.js and Hono, allowing you to trigger migrations via HTTP POST requests.

Which databases are supported by this skill?

This skill specifically targets PostgreSQL databases (version 12 or higher) as required by the stripe-sync-engine library.

Can I change the default 'stripe' schema name?

Yes, the migration configuration options allow you to specify a custom schema name and optional table prefixes to avoid naming collisions.

Do I need special permissions to run these migrations?

Yes, your database user must have the 'CREATE' permission on the database to initialize the schema, or you must create the schema manually and grant the user full permissions on it.

Stripe Sync Database Migrations

Name: Stripe Sync Database Migrations
Author: ashutoshpw

byashutoshpw

0•

데이터베이스 관리

Automates the setup and management of PostgreSQL database schemas for synchronizing Stripe data.

The Stripe Sync Database Migrations skill provides a specialized interface for initializing and maintaining the PostgreSQL infrastructure required by the stripe-sync-engine. It guides developers through configuring environment variables, executing migration scripts in local or serverless environments, and verifying the creation of over 17 essential tables including customers, subscriptions, and invoices. This skill ensures that your database schema is perfectly aligned with Stripe's data structures, facilitating seamless data synchronization and reducing manual setup errors.

주요 기능

01Built-in SQL verification queries for schema integrity

02API endpoint templates for serverless migration triggers

030 GitHub stars

04Automated PostgreSQL schema creation for Stripe objects

05Support for custom schema names and table prefixes

06Script generation for CI/CD and manual migration workflows

사용 사례

01Managing schema updates in serverless environments like Next.js or Hono

02Initial database setup for new stripe-sync-engine installations

03Troubleshooting database connection and permission issues during sync setup

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ashutoshpw/stripe-sync-engine migrations

For use in Claude.ai and ChatGPT

Download Skill