Notre avis

Ce guide définit un schéma de base de données robuste, type-safe et asynchrone pour une application Todo avec SQLModel, optimisé pour PostgreSQL et compatible avec Better Auth.

Points forts

Définition claire des modèles User et Task avec relations
Indexation stratégique pour améliorer les performances des requêtes
Gestion automatique des timestamps
Alignement sur les meilleures pratiques SQLModel pour la production

Limites

Ne couvre pas les migrations ou le seed de base de données
Les modèles sont spécifiques à une application Todo et peuvent nécessiter des ajustements pour d'autres domaines
Dépend de SQLModel et de ses mises à jour

Quand l'utiliser

Lorsque vous démarrez une application Todo avec SQLModel et PostgreSQL, et que vous voulez une base solide pour le CRUD des tâches liées aux utilisateurs.

Quand l'éviter

Si vous utilisez un ORM différent (Django ORM, SQLAlchemy sans SQLModel) ou si vous n'avez pas besoin de modèles relationnels complexes.

Exemples

Create SQLModel task schema

Define SQLModel models for a Todo app with User and Task tables, ensuring user_id foreign key, indexes on user_id and completed, and automatic timestamps. Compatible with Better Auth.

Add task model to existing project

I have a SQLModel project with User model already defined. Add a Task model with fields: title, description, completed, and a relationship to User. Include created_at and updated_at.

Optimize SQLModel schema for PostgreSQL

Write SQLModel models for a Todo app optimized for PostgreSQL. Use proper indexing, default values, and datetime.utcnow. Ensure compatibility with Better Auth user IDs as strings.

name: sqlmodel-task-models description: This skill should be used when defining a robust, type-safe, and async-compatible database schema for the Todo application using SQLModel, ensuring compatibility with Better Auth and optimized for PostgreSQL.

SQLModel Task Models

This skill providing guidance on defining a robust database schema using SQLModel for the Todo application.

Purpose

Defining a robust, type-safe, and async-compatible database schema for the Todo application using SQLModel, ensuring compatibility with Better Auth and optimized for PostgreSQL.

Capabilities

User Model: Schema aligned with Better Auth requirements.
Task Model: Full CRUD capability with relational mapping to Users.
Relational Integrity: Proper foreign key constraints and back-references.
Performance: Strategic indexing on user_id and completed fields.
Safety: Automated timestamp management (created_at, updated_at).

Implementation Details

Models Definition

from sqlmodel import SQLModel, Field, Relationship
from typing import List, Optional
from datetime import datetime

class User(SQLModel, table=True):
    id: str = Field(primary_key=True)
    email: str = Field(unique=True, index=True)
    name: Optional[str] = None
    created_at: datetime = Field(default_factory=datetime.utcnow)
    tasks: List["Task"] = Relationship(back_populates="user")

class Task(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    user_id: str = Field(foreign_key="user.id", index=True)
    title: str
    description: Optional[str] = None
    completed: bool = Field(default=False, index=True)
    created_at: datetime = Field(default_factory=datetime.utcnow)
    updated_at: datetime = Field(default_factory=datetime.utcnow)
    user: Optional[User] = Relationship(back_populates="tasks")

Best Practices

Using table=True for models that map to database tables.
Explicitly defining indexes for fields used in WHERE clauses (e.g., user_id, completed).
Using datetime.utcnow for consistent cross-region timestamping.
Keeping user_id as a string to match Better Auth's UUID/ID format.

Modèles SQLModel pour Tâches

Recommandé pour

Notre avis

Points forts

Limites

Analyse de sécurité

Exemples

name: sqlmodel-task-models description: This skill should be used when defining a robust, type-safe, and async-compatible database schema for the Todo application using SQLModel, ensuring compatibility with Better Auth and optimized for PostgreSQL.

SQLModel Task Models

Purpose

Capabilities

Implementation Details

Models Definition

Best Practices

Expert Next.js App Router

Générateur de README

Rédacteur de Documentation API