Database Access

Database Access is available for sites on USD 50 and above plans

You will now have complete access to your site's database.

Enable Database Access

Go to Site Dashboard > Database > Access.

Enable Database Access

If you haven't previously used this feature click on Enable Access after selecting the type of access you need. Now you'll see credentials to connect your database.

Database Access Credentials

Connect to the Database

Analytics or Business Intelligence tool

Copy the credentials shown to your analytics tool.

We only allow TLS connections. If you're having issues while connecting then please ensure that the analytics tool is using SSL/TLS and our certificate chain.pem for *.frappe.cloud (Signed by Let's Encrypt).

MariaDB/MySQL command line client

Database Access CLI

Copy the command to your console and paste the password when prompted.

You will need to install mariadb-client or mysql-client on your machine.

If you have read-write access to your database, any changes made to your database will be permanent.

FAQ: Cannot connect to database from PowerBI

If connecting with PowerBI doesn't work, you might be using MySQL Connector. We use MariaDB for our databases. Please use Mariadb connector with PowerBI for the same. You can find docs for the same here.

On this page