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 cloud. It provides cost-efficient, resizeable capacity for an industry-standard relational database and manages common database administration tasks, freeing up developers to focus on what makes their applications and businesses unique.
Amazon RDS gives you access to the capabilities of a MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle, or Amazon Aurora database server. These capabilities mean that the code, applications, and tools you already use today with your existing databases work with Amazon RDS without modification. Amazon RDS automatically backs up your database and maintains the database software that powers your DB instance. Amazon RDS is flexible: you can scale your DB instance\'s compute resources and storage capacity to meet your application\'s demand. As with all Amazon Web Services, there are no up-front investments, and you pay only for the resources you use.
This interface reference for Amazon RDS contains documentation for a programming or command line interface you can use to manage Amazon RDS. Note that Amazon RDS is asynchronous, which means that some interfaces might require techniques such as polling or callback functions to determine when a command has been applied. In this reference, the parameter descriptions indicate whether a command is applied immediately, on the next instance reboot, or during the maintenance window. The reference structure is as follows, and we list following some related topics from the user guide.
Amazon RDS API Reference
For the alphabetical list of API actions, see API Actions.
For the alphabetical list of data types, see Data Types.
For a list of common query parameters, see Common Parameters.
For descriptions of the error codes, see Common Errors.
Amazon RDS User Guide
For a summary of the Amazon RDS interfaces, see Available RDS Interfaces.
For more information about how to use the Query API, see Using the Query API.
rds(config = list())Optional configuration of credentials, endpoint, and/or region.
svc <- rds(
config = list(
credentials = list(
creds = list(
access_key_id = "string",
secret_access_key = "string",
session_token = "string"
),
profile = "string"
),
endpoint = "string",
region = "string"
)
)
| add_role_to_db_cluster | Associates an Identity and Access Management (IAM) role from an Amazon Aurora DB cluster |
| add_role_to_db_instance | Associates an AWS Identity and Access Management (IAM) role with a DB instance |
| add_source_identifier_to_subscription | Adds a source identifier to an existing RDS event notification subscription |
| add_tags_to_resource | Adds metadata tags to an Amazon RDS resource |
| apply_pending_maintenance_action | Applies a pending maintenance action to a resource (for example, to a DB instance) |
| authorize_db_security_group_ingress | Enables ingress to a DBSecurityGroup using one of two forms of authorization |
| backtrack_db_cluster | Backtracks a DB cluster to a specific time, without creating a new DB cluster |
| build_auth_token | Return an authentication token for a database connection |
| copy_db_cluster_parameter_group | Copies the specified DB cluster parameter group |
| copy_db_cluster_snapshot | Copies a snapshot of a DB cluster |
| copy_db_parameter_group | Copies the specified DB parameter group |
| copy_db_snapshot | Copies the specified DB snapshot |
| copy_option_group | Copies the specified option group |
| create_custom_availability_zone | Creates a custom Availability Zone (AZ) |
| create_db_cluster | Creates a new Amazon Aurora DB cluster |
| create_db_cluster_endpoint | Creates a new custom endpoint and associates it with an Amazon Aurora DB cluster |
| create_db_cluster_parameter_group | Creates a new DB cluster parameter group |
| create_db_cluster_snapshot | Creates a snapshot of a DB cluster |
| create_db_instance | Creates a new DB instance |
| create_db_instance_read_replica | Creates a new DB instance that acts as a Read Replica for an existing source DB instance |
| create_db_parameter_group | Creates a new DB parameter group |
| create_db_proxy | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| create_db_security_group | Creates a new DB security group |
| create_db_snapshot | Creates a DBSnapshot |
| create_db_subnet_group | Creates a new DB subnet group |
| create_event_subscription | Creates an RDS event notification subscription |
| create_global_cluster | Creates an Aurora global database spread across multiple regions |
| create_option_group | Creates a new option group |
| delete_custom_availability_zone | Deletes a custom Availability Zone (AZ) |
| delete_db_cluster | The DeleteDBCluster action deletes a previously provisioned DB cluster |
| delete_db_cluster_endpoint | Deletes a custom endpoint and removes it from an Amazon Aurora DB cluster |
| delete_db_cluster_parameter_group | Deletes a specified DB cluster parameter group |
| delete_db_cluster_snapshot | Deletes a DB cluster snapshot |
| delete_db_instance | The DeleteDBInstance action deletes a previously provisioned DB instance |
| delete_db_instance_automated_backup | Deletes automated backups based on the source instance's DbiResourceId value or the restorable instance's resource ID |
| delete_db_parameter_group | Deletes a specified DB parameter group |
| delete_db_proxy | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| delete_db_security_group | Deletes a DB security group |
| delete_db_snapshot | Deletes a DB snapshot |
| delete_db_subnet_group | Deletes a DB subnet group |
| delete_event_subscription | Deletes an RDS event notification subscription |
| delete_global_cluster | Deletes a global database cluster |
| delete_installation_media | Deletes the installation medium for a DB engine that requires an on-premises customer provided license, such as Microsoft SQL Server |
| delete_option_group | Deletes an existing option group |
| deregister_db_proxy_targets | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| describe_account_attributes | Lists all of the attributes for a customer account |
| describe_certificates | Lists the set of CA certificates provided by Amazon RDS for this AWS account |
| describe_custom_availability_zones | Returns information about custom Availability Zones (AZs) |
| describe_db_cluster_backtracks | Returns information about backtracks for a DB cluster |
| describe_db_cluster_endpoints | Returns information about endpoints for an Amazon Aurora DB cluster |
| describe_db_cluster_parameter_groups | Returns a list of DBClusterParameterGroup descriptions |
| describe_db_cluster_parameters | Returns the detailed parameter list for a particular DB cluster parameter group |
| describe_db_clusters | Returns information about provisioned Aurora DB clusters |
| describe_db_cluster_snapshot_attributes | Returns a list of DB cluster snapshot attribute names and values for a manual DB cluster snapshot |
| describe_db_cluster_snapshots | Returns information about DB cluster snapshots |
| describe_db_engine_versions | Returns a list of the available DB engines |
| describe_db_instance_automated_backups | Displays backups for both current and deleted instances |
| describe_db_instances | Returns information about provisioned RDS instances |
| describe_db_log_files | Returns a list of DB log files for the DB instance |
| describe_db_parameter_groups | Returns a list of DBParameterGroup descriptions |
| describe_db_parameters | Returns the detailed parameter list for a particular DB parameter group |
| describe_db_proxies | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| describe_db_proxy_target_groups | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| describe_db_proxy_targets | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| describe_db_security_groups | Returns a list of DBSecurityGroup descriptions |
| describe_db_snapshot_attributes | Returns a list of DB snapshot attribute names and values for a manual DB snapshot |
| describe_db_snapshots | Returns information about DB snapshots |
| describe_db_subnet_groups | Returns a list of DBSubnetGroup descriptions |
| describe_engine_default_cluster_parameters | Returns the default engine and system parameter information for the cluster database engine |
| describe_engine_default_parameters | Returns the default engine and system parameter information for the specified database engine |
| describe_event_categories | Displays a list of categories for all event source types, or, if specified, for a specified source type |
| describe_events | Returns events related to DB instances, DB security groups, DB snapshots, and DB parameter groups for the past 14 days |
| describe_event_subscriptions | Lists all the subscription descriptions for a customer account |
| describe_global_clusters | Returns information about Aurora global database clusters |
| describe_installation_media | Describes the available installation media for a DB engine that requires an on-premises customer provided license, such as Microsoft SQL Server |
| describe_option_group_options | Describes all available options |
| describe_option_groups | Describes the available option groups |
| describe_orderable_db_instance_options | Returns a list of orderable DB instance options for the specified engine |
| describe_pending_maintenance_actions | Returns a list of resources (for example, DB instances) that have at least one pending maintenance action |
| describe_reserved_db_instances | Returns information about reserved DB instances for this account, or about a specified reserved DB instance |
| describe_reserved_db_instances_offerings | Lists available reserved DB instance offerings |
| describe_source_regions | Returns a list of the source AWS Regions where the current AWS Region can create a Read Replica or copy a DB snapshot from |
| describe_valid_db_instance_modifications | You can call DescribeValidDBInstanceModifications to learn what modifications you can make to your DB instance |
| download_db_log_file_portion | Downloads all or a portion of the specified log file, up to 1 MB in size |
| failover_db_cluster | Forces a failover for a DB cluster |
| import_installation_media | Imports the installation media for a DB engine that requires an on-premises customer provided license, such as SQL Server |
| list_tags_for_resource | Lists all tags on an Amazon RDS resource |
| modify_certificates | Override the system-default Secure Sockets Layer/Transport Layer Security (SSL/TLS) certificate for Amazon RDS for new DB instances, or remove the override |
| modify_current_db_cluster_capacity | Set the capacity of an Aurora Serverless DB cluster to a specific value |
| modify_db_cluster | Modify a setting for an Amazon Aurora DB cluster |
| modify_db_cluster_endpoint | Modifies the properties of an endpoint in an Amazon Aurora DB cluster |
| modify_db_cluster_parameter_group | Modifies the parameters of a DB cluster parameter group |
| modify_db_cluster_snapshot_attribute | Adds an attribute and values to, or removes an attribute and values from, a manual DB cluster snapshot |
| modify_db_instance | Modifies settings for a DB instance |
| modify_db_parameter_group | Modifies the parameters of a DB parameter group |
| modify_db_proxy | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| modify_db_proxy_target_group | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| modify_db_snapshot | Updates a manual DB snapshot, which can be encrypted or not encrypted, with a new engine version |
| modify_db_snapshot_attribute | Adds an attribute and values to, or removes an attribute and values from, a manual DB snapshot |
| modify_db_subnet_group | Modifies an existing DB subnet group |
| modify_event_subscription | Modifies an existing RDS event notification subscription |
| modify_global_cluster | Modify a setting for an Amazon Aurora global cluster |
| modify_option_group | Modifies an existing option group |
| promote_read_replica | Promotes a Read Replica DB instance to a standalone DB instance |
| promote_read_replica_db_cluster | Promotes a Read Replica DB cluster to a standalone DB cluster |
| purchase_reserved_db_instances_offering | Purchases a reserved DB instance offering |
| reboot_db_instance | You might need to reboot your DB instance, usually for maintenance reasons |
| register_db_proxy_targets | This is prerelease documentation for the RDS Database Proxy feature in preview release |
| remove_from_global_cluster | Detaches an Aurora secondary cluster from an Aurora global database cluster |
| remove_role_from_db_cluster | Disassociates an AWS Identity and Access Management (IAM) role from an Amazon Aurora DB cluster |
| remove_role_from_db_instance | Disassociates an AWS Identity and Access Management (IAM) role from a DB instance |
| remove_source_identifier_from_subscription | Removes a source identifier from an existing RDS event notification subscription |
| remove_tags_from_resource | Removes metadata tags from an Amazon RDS resource |
| reset_db_cluster_parameter_group | Modifies the parameters of a DB cluster parameter group to the default value |
| reset_db_parameter_group | Modifies the parameters of a DB parameter group to the engine/system default value |
| restore_db_cluster_from_s3 | Creates an Amazon Aurora DB cluster from data stored in an Amazon S3 bucket |
| restore_db_cluster_from_snapshot | Creates a new DB cluster from a DB snapshot or DB cluster snapshot |
| restore_db_cluster_to_point_in_time | Restores a DB cluster to an arbitrary point in time |
| restore_db_instance_from_db_snapshot | Creates a new DB instance from a DB snapshot |
| restore_db_instance_from_s3 | Amazon Relational Database Service (Amazon RDS) supports importing MySQL databases by using backup files |
| restore_db_instance_to_point_in_time | Restores a DB instance to an arbitrary point in time |
| revoke_db_security_group_ingress | Revokes ingress from a DBSecurityGroup for previously authorized IP ranges or EC2 or VPC Security Groups |
| start_activity_stream | Starts a database activity stream to monitor activity on the database |
| start_db_cluster | Starts an Amazon Aurora DB cluster that was stopped using the AWS console, the stop-db-cluster AWS CLI command, or the StopDBCluster action |
| start_db_instance | Starts an Amazon RDS DB instance that was stopped using the AWS console, the stop-db-instance AWS CLI command, or the StopDBInstance action |
| stop_activity_stream | Stops a database activity stream that was started using the AWS console, the start-activity-stream AWS CLI command, or the StartActivityStream action |
| stop_db_cluster | Stops an Amazon Aurora DB cluster |
# NOT RUN {
svc <- rds()
svc$add_role_to_db_cluster(
Foo = 123
)
# }
# NOT RUN {
# }
Run the code above in your browser using DataLab