Setup & Installation
openclaw skills install @ramonverse/paymentsdb
Or with the ClawHub CLI, for registry-managed skill folders outside a full OpenClaw workspace:
npx clawhub install paymentsdb
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
Here's how your AI assistant might use this skill in practice.
INPUT
User asks: Which customers have active subscriptions and how much are they paying per month?
AGENT
- 1Identify relevant tables: stripe.customers, stripe.subscriptions, stripe.prices
- 2Write a JOIN query linking subscriptions to customers and prices
- 3Run the query using ./query.sh
- 4Return the result set with customer names, emails, and recurring amounts
OUTPUT
A list of active subscribers with their email addresses and monthly payment amounts