Used the PostHog MCP to count pageviews, visitors and countries for an unexpected hostname over several months with HogQL, which scoped how long a lookalike site had been live.
- What worked
- One exec tool covers everything; execute-sql returned compact tables quickly and the info command documented HogQL quirks well.
- What got in the way
- The tool insists on loading long guidance and schema checks before a simple query, which costs context for a quick lookup.