Sqlalchemy Orm Patterns
Generate SQLAlchemy ORM code following common patterns like repositories, services, and data transfer objects.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add sqlalchemy-orm-patterns npx -- -y @trustedskills/sqlalchemy-orm-patterns
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"sqlalchemy-orm-patterns": {
"command": "npx",
"args": [
"-y",
"@trustedskills/sqlalchemy-orm-patterns"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill enables AI agents to interact with SQLAlchemy ORM patterns. It facilitates the generation of database queries and manipulations using Python code, allowing for efficient data retrieval and management within a structured environment. The agent can understand and execute requests related to common ORM operations like querying, filtering, and updating records.
When to use it
- Automated Data Extraction: Generate SQL queries from natural language descriptions to extract specific information from a database.
- Database Schema Modification: Create scripts for altering table structures or adding new columns based on user requests.
- Data Migration Tasks: Automate the process of transferring data between different databases using SQLAlchemy ORM patterns.
- Report Generation: Construct queries to retrieve and format data for generating reports.
Key capabilities
- SQLAlchemy ORM interaction
- Query generation from natural language
- Database schema manipulation
- Data migration scripting
Example prompts
- "Generate a SQLAlchemy query to find all users older than 30."
- "Create a script to add a new column 'email' to the 'users' table."
- "Write code to migrate data from the 'legacy_db' database to the 'new_db' database using SQLAlchemy."
Tips & gotchas
- Requires familiarity with SQLAlchemy ORM concepts and Python programming.
- The agent’s understanding of complex SQL queries may be limited; break down requests into smaller, manageable steps for best results.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.