How can I run queries on top of Panoply?

Any visualization tool that supports ODBC, JDBC, Postgres, or AWS Redshift can connect to Panoply. The credentials needed to connect to Panoply are available by clicking Connect Icon Connect from the side nav. This will display a window similar to the following image.

Always connect to a replication of your production database. Connecting to the production database is against best practices.