Skip to main content

Version: 0.0.25

Table: RDS

Table to manage AWS RDS instances. Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud.

It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

Example

INSERT INTO rds (db_instance_identifier, allocated_storage, db_instance_class, master_username, master_user_password, availability_zone, engine, backup_retention_period)
VALUES ('db_name', 20, 'db.t3.micro', 'test', 'testpass', (SELECT name FROM availability_zone WHERE region = 'us-east-1' LIMIT 1), 'postgres:13.4', 0);
SELECT * FROM rds WHERE db_instance_identifier = 'db_name';
DELETE FROM rds WHERE db_instance_identifier = 'db_name';

See

Columns

• allocated_storage: number

Amount of storage requested for the database

See

https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/clients/client-rds/interfaces/createdbinstancecommandinput.html#allocatedstorage

• availability_zone: availability_zone

Reference to the availability zones for the database

See

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZ.html

• backup_retention_period: number

Limit of days for keeping a database backup

See

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html#USER_WorkingWithAutomatedBackups.Enabling

• db_instance_class: string

Class that represents the computation and memory capacity of an Amazon RDS DB instance

See

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html#Concepts.DBInstanceClass.Types

• db_instance_identifier: string

Name for the databae

• Optional endpoint_addr: string

Address used to connect to the RDS database

See

https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_Endpoint.html

• Optional endpoint_hosted_zone_id: string

Hosted zone ID used to connect to the RDS database

See

https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_Endpoint.html

• Optional endpoint_port: number

Port used to connect to the RDS database

See

https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_Endpoint.html

• engine: string

Engine to use for the current database

See

https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-engine-versions.html

• Optional master_user_password: string

Master user password for the database

See

https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/clients/client-rds/interfaces/createdbinstancecommandinput.html#masteruserpassword

• Optional master_username: string

Master username for the database

See

https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/clients/client-rds/interfaces/createdbinstancecommandinput.html#masterusername

• Optional parameter_group: parameter_group

List of the parameter groups associated with the database

• region: string

Region for the database

• vpc_security_groups: security_group[]

Reference to the VPC security groups for the database

See

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.RDSSecurityGroups.html

Columns