Direct SQL access to your Stripe billing and customer data via a synced PostgreSQL database.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install paymentsdb
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install paymentsdb using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Stripe SQL Data Access?
The Stripe skill provides a robust interface for AI agents to query comprehensive financial and customer data. By syncing Stripe objects into a structured PostgreSQL database, this skill allows for complex analytical queries that would be difficult to perform via standard REST APIs. As one of the essential Openclaw Skills, it empowers developers to build agents that understand subscription lifecycles, revenue trends, and customer billing histories with high precision.
This skill is specifically designed for environments where data is mirrored to a PostgreSQL instance, ensuring that your AI agent has local-speed access to every facet of your Stripe account, from individual line items in a checkout session to high-level account balances.
Stripe SQL Data Access Use Cases
- Retrieving customer subscription status and renewal dates
- Calculating Monthly Recurring Revenue (MRR) through SQL aggregations
- Auditing payment disputes and refund histories across specific timeframes
- Generating lists of high-value customers based on total spend
- Mapping product performance by joining plans, prices, and subscription data
How Stripe SQL Data Access Works
- The AI agent processes a user request related to billing or customer data.
- The skill identifies the appropriate table within the stripe schema based on the query context.
- A specific SQL query is constructed and executed using the provided query.sh utility.
- The database returns the structured result set to the agent.
- The agent synthesizes the data into a natural language response for the user.
Stripe SQL Data Access Setup
To use this skill within the ecosystem of Openclaw Skills, ensure your PostgreSQL database is properly synced with your Stripe account data. The skill interacts with the database via a local execution script.
# Test the connection and query the current time
./query.sh "SELECT now();"
# Query for a specific customer by email
./query.sh "SELECT id, name FROM stripe.customers WHERE email = '[email protected]';"
Stripe SQL Data Access Data Schema & Taxonomy
The skill utilizes a comprehensive stripe schema including the following primary tables:
| Table | Description |
|---|---|
| stripe.customers | Core customer profile, metadata, and contact info |
| stripe.subscriptions | Detailed subscription states, periods, and statuses |
| stripe.invoices | Billing records, amounts due, and payment links |
| stripe.charges | Individual transaction details, outcomes, and fraud details |
| stripe.payment_intents | Lifecycle data for payment attempts and status |
| stripe.plans & stripe.prices | Product catalog, recurring intervals, and pricing structures |
| stripe.payouts | Records of funds transferred to your bank account |
Stripe SQL Data Access Advanced Features
- Direct access to _raw_data jsonb columns for accessing unmapped or custom Stripe fields
- Time-series financial analysis using _updated_at and created timestamps
- Complex multi-table joins to link customers, subscriptions, and specific invoice line items
- Real-time fraud monitoring via the early_fraud_warnings table
- Multi-account support via the _account_id column available across tables
SKILL.md
Loading
Related Openclaw Skills
SilverBullet MCP Server
A powerful Model Context Protocol server that integrates the SilverBullet markdown note-taking app with AI agents for seamless knowledge management.
On-Chain Analysis
A comprehensive tool for decoding EVM smart contracts and generating AI-driven activity dashboards via Dune Analytics.
Agentic Arena
Agentic Arena is a comprehensive API-driven onboarding and DeFi execution pipeline for AI agents operating on the Base chain.
OpenClaw CLI
A comprehensive command-line interface for managing the lifecycle, health, and messaging protocols of the OpenClaw ecosystem.
Blockbuster Course Consultant (Dapianke)
A professional course design consultant that implements the Blockbuster Course methodology to guide users through the entire curriculum development lifecycle.
WeChat Moments Assistant (Pangyu)
A personalized AI copywriting assistant that learns your unique voice to create authentic WeChat Moments posts.
Featured*
