Skip to content
Management API Reference

[Alpha] Get a project's service configuration

get/v2/projects/{ref}/config

Returns the project's database, pooler, Auth, Data API, Realtime and Storage configuration — the same configuration a branch inherits from its base project. Each is the effective config, so a setting the project has never overridden is reported at its platform default rather than as null. Auth secrets are returned as an HMAC of their value. storage is read live from the storage service; the rest come from this platform's own records.

The fine-grained token must include the following permissions to access this endpoint:

  • database_config_read
  • database_read
  • database_ssl_config_read
  • database_network_restrictions_read
  • auth_config_read
  • data_api_config_read
  • realtime_config_read
  • storage_config_read

Path parameters

  • ref
    Required
    string

    Project ref

Response codes

  • 200
  • 401
  • 403
  • 429

Response (200)

{
"data": {
"type": "project_config",
"id": "lorem",
"attributes": {
"database": {
"major_version": -9007199254740991,
"ssl_enforced": true,
"network_restrictions": {
"entitlement": "disallowed",
"status": "stored",
"allowed_cidrs": [
{
"address": "lorem",
"type": "v4"
}
],
"updated_at": "lorem",
"applied_at": "lorem"
},
"postgres_settings": {
"effective_cache_size": "lorem",
"logical_decoding_work_mem": "lorem",
"log_autovacuum_min_duration": "444444444444444444444444444444444444444444444444444",
"log_checkpoints": true,
"log_connections": true,
"log_disconnections": true,
"log_duration": true,
"log_lock_waits": true,
"log_recovery_conflict_waits": true,
"log_replication_commands": true,
"log_startup_progress_interval": "444444444444444444444444444444444444444444444444444",
"log_temp_files": "lorem",
"maintenance_work_mem": "lorem",
"track_activity_query_size": "lorem",
"max_connections": 1,
"max_locks_per_transaction": 10,
"max_logical_replication_workers": 0,
"max_parallel_maintenance_workers": 0,
"max_parallel_workers": 0,
"max_parallel_workers_per_gather": 0,
"max_replication_slots": -9007199254740991,
"max_slot_wal_keep_size": "lorem",
"max_standby_archive_delay": "lorem",
"max_standby_streaming_delay": "lorem",
"max_sync_workers_per_subscription": 0,
"max_wal_size": "lorem",
"max_wal_senders": -9007199254740991,
"max_worker_processes": 0,
"session_replication_role": "origin",
"shared_buffers": "lorem",
"statement_timeout": "444444444444444444444444444444444444444444444444444",
"track_commit_timestamp": true,
"wal_keep_size": "lorem",
"wal_sender_timeout": "444444444444444444444444444444444444444444444444444",
"work_mem": "lorem",
"checkpoint_timeout": "444444444444444444444444444444444444444444444444444",
"hot_standby_feedback": true,
"cron_log_statement": true
}
},
"pooler": {
"pool_mode": "transaction",
"ignore_startup_parameters": "lorem",
"server_idle_timeout": -9007199254740991,
"server_lifetime": -9007199254740991,
"query_wait_timeout": -9007199254740991,
"reserve_pool_size": -9007199254740991,
"default_pool_size": -9007199254740991,
"max_client_conn": -9007199254740991
},
"auth": {
"property1": null,
"property2": null
},
"api": {
"db_schema": "lorem",
"db_extra_search_path": "lorem",
"max_rows": -9007199254740991,
"db_pool_acquisition_timeout": -9007199254740991,
"db_pool": -9007199254740991
},
"realtime": {
"private_only": true,
"max_concurrent_users": -9007199254740991,
"max_events_per_second": -9007199254740991,
"max_bytes_per_second": -9007199254740991,
"max_channels_per_client": -9007199254740991,
"max_joins_per_second": -9007199254740991,
"max_presence_events_per_second": -9007199254740991,
"max_payload_size_in_kb": -9007199254740991,
"presence_enabled": true,
"suspend": true,
"connection_pool": -9007199254740991,
"postgres_changes_pool": -9007199254740991
},
"storage": {
"file_size_limit": -9007199254740991,
"features": {
"image_transformation": {
"enabled": true
},
"s3_protocol": {
"enabled": true
},
"purge_cache": {
"enabled": true
},
"iceberg_catalog": {
"enabled": true,
"max_namespaces": -9007199254740991,
"max_tables": -9007199254740991,
"max_catalogs": -9007199254740991
},
"vector_buckets": {
"enabled": true,
"max_buckets": -9007199254740991,
"max_indexes": -9007199254740991
}
},
"capabilities": {
"list_v2": true,
"iceberg_catalog": true
},
"upstream_target": "main",
"migration_version": "lorem",
"database_pool_mode": "lorem"
}
}
}
}