GoPie
Get started
Menu
On this page

Database & cloud sources

Connect to MySQL

Import any query result from a MySQL (or MariaDB-compatible) database as a dataset.

Before you start

You need a connection string for a user with read access to the tables in your query:

mysql://user:password@host:3306/database

Non-default ports and connection options go directly in the string. The database must be reachable from your GoPie deployment.

Connect

  1. From your project, select Create Dataset, then the MySQL tile under Connect to Database.
  2. Name the dataset and paste the Connection string.
  3. Write the SQL query whose result becomes the dataset — for example SELECT * FROM orders LIMIT 1000 while you experiment, then the real query for the import.
  4. Optionally set a Timestamp column and an AI context hint, then select Import dataset.

Enable incremental refresh

Set Timestamp column to a monotonically growing column in your result (such as updated_at). Incremental refreshes then append only rows newer than the last run, rather than re-importing the full result. Full refresh remains available either way. See Refresh & scheduled refreshes.

Tip

Incremental refresh appends — it won't pick up updates or deletions to rows it already imported. If your table mutates in place, use full refresh.

Give feedback