Using Aurora PostgreSQL-Compatible Edition? See AWS Aurora (Postgres).
Get your Aurora MySQL connection details
Aurora clusters expose two endpoints:- Writer (cluster) endpoint — the primary instance.
- Reader endpoint — load-balances across replicas. Use this for QueryBear.
3306.
Allow QueryBear’s IP
- Get QueryBear’s egress IP from the dashboard under Connections → Network.
- Add an inbound rule to the cluster’s security group for that IP on port
3306. - Ensure the cluster is publicly accessible or reachable via VPC peering / PrivateLink.
Create a read-only user
Use the MySQL read-only user SQL. Run it against the writer endpoint, then connect QueryBear to the reader endpoint.Add the connection to QueryBear
In the QueryBear dashboard → Connections → New connection → MySQL. Use the reader endpoint, port3306, your querybear user, and SSL mode require.
Aurora MySQL-specific notes
- Reader endpoint for reads: Keeps AI query load off the writer.
- TLS: Aurora supports the Amazon RDS CA bundle; QueryBear connects over TLS.
- Multi-statement queries blocked at the parser.