Datasources

Connecting Budibase to databases and APIs

Budibase can store your data inside the native internal database (CouchDB). This is the default datasource unless you opt to connect another datasource to Budibase.

List of app datasources

List of app datasources

Budibase supports connection to a range of remote datasources including:

  • Airtable
  • DynamoDB
  • Firestore
  • MongoDB
  • MS SQL Server
  • MySQL / MariaDB
  • PostgreSQL
  • Redis
  • Snowflake

More information about connecting Budibase to each of these datasources is nested in this section of the documentation.

Furthermore, if a datasource you want to use is missing, it is possible to build a custom datasource.

Sample data

Upon creation of an app, Budibase will provide some sample data to allow new users to explore the various Data types available, and quickly build an app for learning purposes. Whilst it is a BudibaseDB source, it will be kept separate to the BudibaseDB tables that you create.

If you do not need this data, it can easily be removed in the same way as other additional datasources. Simply click on the ellipsis to the right of the sample data source and click Delete.

Sample data

Sample data

It is also worth noting that you can choose not to add the sample data when creating an app. Simply toggle Include sample data off.

Creating an app without sample data

Creating an app without sample data

Schema

When Fetching tables from external SQL databases, Budibase will attempt to match the external data types to the internal Budibase DB types. These default types can be changed by clicking the pencil icon beside the table columns:

For other basic datasources and Custom queries, the schema will be determined by selecting types in the query output.

The schema is important, as it will affect how sorting and filtering is applied in the design section.

Security

When connecting to an external datasource you must allow Budibase access to your datasource. Normally datasources will be protected by a firewall and you will need to open firewall access to your datasource from the Budibase cloud or from your self-hosted Budibase. Port numbers and user management differ across each type of datasource so if you have difficulty connecting you should speak to the Database Administrator for your organisation.