1**Example 1: To describe the parameters in a DB cluster parameter group**
2
3The following ``describe-db-cluster-parameters`` example retrieves details about the parameters in a DB cluster parameter group. ::
4
5    aws rds describe-db-cluster-parameters \
6        --db-cluster-parameter-group-name mydbclusterpg
7
8Output::
9
10    {
11        "Parameters": [
12            {
13                "ParameterName": "allow-suspicious-udfs",
14                "Description": "Controls whether user-defined functions that have only an xxx symbol for the main function can be loaded",
15                "Source": "engine-default",
16                "ApplyType": "static",
17                "DataType": "boolean",
18                "AllowedValues": "0,1",
19                "IsModifiable": false,
20                "ApplyMethod": "pending-reboot",
21                "SupportedEngineModes": [
22                    "provisioned"
23                ]
24            },
25            {
26                "ParameterName": "aurora_lab_mode",
27                "ParameterValue": "0",
28                "Description": "Enables new features in the Aurora engine.",
29                "Source": "engine-default",
30                "ApplyType": "static",
31                "DataType": "boolean",
32                "AllowedValues": "0,1",
33                "IsModifiable": true,
34                "ApplyMethod": "pending-reboot",
35                "SupportedEngineModes": [
36                    "provisioned"
37                ]
38            },
39            ...some output truncated...
40        ]
41    }
42
43**Example 2: To list only the parameter names in a DB cluster parameter group**
44
45The following ``describe-db-cluster-parameters`` example retrieves only the names of the parameters in a DB cluster parameter group. ::
46
47    aws rds describe-db-cluster-parameters \
48        --db-cluster-parameter-group-name default.aurora-mysql5.7 \
49        --query 'Parameters[].{ParameterName:ParameterName}'
50
51Output::
52
53    [
54        {
55            "ParameterName": "allow-suspicious-udfs"
56        },
57        {
58            "ParameterName": "aurora_binlog_read_buffer_size"
59        },
60        {
61            "ParameterName": "aurora_binlog_replication_max_yield_seconds"
62        },
63        {
64            "ParameterName": "aurora_binlog_use_large_read_buffer"
65        },
66        {
67            "ParameterName": "aurora_lab_mode"
68        },
69
70        ...some output truncated...
71        }
72    ]
73
74**Example 3: To describe only the modifiable parameters in a DB cluster parameter group**
75
76The following ``describe-db-cluster-parameters`` example retrieves the names of only the parameters that you can modify in a DB cluster parameter group. ::
77
78    aws rds describe-db-cluster-parameters \
79        --db-cluster-parameter-group-name default.aurora-mysql5.7 \
80        --query 'Parameters[].{ParameterName:ParameterName,IsModifiable:IsModifiable} | [?IsModifiable == `true`]'
81
82Output::
83
84    [
85        {
86            "ParameterName": "aurora_binlog_read_buffer_size",
87            "IsModifiable": true
88        },
89        {
90            "ParameterName": "aurora_binlog_replication_max_yield_seconds",
91            "IsModifiable": true
92        },
93        {
94            "ParameterName": "aurora_binlog_use_large_read_buffer",
95            "IsModifiable": true
96        },
97        {
98            "ParameterName": "aurora_lab_mode",
99            "IsModifiable": true
100        },
101
102        ...some output truncated...
103        }
104    ]
105
106**Example 4: To describe only the modifable Boolean parameters in a DB cluster parameter group**
107
108The following ``describe-db-cluster-parameters`` example retrieves the names of only the parameters that you can modify in a DB cluster parameter group and that have a Boolean data type. ::
109
110    aws rds describe-db-cluster-parameters \
111        --db-cluster-parameter-group-name default.aurora-mysql5.7 \
112        --query 'Parameters[].{ParameterName:ParameterName,DataType:DataType,IsModifiable:IsModifiable} | [?DataType == `boolean`] | [?IsModifiable == `true`]'
113
114Output::
115
116    [
117        {
118            "DataType": "boolean",
119            "ParameterName": "aurora_binlog_use_large_read_buffer",
120            "IsModifiable": true
121        },
122        {
123            "DataType": "boolean",
124            "ParameterName": "aurora_lab_mode",
125            "IsModifiable": true
126        },
127        {
128            "DataType": "boolean",
129            "ParameterName": "autocommit",
130            "IsModifiable": true
131        },
132        {
133            "DataType": "boolean",
134            "ParameterName": "automatic_sp_privileges",
135            "IsModifiable": true
136        },
137        ...some output truncated...
138        }
139    ]
140
141For more information, see `Working with DB Parameter Groups and DB Cluster Parameter Groups <https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_WorkingWithParamGroups.html>`__ in the *Amazon Aurora User Guide*.
142