Search settings
pg_settingsSearch PostgreSQL configuration parameters to inspect current and default values, value sources, restart requirements and pending restarts, configuration errors, and database or role overrides.
Instructions
Search server configuration parameters (GUCs): current value with unit, default, where the value comes from (default, configuration file with line, ALTER SYSTEM, ...), whether changing it needs a restart, whether a restart is pending, and a short description. Also lists errors found in the configuration files and the per-database and per-role overrides (ALTER DATABASE/ROLE ... SET).
pattern matches parameter names (and descriptions), with * wildcards; category
filters by group (for example "Write-Ahead Log"); changed_only hides parameters still at
their default; pending_restart_only shows what waits for a restart.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "pg_settings"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| pattern | No | ||
| category | No | ||
| connection | No | ||
| changed_only | No | ||
| pending_restart_only | No |