Access the Appian MySQL Database using a SQL Editor like Toad

Are you on-premise or on Appian Cloud?

Appian Cloud

You can verify with Appian support, but typically Appian Cloud customers are not able to connect to the Appian MySQL database directly, the only method of connecting to the database is through Appian.

Unfortunately it's not possible to access the Appian Cloud database from an external SQL client. We've asked a number of times for this functionality but have been told it won't be provided.

Your best option is to set up a local copy of MySQL, export a copy of the database to the local instance and connect the MySQL client to that.

This feature needs to be provided. It is very cumbersome to write DML scripts using the web interface.
Thank you all.

I agree that it would be a useful feature but I can completely understand why it is not provided; the act of exposing a MySQL server to the world wide web brings with it some fairly serious security risks and implications!

For large or complex database scripts I've always used a copy of the database and then connected to that using my preferred SQL client

How do I export out the entire database instead of doing one table at a time? What's the quick and easy method for doing that?

Click on the "Appian" database schema (on the left hand side) and then click on export (further across on the right). It'll give you various options, just select save as .sql and, once downloaded, open the script in the editor and run it against your local instance.

Thanks!! You guys are awesome!