rds.extensions.listList supported extensions with installed and available versions, preload state and whether a restart is pending
Request syntax
GET /rds/api/instances/{id}/extensionsPath parameters
idRequiredstring
Constraints: 3-64 chars, /^(?!ewdoc-)[a-z0-9-]+$/
Query parameters
databaseOptionalstring
Database inside the instance; omitted: the one created with the instance
Constraints: 1-63 chars
Response
200 with database, databases, topology, preload, restartRequired and extensions: name, description, category, available, enabled, defaultVersion, installedVersion, schema, preloadLibrary, preloaded, restartPending, … .
A JSON response is wrapped as { "success": true, "data": … }; the CLI prints the whole body with --json.
Fields of data
databaseAlwaysstring
Database readdatabasesAlwaysarray of string
Every database on the servertopologyAlwaysone of single, cluster
Topology of the databasepreloadAlwaysobject
shared_preload_librariespreload.runningAlwaysarray of string
Libraries the running server loaded: the ones in effectpreload.configuredAlwaysarray of string
Libraries configured; differ from running until a restartrestartRequiredAlwaysboolean
The preload list changed and waits for a restartextensionsAlwaysarray of object
Every supported extensionextensions[].nameAlwaysstring
Name CREATE EXTENSION takesextensions[].descriptionAlwaysstring
What it doesextensions[].categoryAlwaysone of ai, search, types, geo, indexing, jobs, monitoring, security, fdw, dev, utility
Group it is shown inextensions[].sourceAlwaysone of contrib, pgdg
contrib: ships with PostgreSQL; pgdg: an extra packageextensions[].trustedAlwaysboolean
Any role with CREATE on the database can create itextensions[].requiresAlwaysarray of string
Extensions it needs, installed with itextensions[].noteAlwaysstring, may be null
What to know before switching it onextensions[].preloadLibraryAlwaysstring, may be null
Library it needs preloaded; null: noneextensions[].preloadedAlwaysboolean, may be null
That library is loaded now; null: it needs noneextensions[].singleDatabaseAlwaysboolean
Can live in one database of the server onlyextensions[].homeDatabaseAlwaysstring, may be null
For a single-database extension: the database it may live inextensions[].availableAlwaysboolean
Installed on the server, so it can be enabledextensions[].defaultVersionAlwaysstring
Version CREATE EXTENSION installsextensions[].installedVersionAlwaysstring, may be null
Version enabled in this database; null: not enabledextensions[].schemaAlwaysstring, may be null
Schema it lives inextensions[].enabledAlwaysboolean
Enabled in this databaseextensions[].restartPendingAlwaysboolean
Its library was added and loads at the next restart
Checked against the handlers: every route test validates their answers against this schema.
Errors
- 400The request does not pass the schema above. The body is { "error": …, "issues": […] }, one issue per field.
- 401No credentials, or an access key that is unknown, revoked or expired.
- 403The caller's policies do not allow rds:DescribeDBExtensions on this resource. The body names the action and the resource, and the refusal is recorded in the audit log.
- 404The resource does not exist in your organization.
Examples
The required parameters only, with example values. Replace id and the other placeholders with your own.
dcloud rds extensions list idcurl -X GET "https://console.platform-development.deutschecloud.app/rds/api/instances/id/extensions" \
-H "Authorization: EWS-ACCESS-KEY $ACCESS_KEY"Generated from the API description, the same one the API checks requests against and the CLI is built from. MCP tool: dcloud_rds_extensions_list.