Data connector

Send MySQL (& MariaDB) data to AI, reports, spreadsheets and ETL

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

MySQL (& MariaDB)

MySQL and MariaDB power much of the software that runs everyday business: e-commerce platforms, ERPs, CRMs, ticketing tools and custom applications all keep their records in these relational databases. With Kondado you centralize order history, customer records, product catalogs, financial entries, support tickets, inventory movements and operational logs in one place. Teams consolidate revenue, sales and stock data from several systems, follow customer behavior over time and keep a single view of the numbers that matter.

You choose what to bring

Bring your MySQL (& MariaDB) tables in, exactly as they are

There is no fixed list of tables: you choose exactly what to bring (tables and views) and Kondado keeps the same structure as your data.

Illustrative example
Schema: sales
  • customers
  • orders
    idcustomer_idtotal_amountcreated_at
  • order_items
  • vw_monthly_revenue

The tables and views you choose arrive with the same column names.

Automatic updates: Kondado refreshes the data on the schedule you choose, from every 5 minutes to daily.

Ask the AI in Claude or ChatGPT
What was our revenue per month over the last 6 months?
Which customers have not bought in more than 90 days?

Ask in natural language in Claude or ChatGPT, through Kondado's MCP server.

And to follow it every day: a dashboard in Power BI or Looker Studio, no database needed. Power BI · Looker Studio

If you prefer, also send it to a spreadsheet (Google Sheets, Excel) or to your own database or data warehouse (BigQuery, PostgreSQL, MySQL).

Try out all the features for free for 14 days

Kondado connects to MySQL (& MariaDB) with the standard credentials of your server: host or address, port, database name, username and password, plus IP whitelisting on the database server. Once connected, Kondado reads the structure of your tables and views, so you choose exactly what to bring (tables and views, with their own columns) and Kondado keeps the same structure of your data, with your own names for tables and views and your own columns. Updates run on a configurable schedule, from every 5 minutes to once a day.

Analysts, operations managers, finance teams and founders use these pipelines to follow revenue by product, order volume, customer retention, support backlog and stock levels. They send the data to Via Kondado, which feeds dashboards in Power BI and Looker Studio straight from the platform, with no database of your own, and lets them ask questions in natural language in Claude or ChatGPT through Kondado’s MCP server.

The Kondado platform takes care of refreshing MySQL (& MariaDB) data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing MySQL (& MariaDB) data with AI (Claude, ChatGPT and MCP) or in your report, spreadsheet, data warehouse, data lake, or database

Try out all the features for free for 14 days

MySQL (& MariaDB) data becomes far more useful when it turns into answers and dashboards the whole team can open in seconds. Once your pipelines reach Via Kondado, Power BI and Looker Studio read the data directly, with no database of your own, so you can build custom views of revenue by product line, average order value, repeat purchase rate, ticket resolution time, stock turnover and monthly recurring revenue. In Claude or ChatGPT, through Kondado’s MCP server, a manager can simply ask which products grew fastest last quarter, how many orders were cancelled by region or which customers reduced their spend year over year. You can also combine MySQL (& MariaDB) data with sources such as Google Sheets, BigQuery or PostgreSQL in Kondado to compare operational records with marketing, finance or CRM numbers in a single analysis. Automated updates on your configurable schedule keep every dashboard and every answer current.

How to visualize MySQL (& MariaDB) data in 3 steps

Connect MySQL (& MariaDB) to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, or databases — no code required.

1
Connect your MySQL (& MariaDB) database

Enter the host or address, port, database name, username and password, and add Kondado's addresses to the IP whitelist of your server. Then choose exactly which tables and views to bring, each with its own columns.

2
Choose where to use your data

Via Kondado is the main path: it feeds dashboards in Power BI and Looker Studio and questions in Claude or ChatGPT, with no database of your own. If you prefer, send the same data to Google Sheets, Excel, BigQuery, PostgreSQL or another MySQL database.

3
Build dashboards and ask questions

Create your custom dashboard in Power BI or Looker Studio, or ask in natural language in Claude or ChatGPT through Kondado's MCP server. Kondado keeps your data updated automatically on the schedule you set.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
multilaser
olist
unimed
v4_company
webmotors
yooper

Pick an AI, Spreadsheet, Database, Data Warehouse or Data Lake to use MySQL (& MariaDB) data

Choose a tool to visualize your MySQL (& MariaDB) data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting MySQL (& MariaDB) to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, and databases

What do I need to connect MySQL (& MariaDB) to Kondado? ▼
You need the host or address, port, database name, username and password of your MySQL (& MariaDB) server, and the user must be allowed to read the tables and views you want to bring. IP whitelisting is also required on the database server before the first connection. After that, Kondado reads your structure and lets you select exactly what to replicate.
Why does Kondado require IP whitelisting on my database server? ▼
Whitelisting tells your MySQL (& MariaDB) server which addresses are allowed to open a connection, and Kondado provides the addresses to add during setup. It is a one-time configuration on the server side, handled by whoever administers the database. Once those addresses are allowed, your pipelines can run on the schedule you define.
Can I choose which tables and views Kondado brings? ▼
Yes. After connecting, Kondado reads the structure of your database and you select exactly which tables and views to bring, each with its own columns. Your own names for tables and views are kept, along with your own columns, so what you receive mirrors the structure you already know. You can create additional pipelines later as new areas of the business need data.
How often does Kondado update the data from MySQL (& MariaDB)? ▼
You set the schedule for each pipeline, from every 5 minutes to once a day. Every run refreshes the data you selected, so new rows recorded in your MySQL (& MariaDB) tables appear in Via Kondado and in your dashboards. Recurring reports stay current on their own.
Can I combine MySQL (& MariaDB) data with other sources? ▼
Yes. Kondado connects 100+ sources, so you can bring data from a CRM, an ads platform or a spreadsheet and analyze it alongside your database records. Send everything to BigQuery, PostgreSQL or Google Sheets for a combined view, or keep the pipelines in Via Kondado and build cross-source dashboards there.
How do I ask questions about my MySQL (& MariaDB) data in Claude or ChatGPT? ▼
You add Kondado's MCP server in Claude (Web or Desktop) or in ChatGPT and authorize once with OAuth, with no token and no code. Then you ask questions in natural language about the data you brought, such as which regions had the highest order volume last month. The AI does not change the data in your MySQL (& MariaDB) source and does not execute actions in your systems.
Do I need a database to build Power BI or Looker Studio dashboards from MySQL (& MariaDB)? ▼
No. Via Kondado feeds Power BI and Looker Studio directly, so the dashboards read the data straight from the platform with no database of your own. You build the custom charts, KPIs and filters you need on top of the tables and views you selected.
Can I keep using my own warehouse as the destination? ▼
Yes. If you prefer, the same pipelines can deliver your MySQL (& MariaDB) data to BigQuery, PostgreSQL, another MySQL database, Google Sheets or Excel. Many teams use Via Kondado for dashboards and AI questions while also keeping a copy in their warehouse.

Try out all the features for free for 14 days