# database-operations

> Instructions on how to write database queries with SQLAlchemy.

- Author: Lukin
- Repository: aiskillstore/marketplace
- Version: 20260122205935
- Stars: 177
- Forks: 0
- Last Updated: 2026-02-06
- Source: https://github.com/aiskillstore/marketplace
- Web: https://mule.run/skillshub/@@aiskillstore/marketplace~database-operations:20260122205935

---

---
name: database-operations
description: Instructions on how to write database queries with SQLAlchemy.
---
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