Database architecture


(Oumaima SAOUD) #1

Hello
I am a beginner with matomo and I have two questions about his database:

  1. what is the architecture of the database tables?
  2. What is the best way to access this database in order to make queries and recover raw data?

Thank you for your help.
Oumaima.


(Lukas Winkler) #2

Hi,

While I definitely recommend you to use the reporting API to fetch data as otherwise you start to rebuild Matomo from scratch.

But if you still want to make SQL queries, this might help you:
https://developer.matomo.org/guides/persistence-and-the-mysql-backend


(Oumaima SAOUD) #3

Thank you for your reply,
In fact, I want to access the database to see the detailed architecture of the tables and understand the relationships between them, and to use this data to create new features.
I found this:
https://fr.wikibooks.org/wiki/Matomo/Fonctionnement
But it is not very detailed and recent.