{"command":{"effect":"write","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Updates project's Postgres config","properties":{"path":{"type":"object","properties":{"ref":{"minLength":20,"maxLength":20,"pattern":"^[a-z]+$","type":"string","examples":["abcdefghijklmnopqrst"],"description":"Project ref"}},"required":["ref"],"additionalProperties":false},"body":{"$ref":"#/definitions/UpdatePostgresConfigBody"}},"required":["path","body"],"additionalProperties":false,"definitions":{"UpdatePostgresConfigBody":{"type":"object","properties":{"effective_cache_size":{"type":"string"},"logical_decoding_work_mem":{"type":"string"},"pg_stat_statements.max":{"type":"integer","minimum":100,"maximum":45000},"pg_net.batch_size":{"type":"integer","minimum":0,"maximum":32767},"autovacuum_max_workers":{"type":"integer","minimum":1,"maximum":262143},"autovacuum_work_mem":{"type":"string"},"cron.log_statement":{"type":"boolean"},"log_autovacuum_min_duration":{"type":"string","description":"Default unit: ms","pattern":"^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"},"log_checkpoints":{"type":"boolean"},"log_connections":{"type":"boolean"},"log_disconnections":{"type":"boolean"},"log_duration":{"type":"boolean"},"log_lock_waits":{"type":"boolean"},"log_recovery_conflict_waits":{"type":"boolean"},"log_replication_commands":{"type":"boolean"},"log_startup_progress_interval":{"type":"string","description":"Default unit: ms","pattern":"^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"},"log_temp_files":{"type":"string"},"maintenance_work_mem":{"type":"string"},"track_activity_query_size":{"type":"string"},"max_connections":{"type":"integer","minimum":1,"maximum":262143},"max_locks_per_transaction":{"type":"integer","minimum":10,"maximum":2147483640},"max_logical_replication_workers":{"type":"integer","minimum":0,"maximum":262143},"max_parallel_maintenance_workers":{"type":"integer","minimum":0,"maximum":1024},"max_parallel_workers":{"type":"integer","minimum":0,"maximum":1024},"max_parallel_workers_per_gather":{"type":"integer","minimum":0,"maximum":1024},"max_replication_slots":{"type":"integer","minimum":-9007199254740991,"maximum":9007199254740991},"max_slot_wal_keep_size":{"type":"string"},"max_standby_archive_delay":{"type":"string"},"max_standby_streaming_delay":{"type":"string"},"max_sync_workers_per_subscription":{"type":"integer","minimum":0,"maximum":262143},"max_wal_size":{"type":"string"},"max_wal_senders":{"type":"integer","minimum":-9007199254740991,"maximum":9007199254740991},"max_worker_processes":{"type":"integer","minimum":0,"maximum":262143},"session_replication_role":{"type":"string","enum":["origin","replica","local"]},"shared_buffers":{"type":"string"},"statement_timeout":{"type":"string","description":"Default unit: ms","pattern":"^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"},"track_commit_timestamp":{"type":"boolean"},"wal_keep_size":{"type":"string"},"wal_sender_timeout":{"type":"string","description":"Default unit: ms","pattern":"^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"},"work_mem":{"type":"string"},"checkpoint_timeout":{"type":"string","description":"Default unit: s","pattern":"^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"},"hot_standby_feedback":{"type":"boolean"},"restart_database":{"type":"boolean"}},"additionalProperties":false,"examples":[{"max_connections":120,"shared_buffers":"256MB","work_mem":"4MB","statement_timeout":"60000ms"}]}}},"name":"Updates project's Postgres config","id":"supabase.v1-update-postgres-config","example":{"path":{"ref":"abcdefghijklmnopqrst"},"body":{"max_connections":120,"shared_buffers":"256MB","work_mem":"4MB","statement_timeout":"60000ms"}},"maxRequests":1,"summary":false}}