postgresql-sqlmodel

What problem does it solve?

This Skill provides comprehensive guidance and practical examples for interacting with PostgreSQL databases using SQLModel, an ORM that simplifies Python database operations.

Core Features & Use Cases

• Database Connection: Establish both synchronous and asynchronous connections to PostgreSQL, including Neon.
• Model Definition: Define database tables and Pydantic-compatible models using SQLModel.
• CRUD Operations: Implement Create, Read, Update, and Delete operations efficiently.
• Relationships: Manage one-to-many and many-to-many relationships between models.
• Migrations: Set up and manage database schema changes with Alembic.
• PostgreSQL Features: Utilize specific PostgreSQL data types and raw SQL commands.
• Optimization: Learn strategies for query optimization and connection pooling.
• Use Case: Develop a robust backend API for a web application, ensuring data integrity, efficient querying, and seamless database management.

Quick Start

Use the postgresql-sqlmodel skill to create a new user table with email and username fields in your PostgreSQL database.