Ask your MySQL database what is going on in the business.
Connect a user that can only read, and ask about sales, stock or customers in plain words. Every answer comes with the query so you can follow the numbers.
You can connect MySQL today.
What Adea reads from MySQL
- Tables and views you allow, with columns and keys
- Orders, customers and products as your own tables hold them
- Counts and totals, read with plain SELECT queries
- A read replica if you have one, so live traffic is unaffected
What you can ask
What was our revenue last week, and which day was the best?
€48,620 for the week, up 6 percent on the week before. Thursday was the best day at €9,870, helped by 214 orders from one newsletter.
How many customers ordered more than once this year?
3,942 of 11,208 customers, 35 percent. Together they placed 61 percent of all orders.
Questions about MySQL
How does Adea connect to MySQL?
You create a user with read rights only and give Adea the details. Adea checks that the user cannot write, and connects from fixed addresses you can allow in your firewall.
Does Adea ever write to my database?
Never. It only reads, and it refuses to connect with a user that could write.
Can I limit what Adea reads?
Yes. You decide which tables and views the user can see, and Adea only reads inside that.
