-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path.env.example
More file actions
34 lines (30 loc) · 870 Bytes
/
Copy path.env.example
File metadata and controls
34 lines (30 loc) · 870 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
# PostgreSQL Connection
POSTGRES_HOST=localhost
POSTGRES_PORT=5432
POSTGRES_DATABASE=mydb
POSTGRES_USER=postgres
POSTGRES_PASSWORD=secret
POSTGRES_SSL=false
# When SSL is enabled, reject connections with invalid certificates (recommended: true for production)
POSTGRES_SSL_REJECT_UNAUTHORIZED=true
# Path to CA certificate file for SSL (optional)
# POSTGRES_SSL_CA=/path/to/ca-cert.pem
# Alternative: full connection string (overrides individual settings above)
# POSTGRES_CONNECTION_STRING=postgresql://user:pass@localhost:5432/mydb
# Connection Pool
POOL_MIN=2
POOL_MAX=10
POOL_IDLE_TIMEOUT=30000
# MCP Server
MCP_SERVER_NAME=postgres-mcp
MCP_SERVER_VERSION=1.0.0
MCP_TRANSPORT=stdio
# Security
PERMISSION_LEVEL=read_write
QUERY_TIMEOUT=30000
MAX_ROWS_DEFAULT=1000
RATE_LIMIT_RPM=60
ENABLE_DANGEROUS_OPERATIONS=false
# Logging
LOG_LEVEL=info
LOG_SQL_QUERIES=false