steampipe plugin install aws

Table: aws_rds_db_parameter_group - Query AWS RDS DB Parameter Groups using SQL

The AWS RDS DB Parameter Group is a feature of Amazon Relational Database Service (RDS) that allows you to manage database engine configuration settings. These groups act as containers for engine parameter values that can be applied to one or more DB instances. The parameters in a DB parameter group enable you to control the runtime settings of a DB instance.

Table Usage Guide

The aws_rds_db_parameter_group table in Steampipe provides you with information about DB Parameter Groups within AWS Relational Database Service (RDS). This table allows you, as a DevOps engineer, to query parameter group-specific details, including associated databases, parameter settings, and associated metadata. You can utilize this table to gather insights on parameter groups, such as understanding the configurations that control the behavior of the databases they are associated with, ensuring appropriate settings for optimal database performance, and more. The schema outlines the various attributes of the DB Parameter Group for you, including the parameter group name, family, description, and associated tags.


List of DB parameter group and corresponding parameter group family

Discover the correlation between database parameter groups and their corresponding families within the AWS RDS service. This is particularly useful when managing or optimizing the configuration of your relational database system.


Parameters info of each parameter group.

Determine the areas in which different parameters within a database parameter group can be modified, and understand the specific settings that apply to each. This can help to optimize database performance and security by ensuring parameters are correctly configured.

pg ->> 'ParameterName' as parameter_name,
pg ->> 'ParameterValue' as parameter_value,
pg ->> 'AllowedValues' as allowed_values,
pg ->> 'ApplyType' as apply_type,
pg ->> 'IsModifiable' as is_modifiable,
pg ->> 'DataType' as data_type,
pg ->> 'Description' as description,
pg ->> 'MinimumEngineVersion' as minimum_engine_version
cross join jsonb_array_elements(parameters) as pg;
json_extract(pg.value, '$.ParameterName') as parameter_name,
json_extract(pg.value, '$.ParameterValue') as parameter_value,
json_extract(pg.value, '$.AllowedValues') as allowed_values,
json_extract(pg.value, '$.ApplyType') as apply_type,
json_extract(pg.value, '$.IsModifiable') as is_modifiable,
json_extract(pg.value, '$.DataType') as data_type,
json_extract(pg.value, '$.Description') as description,
json_extract(pg.value, '$.MinimumEngineVersion') as minimum_engine_version
json_each(parameters) as pg;

Schema for aws_rds_db_parameter_group

_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) for the DB parameter group.
db_parameter_group_familytextThe name of the DB parameter group family that this DB parameter group is compatible with.
descriptiontextProvides the customer-specified description for this DB parameter group.
nametext=The friendly name to identify the DB parameter group.
parametersjsonbA list of detailed parameter for a particular DB parameter group.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags attached to the DB parameter group.
titletextTitle of the resource.


This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the script:

/bin/sh -c "$(curl -fsSL" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_rds_db_parameter_group