paymentsdb
von ramonverse
Browser & AutomationKurzbeschreibung
Query Stripe customer and billing data from a synced PostgreSQL database.
Beschreibung
Was dieser Skill macht
Queries Stripe billing data from a synced PostgreSQL database. Covers customers, subscriptions, invoices, charges, disputes, refunds, payouts, and more. Data is accessed via a local query.sh script using standard SQL.
SQL access to the full Stripe dataset enables bulk analysis and cross-table joins that would require many paginated API calls to replicate.
Wann du ihn einsetzt
- Look up a customer's subscription status by email
- Find all failed or disputed charges in a date range
- Calculate monthly recurring revenue by plan or product
- List unpaid invoices with customer contact details
- Check payout history and balance transactions
Beispiel-Workflow
User asks: Which customers have active subscriptions and how much are they paying per month?
- 1
Identify relevant tables: stripe.customers, stripe.subscriptions, stripe.prices
- 2
Write a JOIN query linking subscriptions to customers and prices
- 3
Run the query using ./query.sh
- 4
Return the result set with customer names, emails, and recurring amounts
A list of active subscribers with their email addresses and monthly payment amounts
Installation
clawhub install ramonverse/paymentsdbFühre den CLI-Befehl aus oder füge den Prompt in Claude Code, Cursor, Codex oder deinen Coding-Agenten ein.