paymentsdb
由 ramonverse 提供
Browser & Automation简介
Query Stripe customer and billing data from a synced PostgreSQL database.
描述
该技能的功能
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.
何时使用
- 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
示例工作流
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
安装
clawhub install ramonverse/paymentsdb运行 CLI 命令,或把这段提示词粘贴到 Claude Code、Cursor、Codex 或你在用的任意编程智能体里。