database-operations
A skill for performing database CRUD operations following best practices. Includes guidance on session management, query building (filters, joins, aggregations), transaction handling, bulk operations, error handling, connection pooling, and query optimization. Provides reusable templates for database session dependencies, CRUD service classes, and transaction context managers.
When & Why to Use This Skill
This Claude skill provides a comprehensive framework for performing database CRUD operations following industry best practices. It offers reusable templates and expert guidance for SQLAlchemy-based development, covering essential aspects such as session management, complex query building, and atomic transaction handling. By implementing a robust data access layer, this skill helps developers ensure data integrity, efficient connection pooling, and high-performance query optimization in Python applications.
Use Cases
- Backend API Development: Implementing a standardized and maintainable CRUD service layer for Python web frameworks like FastAPI, Flask, or Django.
- Complex Data Retrieval: Constructing advanced SQL queries involving multiple joins, filters, and aggregations for reporting and data analysis tasks.
- Ensuring Data Consistency: Utilizing transaction context managers to handle multi-step database operations as atomic units, preventing partial updates and data corruption.
- Performance Tuning: Optimizing database interactions through efficient connection pooling configurations and query refinement to eliminate performance bottlenecks.
| name | database-operations |
|---|---|
| description | A skill for performing database CRUD operations following best practices. Includes guidance on session management, query building (filters, joins, aggregations), transaction handling, bulk operations, error handling, connection pooling, and query optimization. Provides reusable templates for database session dependencies, CRUD service classes, and transaction context managers. |
Database Operations
Overview
This skill provides a set of best practices and reusable templates for common database operations in Python, primarily using SQLAlchemy. It is designed to help you build robust, efficient, and maintainable data access layers.
This skill follows the "Progressive Disclosure" design principle. This main file provides a high-level overview, and the references/ directory contains detailed documentation and code examples for each topic.
Core Concepts & Reference Guides
Session Management: Learn how to manage database sessions effectively, including a dependency injection pattern for web frameworks.
CRUD Service Layer: A generic base class for creating, reading, updating, and deleting records. This promotes code reuse and a consistent API for data access.
Transaction Handling: A context manager to ensure that a series of operations are treated as a single, atomic unit of work.
Querying Techniques: Examples of how to build more complex queries, including filtering, joins, aggregations, and high-performance bulk operations.
Advanced Topics: Guidance on handling common database errors, configuring the connection pool, and essential query optimization techniques to avoid performance bottlenecks.