कंटेंट पर जाएँ
TakoAPI
स्किल्स पर वापस

paymentsdb

ramonverse द्वारा

Browser & Automation
1.1kclawskills.sh द्वारा बताए गए डाउनलोड
0व्यूज़
0 लाइकइस स्किल को लाइक करने के लिए साइन इन करें
—अभी तक कोई रेटिंग नहीं
आपकी रेटिंग

संक्षिप्त

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. 1

    Identify relevant tables: stripe.customers, stripe.subscriptions, stripe.prices

  2. 2

    Write a JOIN query linking subscriptions to customers and prices

  3. 3

    Run the query using ./query.sh

  4. 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 या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।

लिंक