DBHub

# DBHub Configuration # Method 1: Connection String (DSN) # Use one of these DSN formats: # DSN=postgres://user:password@localhost:5432/dbname # DSN=sqlite:///path/to/database.db # DSN=sqlite::memory: # DSN=sqlserver://user:password@localhost:1433/dbname # DSN=mysql://user:password@localhost:3306/dbname DSN= # Method 2: Individual Database Parameters # Use this method if your password contains special characters like @, :, /, #, etc. # that would break URL parsing in the DSN format above # DB_TYPE=postgres # DB_HOST=localhost # DB_PORT=5432 # DB_USER=postgres # DB_PASSWORD=my@password:with/special#chars # DB_NAME=mydatabase # Supported DB_TYPE values: postgres, mysql, mariadb, sqlserver, sqlite # DB_PORT is optional - defaults to standard port for each database type # For SQLite: only DB_TYPE and DB_NAME are required (DB_NAME is the file path) # Transport configuration (for MCP server only) # --transport=stdio (default) for stdio transport (for Claude Desktop/Code) # --transport=http for HTTP transport with streamable MCP endpoint # Note: Frontend is always served via HTTP regardless of transport setting TRANSPORT=stdio # HTTP server port (default: 8080) # Used for both frontend and MCP endpoint (when transport=http) PORT=8080 # SSH Tunnel Configuration (optional) # Use these settings to connect through an SSH bastion host # SSH_HOST=bastion.example.com # SSH_PORT=22 # SSH_USER=ubuntu # SSH_PASSWORD=mypassword # SSH_KEY=~/.ssh/id_rsa # SSH_PASSPHRASE=mykeypassphrase # Read-only mode (optional) # Set to true to restrict SQL execution to read-only operations # READONLY=false