PostreSQL datasource Configuration

Powerful open-source relational database with extensibility and SQL standards.

Parameters

Name	Type	Required	Description
host	string	✅	Database host, e.g., localhost
port	integer	✅	Database port, e.g., 3306
user	string	✅	Database user to connect
database	string	✅	Database name
driver	string	❌	Driver name for postgres, default is postgresql+psycopg2. Defaults：postgresql+psycopg2
password	string	❌	Database password, you can write your password directly, of course, you can also use environment variables, such as ${env:DBGPT_DB_PASSWORD} Defaults：${env:DBGPT_DB_PASSWORD}
pool_size	integer	❌	Connection pool size, default 5 Defaults：5
max_overflow	integer	❌	Max overflow connections, default 10 Defaults：10
pool_timeout	integer	❌	Connection pool timeout, default 30 Defaults：30
pool_recycle	integer	❌	Connection pool recycle, default 3600 Defaults：3600
pool_pre_ping	boolean	❌	Connection pool pre ping, default True Defaults：True
schema	string	❌	Database schema, defaults to 'public' Defaults：public