Provide SQLAlchemy patterns for safe database operations in Python.
npx skills add https://github.com/cathayrisk/Anya --skill sql-and-database-cathayrisk
Please help me install this Agent Skill. Skill: sql-and-database Source: https://github.com/cathayrisk/Anya/tree/main/skills/sql-and-database Command: npx skills add https://github.com/cathayrisk/Anya --skill sql-and-database-cathayrisk
Many Python projects mishandle database interactions, causing connection leaks, SQL injection risks, inefficient queries, and brittle migrations; this skill consolidates best practices for safe, predictable database access and ORM usage so developers can read and write data reliably.
Create a single Engine with get_engine(), use with Session() context managers, and execute parameterized queries to fetch or persist user data safely.
High-intent search queries and answers about installing and using this skill.
Prevent SQL injection in Python raw SQL queries by using parameterized queries with bound parameters instead of string interpolation. This skill provides secure execution patterns that separate query structure from user-supplied data to block injection attacks.
Manage SQLAlchemy sessions and connection pooling by creating a single Engine via get_engine() and using Session() context managers. This skill demonstrates singleton engine patterns and session commit semantics to prevent connection leaks and ensure predictable transactions.
Avoid N+1 query problems in SQLAlchemy ORM mappings by applying eager loading strategies and proper relationship handling. This skill covers common pitfalls like N+1 queries, expire_on_commit implications, and thread-safety considerations with mitigation patterns.
Use pandas DataFrames for bulk inserts and reads with PostgreSQL, SQLite, or MySQL databases. This skill provides pandas-to-database workflow patterns for efficient bulk data operations and query result ingestion directly into DataFrame structures.
Async SQLAlchemy supports AsyncSession for non-blocking database operations in Python applications. This skill provides async database access patterns using async drivers and AsyncSession to handle concurrent queries without blocking the event loop.
Alembic is needed for database migrations in production to manage schema changes safely and track version history. This skill recommends using Alembic for production migrations rather than raw SQL scripts to ensure reliable, reversible schema evolution.
CodingHeaderAutomate Python database patterns with SQLAlchemy ORM, async sessions, and Alembic migrations.
HeldinhowManage database schema changes through version-controlled migration scripts.
shredbxImplement asynchronous Python applications with asyncio for non-blocking I/O.
7a336e6eGenerate SQLAlchemy ORM models and repository patterns with session management.
