# Query API

> Query API skill. Use when working with Query for insights, funnels, retention. Covers 19 endpoints.

- Skill: `lap-platform/query-api` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add lap-platform/query-api`
- Raw SKILL.md: https://api.skillmd.com/api/skills/lap-platform/query-api/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: Lap-Platform (https://skillmd.com/u/lap-platform)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/lap-platform/query-api

---


# Query API
API version: 1.0.0

## Auth
No authentication required.

## Base URL
https://mixpanel.com/api/query

## Setup
1. No auth setup needed
2. GET /insights -- verify access
3. POST /cohorts/list -- create first list

## Endpoints

19 endpoints across 9 groups. See references/api-spec.lap for full details.

### insights
| Method | Path | Description |
|--------|------|-------------|
| GET | /insights | Query Saved Report |

### funnels
| Method | Path | Description |
|--------|------|-------------|
| GET | /funnels | Query Saved Report |
| GET | /funnels/list | List Saved Funnels |

### retention
| Method | Path | Description |
|--------|------|-------------|
| GET | /retention | Query Retention Report |
| GET | /retention/addiction | Query Frequency Report |

### segmentation
| Method | Path | Description |
|--------|------|-------------|
| GET | /segmentation | Query Segmentation Report |
| GET | /segmentation/numeric | Numerically Bucket |
| GET | /segmentation/sum | Numerically Sum |
| GET | /segmentation/average | Numerically Average |

### stream
| Method | Path | Description |
|--------|------|-------------|
| GET | /stream/query | Profile Event Activity |

### cohorts
| Method | Path | Description |
|--------|------|-------------|
| POST | /cohorts/list | List Saved Cohorts |

### engage
| Method | Path | Description |
|--------|------|-------------|
| POST | /engage | Query Profiles |

### events
| Method | Path | Description |
|--------|------|-------------|
| GET | /events | Aggregate Event Counts |
| GET | /events/top | Today's Top Events |
| GET | /events/names | Top Events |
| GET | /events/properties | Aggregrated Event Property Values |
| GET | /events/properties/top | Top Event Properties |
| GET | /events/properties/values | Top Event Property Values |

### jql
| Method | Path | Description |
|--------|------|-------------|
| POST | /jql | Custom JQL Query |

## Common Questions

Match user requests to endpoints in references/api-spec.lap. Key patterns:
- "List all insights?" -> GET /insights
- "List all funnels?" -> GET /funnels
- "List all list?" -> GET /funnels/list
- "List all retention?" -> GET /retention
- "List all addiction?" -> GET /retention/addiction
- "List all segmentation?" -> GET /segmentation
- "List all numeric?" -> GET /segmentation/numeric
- "List all sum?" -> GET /segmentation/sum
- "List all average?" -> GET /segmentation/average
- "List all query?" -> GET /stream/query
- "Create a list?" -> POST /cohorts/list
- "Create a engage?" -> POST /engage
- "List all events?" -> GET /events
- "List all top?" -> GET /events/top
- "List all names?" -> GET /events/names
- "List all properties?" -> GET /events/properties
- "List all top?" -> GET /events/properties/top
- "List all values?" -> GET /events/properties/values
- "Create a jql?" -> POST /jql

## Response Tips
- Check response schemas in references/api-spec.lap for field details
- List endpoints may support pagination; check for limit, offset, or cursor params
- Create/update endpoints typically return the created/updated object

## References
- Full spec: See references/api-spec.lap for complete endpoint details, parameter tables, and response schemas

> Generated from the official API spec by [LAP](https://lap.sh)