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 — любой кодинг-агент, которым пользуетесь.