Database Connection String with Credentials Regex for Go

What this pattern does

This page provides a comprehensive, battle-tested regular expression for matching database connection string with credentials, ported and verified for Go. In security-sensitive code, using an unverified regex can open the door to both false positives and denial-of-service attacks. The snippet below is ready to drop into your Go project — whether you're validating in a Gin handler, a gRPC service, or a command-line tool.

Go Implementation

// Database Connection String with Credentials
// ReDoS-safe | RegexVault — Security > Secrets & Config

package validation

import "regexp"

var databaseConnectionStringWithCredentialsRe = regexp.MustCompile(`^(postgres(?:ql)?|mysql|mongodb(?:\+srv)?|redis|mssql|sqlserver|mariadb|oracle):\/\/([^:]+):([^@]+)@([^/?]+)(?:\/([^?]+))?(?:\?(.+))?$`)

func ValidateDatabaseConnectionStringWithCredentials(s string) bool {
    return databaseConnectionStringWithCredentialsRe.MatchString(s)
}

// Example
// fmt.Println(ValidateDatabaseConnectionStringWithCredentials("postgresql://user:password@localhost:5432/mydb")) // true

Test Cases

When to use this pattern

This pattern is drawn from the Security > Secrets & Config category and carries a ReDoS-safe certification. That matters for Go developers because Go's RE2 engine is inherently safe from catastrophic backtracking, but this pattern has been additionally verified for correctness. RegexVault audits patterns against known backtracking attack vectors, ensuring you have the necessary context before using this regex in a high-stakes production environment.

Common Pitfalls

Technical Notes

Capture groups: 1=scheme, 2=username, 3=password, 4=host:port, 5=database, 6=query params. Passwords may be URL-encoded (e.g., P%40ssw0rd). Extract and rotate any credentials found in this format in code or config files.