marshmallow-sqlalchemy

What it is and what it does

marshmallow-sqlalchemy bridges SQLAlchemy ORM models and the marshmallow serialization library, letting you define schemas that automatically map database columns and relationships to serializable fields. Instead of writing field definitions by hand, you declare a schema class pointing to your SQLAlchemy model, and the library generates the fields for you—optionally including relationships and foreign keys. You can then use the schema to dump model instances to dictionaries (for JSON APIs) or load dictionaries back into model instances.

The package handles the common pattern of building REST APIs or other services that need to convert between database objects and wire formats. It integrates with SQLAlchemy sessions to manage object loading and validation, and supports both explicit field declaration (auto_field) and full automatic schema generation (SQLAlchemyAutoSchema). The library is lightweight, with no dependencies beyond marshmallow and SQLAlchemy themselves.

Use it for:

• Build REST APIs that serialize SQLAlchemy models to JSON responses and validate incoming request data
• Generate API documentation schemas automatically from your database model definitions
• Validate and deserialize incoming data directly into ORM instances within a session
• Export database records to JSON or other formats for reporting or data migration
• Decouple your API contract from your internal model structure using schema field customization

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Generates marshmallow schemas from SQLAlchemy models to serialize and deserialize database objects to and from JSON or other formats.

Yes. The package is actively maintained, has no known vulnerabilities, low install friction, and solves a standard problem in database-backed applications. It's widely used (top 5000 on PyPI) and permissively licensed. Install it if you're building APIs or services that need to serialize SQLAlchemy models.

Install

marshmallow-sqlalchemy on PyPI

pip install marshmallow-sqlalchemy

uv add marshmallow-sqlalchemy

poetry add marshmallow-sqlalchemy

Installing marshmallow-sqlalchemy

Before you install

Low friction: pure Python wheel with only two runtime dependencies (marshmallow and SQLAlchemy). Actively maintained with recent commits and releases spanning since 2015.

License in practice

MIT licensed under permissive terms, allowing use in commercial and proprietary projects with minimal restrictions.

Quickstart

pip install marshmallow-sqlalchemy

from marshmallow_sqlalchemy import SQLAlchemyAutoSchema

class AuthorSchema(SQLAlchemyAutoSchema):
    class Meta:
        model = Author
        load_instance = True

schema = AuthorSchema()
author_dict = schema.dump(author_instance)
author_obj = schema.load(author_dict, session=db_session)

Requires Python >= 3.10, marshmallow >= 3.18.0, and SQLAlchemy >= 1.4.40. Models must be declared before schemas are instantiated.

Verify before relying

• Whether auto-generated schemas handle all SQLAlchemy column types and relationships correctly
• Performance characteristics when serializing large result sets or deeply nested relationships

Package facts

Evidence: marshmallow_sqlalchemy-1.5.0-py3-none-any.whl

Tags

More Database packages