---
title: "MySQL: ask your database in plain words · Adea"
description: "Adea reads your MySQL database through a read-only user and answers your business questions with the numbers and the query behind them."
url: https://adea.app/integrations/mysql
---

# 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.

[Connect MySQL](https://adea.app/signup) [Read the setup guide](https://adea.app/docs/connect-database)

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

## How it connects

A user that can only read

[Read the setup guide](https://adea.app/docs/connect-database)

## What you can ask

You ask

What was our revenue last week, and which day was the best?

Adea answers

€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.

You ask

How many customers ordered more than once this year?

Adea answers

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.

## Coming from a BI tool on MySQL?

[Adea vs Metabase](https://adea.app/vs/metabase) [Adea vs Power BI](https://adea.app/vs/power-bi) [Adea vs Looker Studio](https://adea.app/vs/looker-studio) [Adea vs Tableau](https://adea.app/vs/tableau) [Adea vs Mode](https://adea.app/vs/mode) [Adea vs Hex](https://adea.app/vs/hex) [Adea vs Sigma](https://adea.app/vs/sigma) [Adea vs Omni](https://adea.app/vs/omni) [Adea vs ThoughtSpot](https://adea.app/vs/thoughtspot) [Adea vs Databox](https://adea.app/vs/databox)

## Other sources like this

[PostgreSQL](https://adea.app/integrations/postgres) [MariaDB](https://adea.app/integrations/mariadb) [Microsoft SQL Server](https://adea.app/integrations/sqlserver) [All sources](https://adea.app/integrations)

## What do you want to know?

[Start free](https://adea.app/signup) [Book 20 minutes](mailto:hello@adea.app?subject=20%20minutes%20about%20Adea)