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.

Codex6 Skills

By Agents Store0 GitHub starsUpdated 2 weeks ago

Directory evidence

Runtimes: Codex
Parsed components: 6 skill or MCP entries
Source updated: Oct 4, 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 →

Install sqlalchemy-dev for Codex

Installs for the current user

codex plugin marketplace add Agents-Store/codex-plugins
codex plugin marketplace upgrade agents-store-codex-plugins
codex plugin add sqlalchemy-dev@agents-store-codex-plugins

Paste and run these commands in a terminal with Codex. They add and refresh the agents-store-codex-plugins catalog, then install this plugin.

Compatibility: the page URL and API slug “sqlalchemy-dev” remain stable.

Codex: sqlalchemy-dev@agent-plugin-marketplace → sqlalchemy-dev@agents-store-codex-plugins

The installer fetches third-party code from the source repository shown on this page. This directory validates manifest structure and source location, but does not perform a security audit; review the manifest, components, and source before installing.

Get the source manually

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

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

Plugin files

sqlalchemy-dev/

├── .codex-plugin/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/.codex-plugin/plugin.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"
  ],
  "skills": "./skills/",
  "interface": {
    "displayName": "Sqlalchemy Dev",
    "shortDescription": "SQLAlchemy dev plugin for Agents Store. Typed SQLAlchemy 2.0…",
    "longDescription": "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.",
    "developerName": "Agents Store",
    "category": "development",
    "capabilities": [
      "Read",
      "Write"
    ],
    "websiteURL": "https://agents.store"
  }
}