paymentsdb
by ramonverse
Browser & AutomationBrief
Query Stripe customer and billing data from a synced PostgreSQL database.
Description
What This Skill Does
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.
When to Use It
- 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
Example 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/paymentsdbRun the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.