Amazon RDS is AWS’s managed relational database service. QueryBear connects to RDS for PostgreSQL and MySQL over the standard wire protocol, giving your AI clients safe, read-only access through QueryBear’s security gateway.Documentation Index
Fetch the complete documentation index at: https://docs.querybear.com/llms.txt
Use this file to discover all available pages before exploring further.
Get your RDS connection details
- Open the RDS console.
- Select your database instance.
- Copy the Endpoint and Port from the Connectivity & security tab.
Allow QueryBear’s IP
RDS instances sit behind a security group. To let QueryBear connect:- Find QueryBear’s egress IP in the dashboard under Connections → Network.
- In the RDS instance’s VPC security group, add an inbound rule allowing that IP on your DB port (
5432for Postgres,3306for MySQL). - Ensure the instance is publicly accessible, or set up VPC peering / PrivateLink if you keep it private.
Create a read-only user
- For Postgres, use the PostgreSQL read-only role SQL.
- For MySQL, use the MySQL read-only user SQL.
Add the connection to QueryBear
In the QueryBear dashboard → Connections → New connection, choose PostgreSQL or MySQL, paste the RDS endpoint, and set SSL moderequire. RDS supports TLS with the Amazon RDS CA out of the box.
RDS-specific notes
- SSL/TLS: RDS supports encrypted connections via the
rds-ca-rsa2048-g1bundle. QueryBear uses TLS by default. - Read replicas: Ideal target — isolates AI query load.
- Multi-AZ: Connect to the cluster/instance endpoint; failover is transparent.