Aider Config: Stock Verification System

Configure aider for a dual-database Stock Verification System with strict read-only SQL Server rules, MongoDB writes, JWT authentication, and automated testing.

What This Skill Does

Sets up aider with:

Instructions

1. Create Base Configuration File

Create `.aider.conf.yml` in the project root with:

```yaml

Model Configuration

model: claude-sonnet-4-20250514

edit-format: diff

weak-model: claude-sonnet-4-20250514

Context Configuration

auto-commits: false

dirty-commits: false

attribute-author: true

attribute-committer: true

attribute-commit-message-author: true

attribute-commit-message-committer: true

Read-only files (reference only, never modify)

read:

- README.md

- ARCHITECTURE.md

- API_CONTRACTS.md

- API_REFERENCE.md

- .cursorrules

- .github/copilot-instructions.md

Files to exclude from context

ignore-file:

- .gitignore

- .aiderignore

Safety settings

suggest-shell-commands: true

show-diffs: true

check-update: true

Git settings

git: true

gitignore: true

Lint/test commands

lint-cmd:

python: "cd backend && ruff check --fix {fname}"

typescript: "cd frontend && npm run lint -- --fix"

test-cmd: "make test"

Code map settings

map-tokens: 2048

map-refresh: auto

Voice settings (experimental)

voice-language: en

Environment

env-file: .env

```

2. Add Critical System Prompt

Add this system prompt section to enforce architectural rules:

```yaml

system-prompt: |

You are working on the Stock Verification System.

CRITICAL RULES:

- SQL Server is READ-ONLY. All writes go to MongoDB.

- Use parameterized queries (?) for SQL - never string concatenation.

- JWT auth required for all /api/* endpoints.

- Follow patterns in existing code.

- Run tests before suggesting changes.

ARCHITECTURE:

- Backend: FastAPI (Python 3.10+) on port 8001

- Frontend: React Native + Expo (TypeScript)

- Primary DB: MongoDB (Motor async driver)

- ERP Source: SQL Server (pyodbc, read-only)

TEST COMMANDS:

- Backend: cd backend && pytest tests/ -v

- Frontend: cd frontend && npm test

- Full CI: make ci

```

3. Verify Configuration

After creating the configuration:

1. **Check aider can load config:**

```bash

aider --check-config

```

2. **Verify lint commands work:**

```bash

cd backend && ruff check --fix src/

cd frontend && npm run lint -- --fix

```

3. **Verify test commands work:**

```bash

make test

```

4. Usage Patterns

**Start aider with auto-loaded config:**

```bash

aider

```

**Add specific files to context:**

```bash

aider backend/src/api/auth.py backend/tests/test_auth.py

```

**Reference read-only docs:**

The config automatically includes README.md, ARCHITECTURE.md, API_CONTRACTS.md as read-only context.

**Run tests before committing:**

```bash

aider --test-cmd "make test"

```

Key Rules Enforced

1. **SQL Server Read-Only:** Never generate SQL INSERT/UPDATE/DELETE statements for SQL Server

2. **MongoDB Writes:** All data modifications go through MongoDB Motor async driver

3. **Parameterized Queries:** Always use `?` placeholders, never string concatenation

4. **JWT Authentication:** All `/api/*` endpoints require JWT token validation

5. **Testing First:** Run `make test` before suggesting code changes

6. **Code Patterns:** Follow existing patterns in codebase (check via `read:` files)

Testing Commands

Example Usage

```bash

Start aider with authentication module

aider backend/src/api/auth.py backend/tests/test_auth.py

Aider will automatically:

- Load read-only docs (README.md, ARCHITECTURE.md, etc.)

- Apply system prompt with SQL read-only rules

- Run ruff linting on Python files when saved

- Suggest running make test before committing

```

Important Notes