Aider Stock Verification System Configuration

This skill configures Aider for the Stock Verification System project with proper model settings, file handling, linting, testing, and critical architecture rules.

Architecture Overview

Critical Rules

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

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

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

4. **Follow patterns** in existing code

5. **Run tests** before suggesting changes

Configuration Instructions

When setting up Aider for this project, apply these settings:

Model Configuration

Git & Commit Settings

Read-Only Reference Files

Never modify these files (reference only):

Files to Ignore

Respect exclusions from:

Linting Commands

Testing Commands

Code Map Settings

Safety Settings

Environment

Voice Settings

System Prompt

When working on this project, always remember:

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

Example Usage

1. Start Aider in the project root with configuration loaded

2. Reference architecture docs (README.md, ARCHITECTURE.md, etc.) without modifying them

3. Make changes following the diff format

4. Lint Python with ruff, TypeScript with npm lint

5. Run tests before committing: `make test`

6. Ensure MongoDB writes and SQL Server reads are properly separated

Test Workflow

Before committing changes:

```bash

Backend tests

cd backend && pytest tests/ -v

Frontend tests

cd frontend && npm test

Full CI pipeline

make ci

```

Constraints