Odoo integration with Supabase and TimescaleDB

  Dec 21, 2025      2m      0   

 

Run Odoo 19 with Supabase and TimescaleDB: one-line install, Docker Compose setup, PostgreSQL extensions, and performance tips.

Please install Docker and Docker-Compose before walking through this tutorial.

Odoo-Supabase-TimescaleDB

Github: https://github.com/minhng-info/odoo-supabase-timescaledb/

Star my repository if it helps. Thank you.

Installing Odoo with Supabase and TimescaleDB

git clone git@github.com:minhng-info/odoo-supabase-timescaledb.git
cd odoo-supabase-timescaledb
docker-compose up -d

• Open localhost:10019 to access Odoo 19
  • Default login: admin / admin
  • Database master password: minhng.info (configured in etc/odoo.conf file)
• Open localhost:8000 to access Supabase Studio Dashboard
  • Login: supabase / minhng.info (configured in .env file)
• If you get permission errors, ensure the container can access local directories:

sudo chmod -R 777 addons
sudo chmod -R 777 etc
sudo chmod -R 777 volumes

Quick command to setup Odoo-Supabase-TimescaleDB

# Default setup in target directory "odoo-supabase-timescaledb"
# Require available ports: 10019, 20019, 8000
curl -s https://raw.githubusercontent.com/minhng-info/odoo-supabase-timescaledb/master/run.sh | bash

or

curl -s https://raw.githubusercontent.com/minhng-info/odoo-supabase-timescaledb/master/run.sh | bash -s odoo-supabase-timescaledb 11019 21019 9000

Some arguments:

• odoo-supabase-timescaledb: target folder on local machine
• 11019: Odoo port
• 21019: chat port
• 9000: Supabase Studio Dashboard port

Architecture Overview

This setup integrates Odoo 19 with Supabase and TimescaleDB (PostgreSQL 17.6 with TimescaleDB 2.22.1) to provide comprehensive database management and time-series data processing.

• Odoo 19: Full-featured business applications
• Supabase: Open-source backend platform with database management interface
• TimescaleDB: PostgreSQL-based time-series database optimized for analytics

Why TimescaleDB with Odoo and Supabase

• Time-series optimization for logs, IoT, events, KPIs
• Real-time analytics and faster reporting on large datasets
• Hybrid transactional + analytical workloads on a single database
• Automatic partitioning and efficient data retention
• Seamless integration with Supabase Studio for database management and querying

---

Odoo posts:

• Docker Compose for Odoo 10
• Docker Compose for Odoo 11
• Docker Compose for Odoo 12
• Docker Compose for Odoo 13
• Docker Compose for Odoo 14
• Docker Compose for Odoo 15
• Docker Compose for Odoo 16
• Docker Compose for Odoo 17
• Docker Compose for Odoo 18
• Docker Compose for Odoo 19

Extra:

• Odoo integration with Supabase
• Odoo with TimescaleDB

---

• Minh fanpage: https://www.facebook.com/minhng.info
• Odoo group: https://www.facebook.com/groups/odoo-dev

Khám phá Odoo

Minh Nguyen

Share this:

      

• #docker-compose
• #docker
• #odoo
• #supabase
• #timescaledb