Query PostgreSQL Configuration Settings
pg_list_settingsSearch and inspect PostgreSQL runtime settings from pg_settings. Filter by name, category, or only modified settings to analyze database configuration.
Instructions
Search and inspect PostgreSQL runtime settings from pg_settings.
Args:
name_pattern: ILIKE filter on setting name, e.g. "work_mem" or "%memory%" (optional)
category: Filter by category name, e.g. "Memory", "Connections and Authentication", "WAL" (optional)
modified_only: Only show settings that differ from their compiled default (default: false)
response_format: Output format
Returns: JSON: { settings: SettingInfo[], count: number } Markdown: table with name, current value, unit, source, context, description
Common categories: Memory, Connections and Authentication, WAL, Query Tuning, Autovacuum, Logging, Lock Management, Replication, Resource Usage.
Note: 'context' shows where the setting can be changed:
internal: read-only, compiled in
postmaster: requires server restart
sighup: reload only (pg_reload_conf())
user: changeable per-session
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name_pattern | No | ILIKE filter on setting name, e.g. "%mem%" | |
| category | No | Category filter, e.g. "Memory" or "WAL" | |
| modified_only | No | Only show settings changed from default | |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |