본문으로 건너뛰기
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 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크