get_postgresql_config
Retrieve PostgreSQL server configuration parameters to view current values, descriptions, and change requirements for performance tuning and system analysis.
Instructions
[Tool Purpose]: Retrieve and analyze PostgreSQL server configuration parameter values
[Exact Functionality]:
Retrieve all PostgreSQL configuration parameters (when config_name is not specified)
Retrieve current value and description of specific configuration parameter
Filter configurations by text pattern (when filter_text is specified)
Display whether configuration can be changed and if restart is required
[Required Use Cases]:
When user requests "PostgreSQL config", "config", "parameters", etc.
When checking specific configuration values is needed
When searching for configurations containing specific text
When configuration status identification is needed for performance tuning
[Strictly Prohibited Use Cases]:
Requests for configuration value changes or modifications
Requests for PostgreSQL restart or reload
Requests for system-level configuration changes
Args: config_name: Specific configuration parameter name to retrieve (shows all configs if omitted) filter_text: Text to filter configuration names or descriptions (optional)
Returns: Configuration information including parameter name, current value, unit, description, and changeability
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| config_name | No | ||
| filter_text | No |