active-subscriptions-audit
Audits Stripe subscription counts and status mix — active, trialing, past_due, canceled, paused. Use when the user asks "how many subscribers", "subscription count", "active subs", "trialing users", or status breakdown. For MRR dollars, see mrr-arr-snapshot.
Source facts
- Repository
- appeeky/stripe-skills
- Last source activity
- July 19, 2026 at 10:10
- Detected SKILL.md language
- English
- Stars
- 5
- Forks
- 1
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Showing SKILL.md
SKILL.md
Source instructions · Read-only preview- name
- active-subscriptions-audit
- description
- Audits Stripe subscription counts and status mix — active, trialing, past_due, canceled, paused. Use when the user asks "how many subscribers", "subscription count", "active subs", "trialing users", or status breakdown. For MRR dollars, see mrr-arr-snapshot.
- metadata
- {"version":"1.0.0"}
# Active Subscriptions Audit
## Stripe MCP Setup
Requires **Stripe MCP** connected via OAuth or restricted key. Docs: https://docs.stripe.com/mcp
1. `GetMcpTools` with `server: "user-Stripe"` (or `plugin-stripe-stripe`) before any call
2. Prefer `stripe_api_search` → `stripe_api_details` → `stripe_api_read` for list/retrieve
3. **Always paginate** — `limit: 100`, follow `has_more` with `starting_after`
4. Amounts are in **cents** unless noted
5. Never expose secret keys in output
## Workflow
For each status, paginate `GetSubscriptions`:
| Status | Meaning |
|--------|---------|
| `active` | Paying, current |
| `trialing` | In trial |
| `past_due` | Payment failed, not canceled yet |
| `canceled` | Ended (use date filter if needed) |
| `paused` | Collection paused |
| `unpaid` | Retries exhausted |
```
stripe_api_read GetSubscriptions { status: "active", limit: 100 }
```
Repeat for `trialing`, `past_due`, `unpaid`, `paused`.
## Metrics
| Metric | Formula |
|--------|---------|
| Paid subs | active + past_due (optional) |
| Trial pipeline | trialing count |
| At-risk subs | past_due + unpaid |
| Line items per sub | items.data.length (multi-product subs) |
## Output Template
```
Subscription Status ([date])
| Status | Count | % of total |
|--------|-------|------------|
| Active | | |
| Trialing | | |
| Past due | | |
| Unpaid | | |
Multi-product subs: [N] subs with 2+ line items
```
Flag if `past_due` > 5% of active — investigate with `past-due-dunning`.
View on GitHub