AI Fix Prompts for Counsel Ai

Fix a hardcoded credential in repository 'adityac7__counsel-ai'.

**Issue**: Hard-coded password found (Database URL with Password)
**File**: alembic.ini
**Line**: 4
**Severity**: CRITICAL

**Current code around the issue:**
```
       1 | [alembic]
       2 | script_location = alembic
       3 | prepend_sys_path = src
>>>    4 | sqlalchemy.url = postgresql://counselai:counselai@localhost:5432/counselai
       5 | 
       6 | [loggers]
       7 | keys = root,sqlalchemy,alembic
       8 | 
       9 | [handlers]
```

**Required fix:**
1. Remove the hardcoded credential from the source code
2. Replace it with an environment variable read: `os.environ.get('PASSWORD_KEY')` (Python) or `process.env.PASSWORD_KEY` (JS)
3. Add the variable name to a `.env.example` file with a placeholder value
4. Ensure `.env` is in `.gitignore`
5. If this credential was ever committed to git, it should be considered compromised and rotated

**Do NOT:**
- Move the secret to a config file that gets committed
- Use a default fallback value that is a real credential
- Leave the old credential in a comment

Fix a hardcoded credential in repository 'adityac7__counsel-ai'.

**Issue**: Hard-coded password found (Database URL with Password)
**File**: src/counselai/settings.py
**Line**: 20
**Severity**: CRITICAL

**Current code around the issue:**
```
      15 | 
      16 | class Settings(BaseSettings):
      17 |     """Typed settings for CounselAI — single source of truth."""
      18 | 
      19 |     # ── Database ────────────────────────────────────────────────────────
>>>   20 |     database_url: str = "postgresql://counselai:counselai@localhost:5432/counselai"
      21 | 
      22 |     # ── Artifact storage ────────────────────────────────────────────────
      23 |     artifact_root: str = "artifacts"
      24 | 
      25 |     # ── Provider API keys ───────────────────────────────────────────────
```

**Required fix:**
1. Remove the hardcoded credential from the source code
2. Replace it with an environment variable read: `os.environ.get('PASSWORD_KEY')` (Python) or `process.env.PASSWORD_KEY` (JS)
3. Add the variable name to a `.env.example` file with a placeholder value
4. Ensure `.env` is in `.gitignore`
5. If this credential was ever committed to git, it should be considered compromised and rotated

**Do NOT:**
- Move the secret to a config file that gets committed
- Use a default fallback value that is a real credential
- Leave the old credential in a comment

Address OWASP A02 (Cryptographic Failures) compliance gap in 'adityac7__counsel-ai'.

**OWASP Category**: A02 -- Cryptographic Failures
**Fix guidance**: Remove hardcoded secrets, use strong encryption (AES-256-GCM), enforce TLS, never store passwords in plaintext (use bcrypt/argon2).

**Steps:**
1. Identify all code paths related to cryptographic failures
2. Apply the fixes described above
3. Add automated tests to verify the fix
4. Document any security assumptions in code comments

Address OWASP A07 (Auth Failures) compliance gap in 'adityac7__counsel-ai'.

**OWASP Category**: A07 -- Auth Failures
**Fix guidance**: Implement proper session management, use MFA where possible, enforce strong passwords, protect against brute force.

**Steps:**
1. Identify all code paths related to auth failures
2. Apply the fixes described above
3. Add automated tests to verify the fix
4. Document any security assumptions in code comments

Repository 'adityac7__counsel-ai' is failing the quality gate.

Failed conditions:
- overall_score: actual 0.0 >= 50 (FAILED)
- security_score: actual 0.0 >= 40 (FAILED)
- critical_credentials: actual 2.0 <= 0 (FAILED)

Fix each failing condition to make the repo pass the quality gate.

Repository 'adityac7__counsel-ai' has 2 open issues:

- [CRITICAL] Hard-coded password: Database URL with Password (alembic.ini)
- [CRITICAL] Hard-coded password: Database URL with Password (src/counselai/settings.py)

Resolve each issue. For security issues, apply the appropriate fix. For quality issues, refactor the affected code.