Generally, Redash should give you all the data that you need. But sometimes you need a direct connection to Postgres instead.

Host: db.neynar.com

Port: 5432 (the default)

Username: A short code that we will email to you

Password: Your API Key

Tips

• When connecting to the database, be sure to use connection pooling. These docs for the node.js pg library explain pooling well.
• Set “sslmode” to “prefer”. We have a certificate, but it is for the amazon load balancer name and not for our domain.