{"repo":"SocialGouv/matomo-postgres","free":true,"listed":false,"github":"https://github.com/SocialGouv/matomo-postgres","clone":"git clone https://github.com/SocialGouv/matomo-postgres.git","description":"Extract matomo data and push to Postgres","language":"TypeScript","stars":12,"topics":["matomo","analytics"],"license":null,"category":"analytics","readme_excerpt":"@socialgouv/matomo-postgres A robust Node.js/TypeScript ETL (Extract, Transform, Load) tool that synchronizes visitor analytics data from Matomo (formerly Piwik) into a PostgreSQL database. Designed for organizations that need to centralize their web analytics data for advanced analysis, reporting, or integration with other systems. ✨ Features - 🔄 Incremental Synchronization - Smart date range detection with automatic resume capability - 📊 Complete Data Extraction - Captures visitor sessions, events, custom dimensions, and device information - 🗄️ Automatic Schema Management - Kysely-based migrations with performance optimizations - ⚡ High Performance - Controlled concurrency, pagination, and weekly table partitioning - 🛡️ Type Safety - Full TypeScript implementation with comprehensive type definitions - 🔍 Detailed Logging - Progress tracking and debug information for monitoring - 📱 Device Analytics - Screen resolution, device model, and operating system data - 🌍 Geographic Data - Country, region, and city information from visitor sessions 🚀 Quick Start Global Installation Local Installation ⚙️ Configuration Required Environment Variables Variable Description Example ------------- ------------------------------------ ------------------------------------- MATOMO KEY Matomo API authentication token your api token here MATOMO SITE Numeric site ID in Matomo 1 MATOMO URL Base URL of your Matomo installation https://analytics.example.com/ PGDATABASE PostgreSQL connection str","default_branch":null,"files":null,"tree":[],"storefront":"/r/SocialGouv","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/SocialGouv/matomo-postgres/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}