How does it handle Stripe's metadata and timestamps?

It provides guidance on using PostgreSQL JSONB operators to filter by metadata and provides conversion logic to transform Stripe's Unix epoch integers into readable timestamps.

How does this skill help with Stripe data analysis?

It provides optimized SQL queries and schema-specific patterns for Stripe data synced to PostgreSQL, making it significantly easier to build custom dashboards and financial reporting tools.

Which ORMs are supported by this skill?

The skill includes specific implementation patterns and schema definitions for Prisma, Drizzle, Kysely, and the standard pg-client for Node.js.

Can I calculate financial metrics like MRR with this tool?

Yes, it includes specialized SQL snippets designed to accurately calculate Monthly Recurring Revenue (MRR) by aggregating subscription items and handling interval conversions.

Stripe Sync Query

Name: Stripe Sync Query
Author: ashutoshpw

byashutoshpw

데이터베이스 관리

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.

주요 기능

0 GitHub stars
Optimized SQL templates for customers, subscriptions, and payment intents
Advanced revenue analytics queries including MRR and churn analysis
Ready-to-use ORM integration snippets for Prisma, Drizzle, and Kysely
PostgreSQL JSONB operator patterns for querying Stripe metadata
Performance-focused indexing and timestamp conversion strategies

사용 사례

Building custom internal dashboards for real-time financial reporting
Syncing subscription status with application logic using typed ORM schemas
Analyzing historical payment trends and customer lifetime value via raw SQL

소개

주요 기능

0 GitHub stars
Optimized SQL templates for customers, subscriptions, and payment intents
Advanced revenue analytics queries including MRR and churn analysis
Ready-to-use ORM integration snippets for Prisma, Drizzle, and Kysely
PostgreSQL JSONB operator patterns for querying Stripe metadata
Performance-focused indexing and timestamp conversion strategies

사용 사례

Building custom internal dashboards for real-time financial reporting
Syncing subscription status with application logic using typed ORM schemas
Analyzing historical payment trends and customer lifetime value via raw SQL