Agent skill
Backend Queries
SQLAlchemy query optimization and data retrieval for stock_picker_bot. Covers efficient querying of historical stock data, portfolio lookups, and stock market analytics.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/backend-queries-adigunners-stock-picker-bot
SKILL.md
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
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?