Updates project's Postgres config

An MCP tool from the Supabase Management API server, hosted on mcp.hjlabs.in.

Updates project's Postgres config [PUT /v1/projects/{ref}/config/database/postgres]

Name on the gateway: supabase_api__v1_update_postgres_config · may change things.

Parameters

Name	Type	Description
`ref` required	`string`	Project ref
`effective_cache_size`	`string`
`logical_decoding_work_mem`	`string`
`pg_stat_statements.max`	`integer`
`pg_net.batch_size`	`integer`
`autovacuum_max_workers`	`integer`
`autovacuum_work_mem`	`string`
`cron.log_statement`	`boolean`
`log_autovacuum_min_duration`	`string`	Default unit: ms
`log_checkpoints`	`boolean`
`log_connections`	`boolean`
`log_disconnections`	`boolean`
`log_duration`	`boolean`
`log_lock_waits`	`boolean`
`log_recovery_conflict_waits`	`boolean`
`log_replication_commands`	`boolean`
`log_startup_progress_interval`	`string`	Default unit: ms
`log_temp_files`	`string`
`maintenance_work_mem`	`string`
`track_activity_query_size`	`string`
`max_connections`	`integer`
`max_locks_per_transaction`	`integer`
`max_logical_replication_workers`	`integer`
`max_parallel_maintenance_workers`	`integer`
`max_parallel_workers`	`integer`
`max_parallel_workers_per_gather`	`integer`
`max_replication_slots`	`integer`
`max_slot_wal_keep_size`	`string`
`max_standby_archive_delay`	`string`
`max_standby_streaming_delay`	`string`
`max_sync_workers_per_subscription`	`integer`
`max_wal_size`	`string`
`max_wal_senders`	`integer`
`max_worker_processes`	`integer`
`session_replication_role`	`origin \| replica \| local`
`shared_buffers`	`string`
`statement_timeout`	`string`	Default unit: ms
`track_commit_timestamp`	`boolean`
`wal_keep_size`	`string`
`wal_sender_timeout`	`string`	Default unit: ms
`work_mem`	`string`

Through the Smart Gateway, any client can run it by name with call_tool, or let the gateway find it with search_tools:

call_tool arguments

{
  "name": "supabase_api__v1_update_postgres_config",
  "arguments": {
    "ref": "…"
  }
}

Or connect the Supabase Management API server directly, which lists 167 tools including this one:

Run in your terminal

claude mcp add --transport http hj-supabase-api https://mcp.hjlabs.in/mcp/supabase-api \
  --header "Authorization: Bearer YOUR_API_KEY"

Use the updates project's postgres config tool with ref set to ….