pgsql-mcp

# Postgres MCP Pro Environment Configuration # Copy this file to .env and update the values # Required: PostgreSQL database connection URI DATABASE_URI=postgresql://username:password@localhost:5432/dbname # Access mode: "unrestricted" (full access) or "restricted" (read-only with protections) # ACCESS_MODE=unrestricted # Query timeout in seconds for restricted mode (default: 30) # QUERY_TIMEOUT=30 # SSE Transport Configuration (only used when --transport=sse) # SSE_HOST=localhost # SSE_PORT=8000 # SSE_PATH=/sse # CORS Configuration for SSE transport # Comma-separated list of allowed origins, or '*' for all (not recommended for production) # CORS_ALLOW_ORIGINS=http://localhost:3000,https://myapp.example.com # OpenAI API key (required for LLM-based index optimization) # OPENAI_API_KEY=sk-...