Setup & Installation
Or with the ClawHub CLI, for registry-managed skill folders outside a full OpenClaw workspace:
What This Skill Does
Connects to Outlit's MCP server and exposes 6 tools for querying customer intelligence data: customer and user profiles, revenue metrics, activity timelines, and raw SQL access against ClickHouse analytics tables. Monetary values are in cents, pagination is cursor-based, and SQL is read-only SELECT.
Querying Outlit data through MCP tools lets you combine customer lookups, timeline inspection, and custom SQL in a single conversational session without switching between dashboards.
When to use it
- Finding paying customers with no product activity in the last 30 days
- Breaking down monthly recurring revenue by billing status with SQL
- Pulling a full activity timeline for a specific customer account
- Identifying users stuck in early journey stages like SIGNED_UP or DISCOVERED
- Running ad-hoc cohort queries against raw events and MRR snapshot tables
Example Workflow
Here's how your AI assistant might use this skill in practice.
User asks: Which paying customers haven't been active in 30 days, sorted by MRR?
- 1Call outlit_list_customers with billingStatus PAYING, noActivityInLast 30d, orderBy mrr_cents, orderDirection desc
- 2Receive paginated list of at-risk customers with MRR in cents
- 3Convert mrr_cents to dollars by dividing by 100
- 4Check pagination.hasMore and fetch additional pages if needed
- 5Return ranked customer list with names, domains, and MRR
Sorted list of paying customers inactive for 30+ days, each showing name, domain, and monthly revenue in dollars
Requirements
Accounts, API keys, or tools you or your AI assistant may need to set up while using this skill.