Can I vibe code Mixpanel?

Build a lightweight product analytics microservice using Node.js (Fastify), PostgreSQL, and ClickHouse. 1. DATA MODEL: In ClickHouse, create an 'events' table storing (event_name String, distinct_id String, anonymous_id String, properties JSON, timestamp DateTime64(3)). In PostgreSQL, create a 'users' table storing (id UUID, distinct_id String, created_at Timestamp, properties JSONB). 2. INGESTION ENDPOINT: Create a POST /track HTTP endpoint. Validate the payload (event name, distinct_id, properties). Buffer events in memory or Redis and batch insert them into ClickHouse every 2 seconds or 500 events to prevent small insert overhead. 3. IDENTITY RESOLUTION: Create a POST /alias endpoint accepting (anonymous_id, distinct_id). Update the user mapping table and rewrite incoming distinct_ids so events map to the same unified user profile. 4. QUERY ENGINE: Implement a GET /api/funnel endpoint accepting an array of sequential event names and a date range. Write an optimized ClickHouse SQL query using sequenceMatch or windowFunnel functions to compute multi-step conversion rates and drop-offs. 5. FAILURE MODES & RETRIES: If ClickHouse is unreachable, cache events in Redis. Implement rate-limiting on the tracking endpoint to prevent Denial-of-Service attacks. OUT OF SCOPE: Mobile native SDKs, automated session replay recordings, complex UI chart builders, and multi-tenant organizational permissions.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs