I am attempting to connect to my relational database on aws so I can create tables and the likes.
When I click Action then Query, and fill out the form with the correct information, I get the following.
How do I "enable Data API?"
You can enable Data API using in your RDS console's Connectivity section for your postgresql and modify existing database to enable the API:
More in Enabling the Data API.