yweb-orm

Documents YWeb ORM usage including models, CRUD, queries, pagination, soft deletion, transactions.

3|2|Updated Feb 22, 2026
One-click install
npx skills add https://github.com/yafo-ai/yweb-core --skill yweb-orm
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: yweb-orm
Source: https://github.com/yafo-ai/yweb-core/tree/main/.cursor/skills/yweb-orm
Command: npx skills add https://github.com/yafo-ai/yweb-core --skill yweb-orm

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexity and boilerplate code often associated with database interactions in web applications, providing a streamlined and efficient ORM solution.

Core Features & Use Cases

  • Active Record Pattern: Simplifies CRUD operations by allowing model instances to perform database actions directly.
  • Automated Field Management: Automatically includes common fields like id, name, timestamps, and soft-delete flags.
  • Efficient Querying: Supports chainable queries, pagination, and bulk operations.
  • Transaction Management: Integrates with decorators for robust transaction handling.
  • Use Case: When defining new database models or performing standard create, read, update, or delete operations, this Skill ensures adherence to YWeb's ORM best practices and leverages its powerful features.

Quick Start

Refer to the YWeb ORM documentation for detailed usage of models, queries, and transactions.

Frequently Asked Questions about yweb-orm

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I perform CRUD operations using the Active Record pattern in SQLAlchemy?

CRUD operations using the Active Record pattern let model instances execute database actions directly. The YWeb ORM simplifies this by allowing instances to save or delete themselves, reducing boilerplate code for standard database interactions within the YWeb framework.

What is the best way to manage database transactions with decorators in a web framework?

Database transaction management with decorators provides robust handling by wrapping functions in automated transactional blocks. The YWeb ORM integrates decorators to ensure atomic operations, committing or rolling back database transactions automatically based on function execution success.

How does soft deletion work when defining database models?

Soft deletion in database models works by automatically including soft-delete flags to mark records as inactive without permanently removing them. The YWeb ORM automates this field management, ensuring queries filter out soft-deleted entries by default while preserving data integrity.

Can I use SQLAlchemy 2.0 style querying for pagination and bulk operations?

SQLAlchemy 2.0 style querying fully supports chainable queries, pagination, and bulk operations. The YWeb ORM is built on this modern standard, providing best practices for efficient database interaction and automated field management like timestamps and IDs.

Does the YWeb ORM require manual setup for common fields like id and timestamps?

The YWeb ORM does not require manual setup for common fields. It features automated field management that automatically includes standard fields like id, name, timestamps, and soft-delete flags when defining new database models, streamlining the development process.