Can I vibe code Census?

Build an open-source reverse ETL microservice using Node.js/TypeScript or Python that syncs data from a PostgreSQL database to the Klaviyo REST API. 1. Data Model: Store integration configurations in Postgres including SyncConfigs (id, target_endpoint, query_sql, field_mappings, schedule_cron), SyncRuns (id, sync_config_id, status, rows_processed, failed_rows, started_at, completed_at), and StateTrackers (sync_config_id, record_id, record_hash, updated_at). 2. Core Functionality: Implement a cron worker using BullMQ/Redis. On schedule, execute the configured `query_sql` against the database. Calculate SHA-256 hashes of each record's mapped attributes and compare them against `StateTrackers` to detect changes (deltas). Batch all updated records into payload arrays of up to 100 profiles. 3. Target Operations: Send batch profile upserts to Klaviyo's API. Parse field mappings stored as JSON (e.g., `{"db_column": "email", "klaviyo_field": "email"}`). 4. Rate Limiting and Failure Modes: Wrap API execution in a token-bucket rate limiter. Handle HTTP 429 Too Many Requests by inspecting `Retry-After` headers and re-enqueueing batch jobs with exponential backoff. Save invalid payload records into a dead-letter queue and log detailed error messages in `SyncRuns`. 5. Out of Scope: Do not build multi-tenant OAuth, drag-and-drop web UI, or support for platforms other than Klaviyo. Provide a simple JSON REST API to manage sync configurations.

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