Sqlalchemy Code Review
A focused reviewer for SQLAlchemy codebases that enforces 2.0 patterns and catches the usual suspects: session leaks, N+1 queries from lazy loading, missing context managers, and non-reversible Alembic migrations. It gates every finding with file-and-line anchoring before shipping, so you won't get vague complaints about relationship configurations. The checklist covers async sessions, bulk operations, and data migration antipatterns. Best used during pull requests touching ORM models or migration files. It won't teach you SQLAlchemy from scratch, but if you already know what joinedload and sessionmaker do, this keeps your reviews consistent and stops the same issues from slipping through.
- skills.sh installs
- 225
- GitHub stars
- 87
- last updated
- Aug 21, 2026
Install
$ npx -y skills add existential-birds/beagle --skill sqlalchemy-code-review --agent claude-codeInstalls into .claude/skills of the current project.
Files
SQLAlchemy Code Review
Quick Reference
| Issue Type | Reference |
|---|---|
| Session lifecycle, context managers, async sessions | references/sessions.md |
| relationship(), lazy loading, N+1, joinedload | references/relationships.md |
| select() vs query(), ORM overhead, bulk ops | references/queries.md |
| Alembic patterns, reversible migrations, data migrations | references/migrations.md |
Review Checklist
Sponsors
Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthly
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any language
Agent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/existential-birds/beagle
- Categories
- Git & Pull Requests, Code Review & Quality, Python, Databases
- First seen
- Jun 3, 2026
More from existential-birds/beagle
All 40- Pydantic Ai Common Pitfalls221
- Pydantic Ai Agent Creation219
- Agent Architecture Analysis217
- Ai Elements209
- Go Code Review204
- Shadcn Code Review204
- Swift Testing Code Review194
- Sqlite Vec171
- Pydantic Ai Tool System161
- Deepagents Architecture160
- Langgraph Implementation160
- Pydantic Ai Testing146
- Pydantic Ai Dependency Injection141
- Deepagents Implementation140
- Deepagents Code Review132
- Github Projects120
- Pydantic Ai Model Integration120
- React Flow1.3K
- Python Code Review928
- Langgraph Code Review887
- Tailwind V4817
- React Flow Advanced643
- React Router V7577
- React Flow Architecture536
Recommended
More Git & Pull Requests1
pr-specialistmanojbajaj95/claude-gtm-pluginExpert PR and media relations guidance for earned media, press coverage, and reputation building. Use when writing press releases, crafting media pitches, devel225skills.sh installs
pr-specialistmanojbajaj95/claude-gtm-pluginExpert PR and media relations guidance for earned media, press coverage, and reputation building. Use when writing press releases, crafting media pitches, devel225skills.sh installs2
github-clihairyf/skillsGitHub CLI (gh) reference for repositories, issues, pull requests, Actions, projects, releases, gists, codespaces, and GitHub operations from the command line.212skills.sh installs
github-clihairyf/skillsGitHub CLI (gh) reference for repositories, issues, pull requests, Actions, projects, releases, gists, codespaces, and GitHub operations from the command line.212skills.sh installs3
github-a11y-scannercommunity-access/accessibility-agentsIntegrate GitHub Accessibility Scanner. Detects configuration, parses scanner issues, correlates with local scans, and tracks Copilot-assigned fixes.207skills.sh installs
github-a11y-scannercommunity-access/accessibility-agentsIntegrate GitHub Accessibility Scanner. Detects configuration, parses scanner issues, correlates with local scans, and tracks Copilot-assigned fixes.207skills.sh installs4
github-actions-creatordavila7/claude-code-templatesUse when the user wants to create, generate, or set up a GitHub Actions workflow. Handles CI/CD pipelines, testing, deployment, linting, security scanning, rele203skills.sh installs
github-actions-creatordavila7/claude-code-templatesUse when the user wants to create, generate, or set up a GitHub Actions workflow. Handles CI/CD pipelines, testing, deployment, linting, security scanning, rele203skills.sh installs5
comm-lit-review-claude-singlewanshuiyin/auto-claude-code-research-in-sleepCommunications-domain literature review with Claude-style knowledge-base-first retrieval. Use when the task is about communications, wireless, networking, satel200skills.sh installs
comm-lit-review-claude-singlewanshuiyin/auto-claude-code-research-in-sleepCommunications-domain literature review with Claude-style knowledge-base-first retrieval. Use when the task is about communications, wireless, networking, satel200skills.sh installs6
swift-testing-code-reviewexistential-birds/beagleReviews Swift Testing code for proper use of194skills.sh installs
swift-testing-code-reviewexistential-birds/beagleReviews Swift Testing code for proper use of194skills.sh installs