Skip to main content
Version: 2.30.0


ToolJet can connect to MySQL databases to read and write data.


To establish a connection with the MySQL data source, you can either click on the +Add New button located on the query panel or navigate to the Data Sources page through the ToolJet dashboard.

MySQL data source


Please make sure the Host/IP of the database is accessible from your VPC if you have self-hosted ToolJet. If you are using ToolJet cloud, please whitelist our IP.

ToolJet requires the following to connect to your MySQL database:

UsernameUsername of the MySQL database
PasswordPassword of the MySQL database
Database nameName of the MySQL database
Connection typeConnection type of the MySQL database: either Hostname or Socket.

If you are using Hostname as the connection type, you will need to provide the following information:

Host/IPHostname or IP address of the MySQL database
PortPort number of the MySQL database
SSLEnable SSL connection to the MySQL database

If you are using Socket as the connection type, you will need to provide the following information:

Socket pathPath of the socket file

It is recommended to create a new MySQL database user so that you can control the access levels of ToolJet.


Click on Test connection to verify the correctness of the provided credentials and the accessibility of the database to the ToolJet server. Finally, click the Save button to save the data source configuration.

Querying MySQL

Once the MySQL data source is added, you can create queries to read and write data to the database. You can create queries from the Query Panel located at the bottom panel of the app builder.

  1. SQL mode
  2. GUI mode

SQL mode

SQL mode can be used to query MySQL database using SQL queries. Select SQL mode from the dropdown and then enter the SQL query in the editor.



GUI mode

GUI mode can be used to query MySQL database without writing queries. Select GUI mode from the dropdown and then choose the operation Bulk update using primary key. Enter the Table name and Primary key column name. Now, in the editor enter the records in the form of an array of objects. Each object should contain the primary key column and the columns to be updated.


{{ [ {id: 1, channel: 33}, {id:2, channel:24} ] }}

Query results can be transformed using transformations. Learn more about transformations here.