Provides optimized SQL patterns and ORM configurations for querying Stripe data synced to PostgreSQL.
Stripe Sync Query is an essential tool for developers using stripe-sync-engine to manage financial data within their own infrastructure. It offers a comprehensive library of production-ready SQL queries for managing customers, tracking subscriptions, and calculating complex financial metrics like Monthly Recurring Revenue (MRR) and churn rates. By providing pre-configured patterns for popular ORMs like Prisma, Drizzle, and Kysely, this skill enables seamless integration of Stripe billing data directly into application logic, while offering expert guidance on PostgreSQL-specific features like JSONB metadata filtering and Unix timestamp conversion.
主要功能
010 GitHub stars
02Optimized SQL templates for customers, subscriptions, and payment intents
03Advanced revenue analytics queries including MRR and churn analysis
04Ready-to-use ORM integration snippets for Prisma, Drizzle, and Kysely
05PostgreSQL JSONB operator patterns for querying Stripe metadata
06Performance-focused indexing and timestamp conversion strategies
使用场景
01Building custom internal dashboards for real-time financial reporting
02Syncing subscription status with application logic using typed ORM schemas
03Analyzing historical payment trends and customer lifetime value via raw SQL
