majiayu000 Backend Models
This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to SQLAlchemy and Pydantic models in the stock_picker_bot backend.
When to use this skill
Use this skill when:
- Creating SQLAlchemy ORM models in
app/models/for stocks, portfolios, and historical data - Defining Pydantic request/response schemas for API endpoints
- Implementing relationships between models (portfolios to stocks, users to portfolios)
- Adding database fields for yfinance data storage (prices, volumes, technical indicators)
- Creating validators on Pydantic models for stock symbols, price ranges, and date fields
- Defining SQLAlchemy column types and constraints for financial data accuracy
- Building models to store LLM analysis results and recommendations from Claude or Gemini
- Implementing computed properties or methods on models for portfolio calculations
Instructions
For details, refer to the information provided in this file: backend models