majiayu000 Backend Queries
This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to SQLAlchemy queries in the stock_picker_bot backend.
When to use this skill
Use this skill when:
- Writing SQLAlchemy queries to retrieve stock data from aiosqlite database
- Implementing efficient queries for portfolio data with relationships and filters
- Fetching historical stock prices for technical analysis and trend calculations
- Joining stock tables with portfolio associations and user watchlists
- Implementing pagination for large result sets in stock data endpoints
- Optimizing queries with eager loading or joins to reduce database round trips
- Filtering stocks by criteria like market cap, price range, or performance metrics
- Aggregating stock data for portfolio performance calculations or comparisons
Instructions
For details, refer to the information provided in this file: backend queries