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.
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.
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
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.