Q: Importing Data
Can we import data via API or just uploads?
Like I use MySQL and Postgres, can we not give a query that is used to load the data?
If I can automate this completely I am in.

Andrea_ChartPixel
May 5, 2025A: Hi there! Great question. Yes, you can import data into our platform using SQL connections, and we support both MySQL and Postgres. You'll just need to provide your database credentials (host, username, password, schema, and table). Your login details are not saved as the connection is used only once to pull the data into your project.
You can choose which columns to include after the connection is made, and you can import either the top or bottom rows, with a limit of up to 100,000 rows per import.
At the moment, we don’t support custom SQL queries directly, mainly to prevent accidental changes like deleting rows or dropping tables. :-) However, we like tis idea and something we're open to exploring with our developers.
Thanks again for the suggestion. Making automation easier is one of our top priorities!