# Python
__pycache__/
*.pyc
*.pyo
*.pyd
*.so
*.egg-info/
*.egg
*.eggs/
dist/
build/
*.whl
*.tar.gz

# Virtual environments
.venv/
venv/
env/

# Environment variables
.env
.env.*
!.env.example

# DuckDB database files
*.duckdb
*.duckdb.wal

# SQLite and generic database files
*.sqlite
*.sqlite3
*.db
*.db-journal
*.db-wal
*.db-shm

# Type checkers
.mypy_cache/
.pytype/
.pyre/

# Linters and formatters
.ruff_cache/

# Test and coverage
.pytest_cache/
htmlcov/
.coverage
.coverage.*
coverage.xml
report/

# Build system
.hatch/

# IDE
.idea/
.vscode/
*.swp
*.swo
*~

# OS
.DS_Store
Thumbs.db
Desktop.ini

# Log files
*.log
logs/

# Temporary and backup files
*.tmp
*.bak
*.orig

# Generic lock files (uv.lock is tracked, so this only affects new .lock files)
*.lock
!uv.lock

# Python version managers
.python-version
.direnv/

# AI / agent tool configs
.kilo/
.kilocode/
.opencode/
.claude/
.cursor/

# Internal development artifacts
reference_repos/
RECOMMENDATIONS.md
TASKS.md
SPECS.md
CLAUDE.md
AGENTS.md

# Research artifacts
docs/official-docs-analysis.md

# Phase planning documents
PLAN-*.md

# Test output artifacts
test_*.txt
test_output/

# Temporary dev databases
tallybridge.duckdb
tallybridge.duckdb.wal
