SQL Database Connector

The SQL Database Connector Plugin connects to databases and runs SQL queries from within Bubble. These queries can be triggered as actions, datasources (they show up as External APIs) or both. Bubble supports connecting to PostGres, MySQL and Microsoft SQL.
Setup
A connection should look like:
mysql://username:[email protected]:PORT/db_name
If there are special characters in the password, they must be URL-encoded, for instance replacing # with %23. The rest of the encodings are listed here.
Tip: Some special characters are not supported by the default mySQL integration, which uses UTF8 encoding. You can add ?charset=UTF8MB4_GENERAL_CI to resolve this and appropriately send characters such as emojis to your SQL database.
If the connection needs to be encrypted, e.g., with Microsoft Azure, add ?encrypt=true or ?ssl=true to the connection.
Once a connection string is created, you can create queries that use it.
Any SQL statement is allowed, but for SELECT statements, you must add LIMIT N at the end, where N <= 100. Once you test and save the query, you can use it as an action, data source, or both, depending on how you configured it. Please note that a SELECT query returns a list, so when using it as the result of a previous step in a workflow, you must select a specific element by using :first item, :last item, etc.
FAQ
Will the plugin use the default port based on the URL scheme? 
All fields are required in the connect string, including port number. For mysql, that's typically 3306, for Postgres, that's 5432.
​

Slick Slideshow

Star Rating

Last modified 4mo ago

Copy link

Contents

Setup

FAQ

Will the plugin use the default port based on the URL scheme?