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

데이터베이스 관리

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.

주요 기능

Built-in SQL verification queries for schema integrity
API endpoint templates for serverless migration triggers
0 GitHub stars
Automated PostgreSQL schema creation for Stripe objects
Support for custom schema names and table prefixes
Script generation for CI/CD and manual migration workflows

사용 사례

Managing schema updates in serverless environments like Next.js or Hono
Initial database setup for new stripe-sync-engine installations
Troubleshooting database connection and permission issues during sync setup

소개

주요 기능

Built-in SQL verification queries for schema integrity
API endpoint templates for serverless migration triggers
0 GitHub stars
Automated PostgreSQL schema creation for Stripe objects
Support for custom schema names and table prefixes
Script generation for CI/CD and manual migration workflows

사용 사례

Managing schema updates in serverless environments like Next.js or Hono
Initial database setup for new stripe-sync-engine installations
Troubleshooting database connection and permission issues during sync setup