FirstLook System Architecture

Interactive Node Graph

Autonomous Film-Marketing Agent · ClickHouse Track · Official mcp-clickhouse Protocol

4.56B Rows Scanned Official stdio MCP← Back to Studio

Live Dataflow Topology(Click any node to inspect runtime code & protocols)

Analytical OLAP Flow AI Reasoning Flow Media Render Flow

Node InspectorHero-Tech OLAP Core (Section 7.B)

Official mcp-clickhouse Server

Protocol: stdio transport · JSON-RPC 2.0

Latency: 120ms - 380ms

Load-bearing bridge connecting the agent directly to ClickHouse Cloud. Executes read queries over the public 4.56B YouTube dataset and ingests private campaign telemetry via official run_query tool calls.

Production Code Execution

Node.js ES Modules · TypeScript

// lib/clickhouse-mcp.ts
const transport = new StdioClientTransport({
  command: "uvx",
  args: ["mcp-clickhouse", "--host", host, "--secure"]
});
const result = await client.callTool({
  name: "run_query",
  arguments: { query: "SELECT quantilesExactWeighted(0.5, 0.90)(engagement) FROM youtube.youtube" }
});

Section 7.B Verification: 100% Antigravity/Gemini Authored Direct Client Disallowed · stdio MCP Enforced

Repository: github.com/Zen-cronic/firstlook

Stack: Next.js 15 · Gemini 3.6 Flash · Remotion 4 · mcp-clickhouse · Google Cloud Storage

MIT License · ClickHouse Track Submission