Sea orm

Skill pedromneto97/custom-skills/skills/sea-orm

List of custom agent skills

Install

npx -y skills add pedromneto97/custom-skills --skill sea-orm

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

SeaORM v2 (open-source, Postgres/MySQL/SQLite) and SeaORM-X (commercial MSSQL) patterns for Rust backends. Use when: adding SeaORM to a project, writing migrations, generating entities, performing CRUD (insert, select, update, delete), paginating results, loading relations, handling on-conflict, using the v2 `#[sea_orm::model]` macro, COLUMN constants, find_by_*, Entity Loader, or MSSQL OUTPUT/IDENTITY_INSERT/savepoint features.

SKILL.md

3.0 KB, as published. Nobody here has run it

SeaORM v2 — Skill Index

Covers sea-orm 2.0.0-rc (open-source) and SeaORM-X (MSSQL commercial). Load only the reference file(s) relevant to the task. Do not load all files at once.

Reference files

Topic	File
`Cargo.toml` dependencies, feature flags, workspace setup	`reference/01-cargo-setup.md`
`Database::connect`, `ConnectOptions`, pool, ping	`reference/02-connection.md`
Migrations — CLI, file layout, `MigratorTrait`, DDL helpers, raw SQL, seed data	`reference/03-migrations.md`
Entity structure — dense vs compact, attributes, CLI codegen, Rust↔DB type map	`reference/04-entity-structure.md`
CRUD Insert — insert one/many, `exec_with_returning`, on-conflict, IDENTITY_INSERT	`reference/05-crud-insert.md`
CRUD Select — find, filter, COLUMN constants, relations, pagination, partial model	`reference/06-crud-select.md`
CRUD Update & Delete — update one/many, delete one/many, `exec_with_returning`	`reference/07-crud-update-delete.md`
MSSQL-specific — savepoints, IDENTITY_INSERT, OUTPUT, schema rewrite, tuple IN	`reference/08-mssql-features.md`
v1 → v2 breaking changes	`reference/09-v1-v2-migration.md`
Repository boundary patterns — mappers, transactions, infra→domain error mapping	`reference/10-repository-patterns.md`

Quick decision guide

Starting a new project? → load 01-cargo-setup.md + 02-connection.md + 03-migrations.md
Defining entities? → load 04-entity-structure.md
Writing queries? → load the relevant CRUD file(s): 05, 06, or 07
Implementing repositories? → load 10-repository-patterns.md (+ relevant CRUD file)
Using MSSQL / SeaORM-X? → always also load 08-mssql-features.md
Upgrading from v1? → load 09-v1-v2-migration.md

Key v2 concepts (quick reference)

Use #[sea_orm::model] (dense format) to unlock COLUMN constants, auto find_by_*/delete_by_*, ModelEx, and Entity Loader.
exec_with_returning is supported on INSERT, UPDATE, and DELETE for Postgres, SQLite, and MSSQL.
M-N load_many no longer requires a junction entity in v2.
MSSQL IDENTITY_INSERT is handled automatically by SeaORM-X when a PK column is Set(...).
currentSchema in the MSSQL connection string auto-prefixes all queries — no explicit schema annotations needed.