โ† All skills
Tencent SkillHub ยท Developer Tools

Outlit MCP

Use when querying Outlit customer data via MCP tools (outlit_*). Triggers on customer analytics, revenue metrics, activity timelines, cohort analysis, churn...

skill openclawclawhub Free
0 Downloads
0 Stars
0 Installs
0 Score
High Signal

Use when querying Outlit customer data via MCP tools (outlit_*). Triggers on customer analytics, revenue metrics, activity timelines, cohort analysis, churn...

โฌ‡ 0 downloads โ˜… 0 stars Unverified but indexed

Install for OpenClaw

Quick setup
  1. Download the package from Yavira.
  2. Extract the archive and review SKILL.md first.
  3. Import or place the package into your OpenClaw setup.

Requirements

Target platform
OpenClaw
Install method
Manual import
Extraction
Extract archive
Prerequisites
OpenClaw
Primary doc
SKILL.md

Package facts

Download mode
Yavira redirect
Package format
ZIP package
Source platform
Tencent SkillHub
What's included
SKILL.md, references/workflows.md, references/sql-reference.md

Validation

  • Use the Yavira download entry.
  • Review SKILL.md after the package is downloaded.
  • Confirm the extracted package contains the expected setup assets.

Install with your agent

Agent handoff

Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.

  1. Download the package from Yavira.
  2. Extract it into a folder your agent can access.
  3. Paste one of the prompts below and point your agent at the extracted folder.
New install

I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.

Upgrade existing

I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.

Trust & source

Release facts

Source
Tencent SkillHub
Verification
Indexed source record
Version
1.0.0

Documentation

ClawHub primary doc Primary doc: SKILL.md 17 sections Open source page

Outlit MCP Server

Query customer intelligence data through 6 MCP tools covering customer and user profiles, revenue metrics, activity timelines, and raw SQL analytics access.

Quick Start

What you needToolBrowse/filter customersoutlit_list_customersBrowse/filter usersoutlit_list_usersSingle customer deep diveoutlit_get_customerCustomer activity historyoutlit_get_timelineCustom analytics / aggregationsoutlit_query (SQL)Discover tables & columnsoutlit_schema Before writing SQL: Always call outlit_schema first to discover available tables and columns.

Common Patterns

Find at-risk customers: { "tool": "outlit_list_customers", "billingStatus": "PAYING", "noActivityInLast": "30d", "orderBy": "mrr_cents", "orderDirection": "desc" } Revenue breakdown (SQL): { "tool": "outlit_query", "sql": "SELECT billing_status, count(*) as customers, sum(mrr_cents)/100 as mrr_dollars FROM customer_dimensions GROUP BY 1 ORDER BY 3 DESC" }

Get an API Key

Go to Settings > MCP Integration in the Outlit dashboard (app.outlit.ai).

Auto-Detection Setup

Detect the current environment and run the appropriate setup command: Check for Claude Code โ€” If running inside Claude Code (check if claude CLI is available), run: claude mcp add outlit https://mcp.outlit.ai/mcp -- --header "Authorization: Bearer API_KEY" Check for Cursor โ€” If .cursor/mcp.json exists in the project or home directory, add to that file: { "mcpServers": { "outlit": { "url": "https://mcp.outlit.ai/mcp", "headers": { "Authorization": "Bearer API_KEY" } } } } Check for Claude Desktop โ€” If claude_desktop_config.json exists at ~/Library/Application Support/Claude/ (macOS) or %APPDATA%/Claude/ (Windows), add to that file: { "mcpServers": { "outlit": { "url": "https://mcp.outlit.ai/mcp", "headers": { "Authorization": "Bearer API_KEY" } } } } Ask the user for their API key if not provided. Replace API_KEY with the actual key.

Verify Connection

Call outlit_schema to confirm the connection is working.

outlit_list_customers

Filter and paginate customers. Key ParamsValuesbillingStatusNONE, TRIALING, PAYING, CHURNEDhasActivityInLast / noActivityInLast7d, 14d, 30d, 90d (mutually exclusive)mrrAbove / mrrBelowcents (10000 = $100)searchname or domainorderBylast_activity_at, first_seen_at, name, mrr_centslimit1-1000 (default: 20)cursorpagination token

outlit_list_users

Filter and paginate users. Key ParamsValuesjourneyStageDISCOVERED, SIGNED_UP, ACTIVATED, ENGAGED, INACTIVEcustomerIdfilter by customerhasActivityInLast / noActivityInLastNd, Nh, or Nm (e.g., 7d, 24h) โ€” mutually exclusivesearchemail or nameorderBylast_activity_at, first_seen_at, emaillimit1-1000 (default: 20)cursorpagination token

outlit_get_customer

Single customer deep dive. Accepts customer ID, domain, or name. Key ParamsValuescustomercustomer ID, domain, or name (required)includeusers, revenue, recentTimeline, behaviorMetricstimeframe7d, 14d, 30d, 90d (default: 30d) Only request the include sections you need โ€” omitting unused ones is faster.

outlit_get_timeline

Activity timeline for a customer. Key ParamsValuescustomercustomer ID or domain (required)channelsSDK, EMAIL, SLACK, CALL, CRM, BILLING, SUPPORT, INTERNALeventTypesfilter by specific event typestimeframe7d, 14d, 30d, 90d, all (default: 30d)startDate / endDateISO 8601 (mutually exclusive with timeframe)limit1-1000 (default: 50)cursorpagination token

outlit_query

Raw SQL against ClickHouse analytics tables. SELECT only. See SQL Reference for ClickHouse syntax and security model. Key ParamsValuessqlSQL SELECT query (required)limit1-10000 (default: 1000) Available tables: events, customer_dimensions, user_dimensions, mrr_snapshots.

outlit_schema

Discover tables and columns. Call with no params for all tables, or table: "events" for a specific table. Always call this before writing SQL.

Data Model

Billing status: NONE โ†’ TRIALING โ†’ PAYING โ†’ CHURNED Journey stages: DISCOVERED โ†’ SIGNED_UP โ†’ ACTIVATED โ†’ ENGAGED โ†’ INACTIVE Data formats: Monetary values in cents (divide by 100 for dollars) Timestamps in ISO 8601 IDs with string prefixes (cust_, contact_, evt_) Pagination: All list endpoints use cursor-based pagination. Check pagination.hasMore before requesting more pages. Pass pagination.nextCursor as cursor for the next page.

Best Practices

Call outlit_schema before writing SQL โ€” discover columns, don't guess Use customer tools for single lookups โ€” don't use SQL for individual customer queries Filter at the source โ€” use tool params and WHERE clauses, not post-fetch filtering Only request needed includes โ€” omit unused include options for faster responses Always add time filters to event SQL โ€” WHERE occurred_at >= now() - INTERVAL N DAY Convert cents to dollars โ€” divide monetary values by 100 for display Use LIMIT in SQL โ€” cap result sets to avoid large data transfers

Known Limitations

SQL is read-only โ€” no INSERT, UPDATE, DELETE Organization isolation โ€” cannot query other organizations' data Timeline requires a customer โ€” cannot query timeline across all customers MRR filtering is post-fetch โ€” may be slower on large datasets in list_customers Event queries need time filters โ€” queries without date ranges scan all data ClickHouse syntax โ€” uses different functions than MySQL/PostgreSQL (see SQL Reference)

Tool Gotchas

ToolGotchaoutlit_list_customershasActivityInLast and noActivityInLast are mutually exclusiveoutlit_list_customerssearch checks name and domain onlyoutlit_get_customerbehaviorMetrics depends on timeframe โ€” extend it if emptyoutlit_get_timelinetimeframe and startDate/endDate are mutually exclusiveoutlit_queryUse ClickHouse date syntax: now() - INTERVAL 30 DAY, not DATE_SUB()outlit_queryproperties column is JSON โ€” use JSONExtractString(properties, 'key')

References

ReferenceWhen to ReadSQL ReferenceClickHouse syntax, security model, query patternsWorkflowsMulti-step analysis: churn risk, revenue dashboards, account health

Category context

Code helpers, APIs, CLIs, browser automation, testing, and developer operations.

Source: Tencent SkillHub

Largest current source with strong distribution and engagement signals.

Package contents

Included in package
3 Docs
  • SKILL.md Primary doc
  • references/sql-reference.md Docs
  • references/workflows.md Docs