sqlalchemy-dev

v2.1.0

SQLAlchemy dev plugin for Agents Store. Typed SQLAlchemy 2.0 style (Mapped, mapped_column, select) with a SQLAlchemy 2.1 section: model definition patterns, relationship mapping, query optimization, Alembic migrations, and troubleshooting.

Agent Plugins6 Skills

By Agents Store0 GitHub starsUpdated last week

Directory evidence

Runtimes: Agent Plugins
Parsed components: 6 skill or MCP entries
Source updated: Oct 7, 2026
Manifest status: Canonical path parsed

The directory validates manifest shape and source location. It does not execute the plugin or provide a security endorsement. Review the indexing methodology →

Get the plugin

$ git clone https://github.com/Agents-Store/agentplugins

Clone the source repository, then follow its setup instructions to add the plugin to a compatible client. The plugin root is sqlalchemy-dev/.

This listing currently publishes only the generic Agent Plugins format. Automatic install commands for other clients are not generated yet.

Plugin files

sqlalchemy-dev/

├── plugin.json
├── skills/api-reference/SKILL.md
├── skills/cli-recipes/SKILL.md
├── skills/model-patterns/SKILL.md
├── skills/query-patterns/SKILL.md
├── skills/setup/SKILL.md
└── skills/troubleshoot/SKILL.md

Included Skills6

api-referenceskills/api-reference/SKILL.md

Use when the user asks for "SQLAlchemy API reference", "mapped_column options", "SQLAlchemy column types", "SQLAlchemy session methods", "db.session API", "SQLAlchemy relationship options", "lazy loading strategies", or needs specific SQLAlchemy framework API details.

cli-recipesskills/cli-recipes/SKILL.md

Use when the user asks about "Alembic commands", "database migrations", "flask db migrate", "flask db upgrade", "create migration", "rollback migration", "alembic check", "SQLAlchemy CLI", or needs ready-to-use database migration commands.

model-patternsskills/model-patterns/SKILL.md

Use when the user asks about "SQLAlchemy models", "define database model", "Mapped and mapped_column", "DeclarativeBase", "SQLAlchemy relationships", "one-to-many relationship", "many-to-many", "SQLAlchemy column types", "model constraints", "Flask-SQLAlchemy model", "convert db.Column to Mapped 2.0 style", "upgrade to SQLAlchemy 2.1", "Flask-Login User model", "models owned by a user", or needs patterns for defining database models with SQLAlchemy.

query-patternsskills/query-patterns/SKILL.md

Use when the user asks about "SQLAlchemy queries", "filter records", "SQLAlchemy select", "session.scalars", "join tables", "aggregate query", "order by", "pagination", "N+1 query problem", "eager loading", "SQLAlchemy session", "bulk insert", "convert Model.query to select() 2.0 style", "upgrade to SQLAlchemy 2.1", "filter queries by current user", "owner-scoped queries", or needs patterns for querying data with SQLAlchemy.

setupskills/setup/SKILL.md

Use when the user asks to "verify SQLAlchemy setup", "check database connection", "is SQLAlchemy configured correctly", "test database setup", "which SQLAlchemy version", "SQLAlchemy 2.1", or needs to confirm that SQLAlchemy is properly initialized in their Python project.

troubleshootskills/troubleshoot/SKILL.md

Use when the user encounters "SQLAlchemy errors", "database error", "OperationalError", "IntegrityError", "DetachedInstanceError", "AmbiguousColumnError", "LegacyAPIWarning", "No module named psycopg", "SQLAlchemy not working", "migration error", "debug SQLAlchemy", or needs to diagnose and fix common SQLAlchemy problems.

Plugin manifests1

sqlalchemy-dev/plugin.json

{
  "$schema": "https://agent-plugins.org/schemas/1.0.0/plugin.schema.json",
  "name": "sqlalchemy-dev",
  "version": "2.1.0",
  "description": "SQLAlchemy dev plugin for Agents Store. Typed SQLAlchemy 2.0 style (Mapped, mapped_column, select) with a SQLAlchemy 2.1 section: model definition patterns, relationship mapping, query optimization, Alembic migrations, and troubleshooting.",
  "author": {
    "name": "Agents Store",
    "url": "https://github.com/agents-store"
  },
  "keywords": [
    "sqlalchemy",
    "dev",
    "agents-store",
    "python",
    "orm",
    "alembic",
    "database"
  ],
  "extensions": {
    "com.anthropic.claude-code": {
      "agents": "./com.anthropic.claude-code/agents/"
    }
  }
}