cyberneticlibrary

Query analytics data via natural language

mcp-servermcp_serversetup L30
npm:@userflux/mcp-server
What it does

Query analytics data via natural language ClickHouse SQL

Best for

Product analytics teams exploring user event data via SQL without raw database access.

Inputs
  • · analytics query in natural language
  • · template table names (eventsTable, profilesTable FINAL)
Outputs
  • · query results (1000 row limit)
  • · campaign performance stats
  • · workflow analytics
Requires
  • · UserFlux API key
  • · ClickHouse backend
Preconditions
  • · UserFlux account + MCP API key
  • · data dictionary indexed
Failure modes
  • · stale data dictionary
  • · query timeout on large datasets
  • · missing columns in schema
Trust signals
  • · data dictionary auto-discovery
  • · FINAL keyword support for Replica tables