skills.rest
ACubero
ACuberoCOMMUNITY
Explore all skills by this author →
Website𝕏@acuberoaGitHub

database-expert

Define SQLAlchemy models, manage connections, and run Alembic migrations.

Updated Feb 25, 2026
Search Tags:#database#migrations#sql#orm#sqlalchemy#alembic
One-click install
npx skills add https://github.com/ACubero/IA_AGENT_esqueleto_proyectos_python_antigravity --skill database-expert-acubero
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/ACubero/IA_AGENT_esqueleto_proyectos_python_antigravity/tree/main/.agent/skills/database_expert
Command: npx skills add https://github.com/ACubero/IA_AGENT_esqueleto_proyectos_python_antigravity --skill database-expert-acubero

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlalchemy[asyncio], alembic, psycopg2-binary, asyncpg, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of interacting with databases in Python, from defining schemas and managing migrations to optimizing queries, reducing boilerplate and potential errors.

Core Features & Use Cases

  • Schema Definition: Define database models using SQLAlchemy 2.0 with modern type hints.
  • Database Connection: Establish and manage database connections efficiently.
  • Migrations: Handle database schema evolution with Alembic.
  • Query Optimization: Implement strategies like eager loading and bulk inserts to improve performance.
  • Use Case: Set up a new project's database schema, configure the connection, and manage initial migrations.

Quick Start

Use the database-expert skill to create a new user table using SQLAlchemy models and Alembic migrations.

Frequently Asked Questions about database-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define database models using SQLAlchemy 2.0 with modern type hints?▼

You can define database models in SQLAlchemy 2.0 by declaring tables with modern type hints. This approach validates schemas at development time and reduces potential runtime errors.

What is the best way to manage database migrations with Alembic?▼

Database schema evolution is managed with Alembic by generating migration scripts from SQLAlchemy models. This tracks incremental schema changes and handles database versioning automatically.

How do I optimize SQL queries in Python to improve application performance?▼

SQL query optimization in Python is achieved by implementing eager loading strategies and bulk inserts. These techniques minimize database round-trips and significantly improve application performance.

Does this database interaction approach support asynchronous connection management?▼

Yes, asynchronous database connection management is supported through specific asyncio dependencies. This allows you to establish and manage database connections efficiently for scalable Python applications.

What's the best way to set up a new project's database schema with SQLAlchemy and Alembic?▼

Setting up a new project's database schema involves defining SQLAlchemy models, configuring the connection, and generating initial Alembic migrations. This streamlines the process from schema creation to version control.

Related Skills

Explore More Software Engineering Skills→
SoljournerSoljourner
45

get-available-resources

Enumerate installed Python packages, databases, and software tools with versions and connectivity.

Community
Basic
ayiaayia

database-manager

Manage NutriProfile's PostgreSQL database with async SQLAlchemy and Alembic migrations.

Community
Advanced
doanchienthangdevdoanchienthangdev
4

building-fastapi-apis

Develop FastAPI applications with async programming, Pydantic v2, and SQLAlchemy.

Community
Intermediate
oornneryoornnery

sqlmodel

Coordinate SQLModel persistence with async sessions, relationships, and Alembic migrations.

Community
Advanced