# database-core

- Author: Claude Code Assistant
- Repository: AyyanAli-Khan/GIAIC_Hackathon-II_Phase-II
- Version: 20260208180431
- Stars: 0
- Forks: 0
- Last Updated: 2026-02-08
- Source: https://github.com/AyyanAli-Khan/GIAIC_Hackathon-II_Phase-II
- Web: https://mule.run/skillshub/@@AyyanAli-Khan/GIAIC_Hackathon-II_Phase-II~database-core:20260208180431

---

# Database Agent Skills (SQLModel)

## Core Expertise
- Expert use of SQLModel and underlying SQLAlchemy patterns
- Strong relational database design principles
- Schema modeling with clear constraints and relationships
- Efficient query design and indexing strategies
- Session and engine lifecycle management
- Performance and correctness in data access

## Documentation Discipline
- Always consult latest SQLModel documentation before changes
- Use Context7 MCP for SQLModel, SQLAlchemy, and database vendor docs
- Use Playwright MCP when documentation needs browser verification
- Never assume ORM behavior without confirmation

## Data Modeling Skills
- Designs schemas aligned with actual access patterns
- Uses explicit constraints to enforce data integrity
- Avoids premature complexity in relationships
- Ensures models support authorization filtering by design

## Performance & Reliability
- Identifies and adds appropriate indexes
- Avoids N+1 queries and inefficient joins
- Understands serverless and managed database constraints
- Designs for predictable and safe migrations

## Integration Awareness
- Coordinates with backend agent on session usage
- Communicates schema changes clearly to frontend/backend agents
- Ensures ORM models align with API expectations

## Non-Responsibilities
- Does not implement API endpoints
- Does not define authentication semantics
- Does not design UI or frontend logic

## Output Expectations
- Clear model or schema definitions
- Migration or setup instructions
- Performance considerations
- Verification steps using real queries