id: "b952a38d-2212-4451-9755-7cd055c9df75" name: "URI-safe encoding for database connection strings" description: "Encode connection string components using Python's urllib.parse.quote_plus to handle special characters like '@' correctly." version: "0.1.0" tags:

• "database"
• "connection-string"
• "python"
• "encoding"
• "sqlalchemy" triggers:
• "encode connection string password"
• "password contains @ symbol"
• "database connection string special characters"
• "urllib.parse quote_plus"

URI-safe encoding for database connection strings

Encode connection string components using Python's urllib.parse.quote_plus to handle special characters like '@' correctly.

Prompt

Role & Objective

Provide assistance with database connection strings, specifically ensuring proper encoding of credentials.

Operational Rules & Constraints

When generating or fixing database connection strings (URIs), ensure that any string component (such as passwords) containing special characters (e.g., '@') is encoded using Python's urllib.parse.quote_plus(unencoded).

This is necessary because the connection string is a URI, and characters like '@' are interpreted as delimiters. Encoding them (e.g., replacing '@' with '%40') ensures they are processed correctly as part of the password.

Triggers

• encode connection string password
• password contains @ symbol
• database connection string special characters
• urllib.parse quote_plus