---
id: marshmallow-sqlalchemy
version: "1.5.0"
license: unclear
license_treatment: permissive
maintenance: active
---

# marshmallow-sqlalchemy — SQLAlchemy integration with the marshmallow (de)serialization library

License: permissive · Maintenance: active · Downloads: 12.2M/mo

## 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 above — 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

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

- License: not declared (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 12.2M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy schema generation, serialize database models, marshmallow sqlalchemy integration, orm to json serialization, database model validation, orm-serialization, rest-api, data-validation

[View on SkillFed](https://skillfed.io/packages/marshmallow-sqlalchemy) · [View on PyPI](https://pypi.org/project/marshmallow-sqlalchemy/)