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.
Datos de origen
- Repositorio
- appeeky/stripe-skills
- Última actividad en el origen
- 19 de julio de 2026 a las 10:10
- Idioma detectado de SKILL.md
- inglés
- Estrellas
- 5
- Forks
- 1
Opciones de instalación
De forma predeterminada está seleccionado el prompt que primero revisa el origen. Puedes cambiar a un comando directo o descargar una copia local.
Revisa los archivos de origen
Lee SKILL.md y los archivos complementarios que muestra SkillsMP antes de decidir si quieres instalarlo.
Mostrando SKILL.md
SKILL.md
Instrucciones de origen · Vista previa de solo lectura- 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 en GitHub