Build SQLModel CRUD Layers
Designing SQLModel models and CRUD code can be slow when relationships and async sessions are involved. This skill guides Claude, Codex, and Claude Code through models, queries, relationships, and database setup.
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "sqlmodel-crud" from https://skillstore.io/skills/awais68-sqlmodel-crud.md and its manifest at https://skillstore.io/api/skills/awais68-sqlmodel-crud/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.Your Agent should still show its plan and request any confirmation required by the security policy.
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Using "sqlmodel-crud". Request: create Student and Class SQLModel models.
Expected outcome:
Using "sqlmodel-crud". Request: build CRUD methods for Fee records.
Expected outcome:
Using "sqlmodel-crud". Request: design attendance reporting queries.
Expected outcome:
The skill returns a query plan covering date filters, joins, aggregation metrics, eager loading, and pagination considerations.
AI review found the static command, network, environment, and reconnaissance hits are documentation or example false positives. The file contains SQLModel snippets, SQLAlchemy query examples, normal DATABASE_URL configuration, and reference links, with no prompt injection or data-exfiltration intent.
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
https://skillstore.io/skills/awais68-sqlmodel-crud/audits/8?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report[](https://skillstore.io/skills/awais68-sqlmodel-crud?utm_source=security_passport_badge)<a href="https://skillstore.io/skills/awais68-sqlmodel-crud?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/awais68-sqlmodel-crud/security.svg" alt="Skillstore security assessment" loading="lazy"></a><iframe src="https://skillstore.io/embed/skills/awais68-sqlmodel-crud.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Awais68. (2026). sqlmodel-crud security audit report (audit version 8) [Author version unspecified]. Skillstore. https://skillstore.io/skills/awais68-sqlmodel-crud/audits/8@techreport{awais68-awais68-sqlmodel-crud-2026,
author = {Awais68},
title = {sqlmodel-crud security audit report (audit version 8)},
institution = {Skillstore},
year = {2026},
number = {8},
url = {https://skillstore.io/skills/awais68-sqlmodel-crud/audits/8},
note = {Author version unspecified}
}cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "sqlmodel-crud security audit report (audit version 8)"
version: "unspecified"
type: report
authors:
- name: "Awais68"
date-released: "2026-07-06"
url: "https://skillstore.io/skills/awais68-sqlmodel-crud/audits/8"
identifiers:
- type: other
value: "skillstore:awais68-sqlmodel-crud:audit:8"
description: "Skillstore immutable audit report identifier"
Define Student, Fee, Attendance, and Class tables with validators and relationships.
Generate create, read, update, delete, count, and filtered list methods for SQLModel tables.
Draft joined queries, eager loading, search, aggregation, and pagination for reporting screens.
Use this SQLModel CRUD skill. Create a Student model with name, email, phone, timestamps, and validation rules.
Use this skill to write async CRUD methods for my Fee model. Include create, get by id, update, delete, pagination, and transaction handling.
Use this skill to design Student, Parent, Class, Fee, and Attendance relationships. Include one-to-many, many-to-many, indexes, and back_populates choices.
Use this skill to design advanced SQLModel queries for attendance and fee reports. Include joins, aggregations, eager loading, filters, and pagination.
Author
Awais68License
MIT
Skillstore revision
r1
Version notice
The author did not declare a version.
Ref
c4231f0153ccd2a2ed62274c5a372bf8f2386d3f
Maintenance freshness
7/18/2026
Usage
5 downloads · 256 views
File structure
📄 SKILL.md
Build Responsive Tailwind CSS Interfaces
Tailwind projects can become inconsistent across components and breakpoints. This skill guides responsive utility classes, theme setup, dark mode, and accessibility checks.
Build Typed React Components
React component work often needs consistent structure, hooks, tests, stories, and accessibility checks. This skill guides Claude, Codex, and Claude Code toward typed, testable React components.
Build Typed API Clients
API clients need consistent auth, caching, validation, and error handling. This skill guides TanStack Query, Axios, JWT interceptors, Zod parsing, and offline behavior.
Implement Secure Next.js Authentication
Authentication work is easy to under-specify and hard to secure. This skill guides Claude, Codex, and Claude Code through forms, sessions, protected routes, and role checks.
Validate Data with Pydantic and Zod
APIs and forms often drift when validation rules are copied between layers. This skill gives Claude, Codex, and Claude Code practical patterns for shared schemas, clear errors, and safer input handling.
Build FastAPI Backends with Auth and Models
FastAPI projects need consistent structure for routes, schemas, auth, database sessions, and CORS. This skill guides Claude, Codex, and Claude Code to create maintainable backend patterns.
Build FastAPI Backends
by sickn33
FastAPI projects need consistent choices across setup, data models, routes, auth, tests, and deployment. This skill provides a phased workflow with focused prompts for each backend step.
Build Reliable Python Database Layers
by 0xDarkMatter
Python database code can fail through poor session, transaction, or migration patterns. This skill provides practical SQLAlchemy 2.0 patterns for robust applications.
Build Production FastAPI Services
by sickn33
Production FastAPI services require careful async, data, security, testing, and deployment decisions. This skill provides structured guidance for designing and improving modern Python APIs.
Build FastAPI APIs with Reusable Patterns
by 0xDarkMatter
FastAPI projects need consistent choices for validation, dependencies, middleware, and background work. This skill gives Claude, Codex, and Claude Code reusable patterns for practical Python API development.
Build Reliable Backend APIs
by alirezarezvani
Backend projects often need consistent planning across APIs, databases, security, and deployment. This skill gives Claude, Codex, and Claude Code structured backend guidance with simple helper scripts and references.
Master pytest Testing with uv
by AbdullahMalik17
Python teams need consistent pytest workflows for unit tests, FastAPI tests, fixtures, and coverage. This skill gives Claude, Codex, and Claude Code practical commands and patterns for pytest projects that use uv.