Uri Safe Encoding For Database Connection Strings

---
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