How does this skill support authentication?

The skill configures User models to align with Better Auth's specific field requirements, including string-based IDs and indexed email fields for fast lookups.

Is the schema optimized for performance?

Yes, it implements strategic indexing on foreign keys and frequently filtered fields like 'completed' status to ensure efficient execution in PostgreSQL.

Does it handle data relationships?

Absolutely. It defines proper foreign key constraints and use SQLModel's Relationship attribute for back-populated mappings between users and their tasks.

SQLModel is a library for interacting with SQL databases from Python code, combining SQLAlchemy and Pydantic to provide both database ORM capabilities and data validation.

SQLModel Task Schemas

Name: SQLModel Task Schemas
Author: abdulahad139

byabdulahad139

0•

Database Management

Defines type-safe, production-ready SQLModel schemas for task management applications with integrated Better Auth support.

This skill provides a specialized blueprint for building robust database schemas using SQLModel, specifically optimized for PostgreSQL environments. It handles the complex relationship between users and tasks, ensuring full compatibility with Better Auth systems while implementing best practices like automated timestamping, strategic indexing for performance, and strict type safety. It is an essential tool for developers building modern FastAPI or Python-based backends that require reliable data integrity and efficient query performance for task-tracking features.

Key Features

01Better Auth compatible User models

02Type-safe relational mapping between Users and Tasks

030 GitHub stars

04Optimized PostgreSQL indexing for high-performance queries

05Automated UTC timestamp management

06Async-compatible schema definitions

Use Cases

01Building a multi-user project management application backend

02Integrating Better Auth with a SQLModel and PostgreSQL stack

03Designing relational database schemas with built-in audit trails

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add abdulahad139/hackathon2_phase2 sqlmodel-task-models

For use in Claude.ai and ChatGPT

Download Skill