# Database Operations

> Instructions on how to write database queries with SQLAlchemy.

- Skill: `comeonoliver/database-operations-2` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add comeonoliver/database-operations-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/comeonoliver/database-operations-2/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ComeOnOliver (https://skillmd.com/u/comeonoliver)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/comeonoliver/database-operations-2

---

When performing database operations using SQLAlchemy, follow these guidelines to ensure efficient and maintainable code:
- Avoid for-loops. Instead always prefer bulk operations using SQLAlchemy's built-in methods or use SQL joins to get related data in a single query.
- Database operations should be contained in repository classes