sqlobjects
A modern, Django-style async ORM library built on SQLAlchemy Core with chainable queries, Q objects, and relationship loading
Install / Use
npx skills add XtraVisionsAI/sqlobjectsInstalls into whichever agent you are using.
Amazon Q Rules
Amazon Q Developer rules
Quality Score
Category
AutomationSupported Platforms
Skill content
View source on GitHubDevelopment Workflow and Methodology
Design-First Principle
CRITICAL: Any code modification must begin with text-based design analysis.
New Feature Implementation Process
-
Requirements Analysis
- Define the problem clearly and completely
- Identify user needs and use cases
- Determine success criteria and constraints
-
Design Phase
- List multiple solution approaches with pros/cons
- Detail key technical implementation points
- Specify API design and integration points
- Assess impact on existing code and users
-
Implementation Planning
- Break down work into logical steps
- Identify dependencies and prerequisites
- Plan testing strategy and validation approach
-
Code Implementation
- Follow the planned approach
- Implement with tests and documentation
- Validate against design requirements
Architecture Iteration Process
-
Current State Analysis
- Document existing architecture and limitations
- Identify specific problems and pain points
- Analyze performance and maintainability issues
-
Problem Identification
- Root cause analysis of architectural issues
- Impact assessment on users and development
- Priority ranking of problems to solve
-
Solution Design
- Multiple architectural approaches with trade-offs
- Migration strategy and backward compatibility plan
- Risk assessment and mitigation strategies
-
Migration Planning
- Step-by-step migration approach
- Rollback strategies and safety measures
- Timeline and resource requirements
Bug Fix Process
-
Problem Reproduction
- Create minimal reproduction case
- Document expected vs actual behavior
- Identify affected components and versions
-
Root Cause Analysis
- Trace the issue to its source
- Understand why the problem occurred
- Assess scope and potential side effects
-
Fix Strategy Design
- Design the minimal fix approach
- Consider alternative solutions
- Plan for regression prevention
-
Testing Plan
- Unit tests for the specific issue
- Integration tests for affected workflows
- Regression tests to prevent recurrence
Design Documentation Requirements
Problem Description
- Clear statement of what needs to be solved
- Context and background information
- Constraints and requirements
Solution Analysis
- Multiple approaches considered
- Pros and cons of each approach
- Recommended solution with justification
Implementation Details
- Key technical decisions and rationale
- API design and interface specifications
- Integration points and dependencies
Impact Assessment
- Changes to existing APIs or behavior
- Migration requirements for users
- Performance and compatibility implications
Validation Strategy
- How to verify the solution works
- Test cases and scenarios
- Success metrics and acceptance criteria
Code Modification Workflow
Phase 1: Text Design
- Analysis: Problem understanding and solution exploration
- Design: Detailed technical approach and specifications
- Review: Design validation and feedback incorporation
Phase 2: Implementation Preparation
- Planning: Task breakdown and dependency mapping
- Environment: Development setup and tool preparation
- Dependencies: Required libraries and infrastructure
Phase 3: Code Implementation
- Coding: Following the designed approach
- Testing: Unit and integration test implementation
- Documentation: Code comments and user documentation
Phase 4: Validation and Release
- Integration: Merge with existing codebase
- Verification: End-to-end testing and validation
- Deployment: Release preparation and rollout
Quality Gates
Design Review Checklist
- [ ] Problem clearly defined and understood
- [ ] Multiple solutions considered
- [ ] Implementation approach detailed
- [ ] Impact assessment completed
- [ ] Testing strategy defined
Implementation Review Checklist
- [ ] Code follows design specifications
- [ ] Tests cover all scenarios
- [ ] Documentation updated
- [ ] Backward compatibility maintained
- [ ] Performance impact assessed
Release Readiness Checklist
- [ ] All tests passing
- [ ] Documentation complete
- [ ] Migration guide provided (if needed)
- [ ] Rollback plan available
- [ ] Monitoring and alerting configured
Related Skills
claude-mem
94.4kPersistent Context Across Sessions for Every Agent – Captures everything your agent does during sessions, compresses it with AI, and injects relevant context back into future sessions. Works with Claude Code, OpenClaw, Codex, Gemini, Hermes, Copilot, OpenCode + More
Agent-Reach
84.4kGive your AI agent eyes to see the entire internet. Read & search Twitter, Reddit, YouTube, GitHub, Bilibili, XiaoHongShu — one CLI, zero API fees.
ruflo
73.0k🌊 The original agent harness. Deploy intelligent multi-player swarms, coordinate autonomous workflows, and build conversational AI systems. Features adaptive memory, self-learning intelligence, federation, vector RAG integration, and native Claude Code / Codex / Hermes and many more Integrated
nanobot
48.5kUltra-lightweight, open-source, self-hosted personal AI agent framework in Python with WebUI, tools, memory, MCP, multi-agent workflows, automation, and chat apps
Security Score
Audited on Invalid Date
