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.
Informações da origem
- Repositório
- appeeky/stripe-skills
- Última atividade na origem
- 19 de julho de 2026 às 10:10
- Idioma detectado do SKILL.md
- inglês
- Estrelas
- 5
- Forks
- 1
Opções de instalação
Por padrão, está selecionado o prompt que primeiro revisa a origem. Você pode mudar para um comando direto ou baixar uma cópia local.
Revise os arquivos de origem
Leia o SKILL.md e os arquivos complementares exibidos pelo SkillsMP antes de decidir se vai instalar.
Exibindo SKILL.md
SKILL.md
Instruções da origem · Visualização somente leitura- 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`.
Ver no GitHub