---
id: sqlbag
version: "0.1.1617247075"
license: unclear
license_treatment: unclear
maintenance: abandoned
---

# sqlbag — various snippets of SQL-related boilerplate

License: unclear · Maintenance: abandoned · Downloads: 258.1K/mo

## What it is and what it does

sqlbag is a collection of convenience functions and helpers built on top of SQLAlchemy to reduce boilerplate when working with databases. It provides utilities for managing database connections, setting up Flask integration, working with the ORM, and creating temporary databases for integration tests. The package bundles these common patterns into a single import so you don't have to rewrite them across projects.

The package depends on six, sqlalchemy, packaging, and pathlib, and can be extended with optional database drivers (psycopg2 for PostgreSQL, pymysql for MySQL/MariaDB) via install-time bundles. However, it has been abandoned since its latest release on 2021-04-01 with no active maintenance, and carries Alpha status, meaning it may not work reliably with modern versions of its dependencies.

Use it for:

- Set up Flask applications with SQLAlchemy ORM without writing repetitive connection and session boilerplate.
- Create and tear down temporary test databases for integration tests that need a real database backend.
- Manage database connections across multiple projects using a shared set of helpers.
- Quickly prototype database-backed applications by reusing common ORM and connection patterns.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

sqlbag provides a collection of SQLAlchemy utilities and helpers for common database tasks, including connection management, Flask integration, ORM helpers, and temporary database setup for testing.

No—not recommended for new projects. The package is abandoned (no updates since 2021-04-01), carries Alpha status, and its license is unclear. While it has low install friction and no known vulnerabilities, the lack of maintenance means it will not keep pace with SQLAlchemy or Python version changes. For new work, prefer actively maintained alternatives or write the boilerplate directly.

## Install

pip install sqlbag
uv add sqlbag
poetry add sqlbag

## Installing sqlbag

Before you install: Installation is straightforward with low friction, but the package is abandoned as of 2021 with no updates since its latest release. The last commit was in March 2023, suggesting minimal maintenance. It carries Alpha status and may not be compatible with modern SQLAlchemy or Python versions.

License in practice: License treatment is unclear—no SPDX identifier or raw license text is available. Before using this package in production or distribution, verify the actual license terms from the repository.

Quickstart:

pip install sqlbag

import sqlbag
# Use sqlbag helpers for database connections, Flask setup, or temporary test databases

Python version support is unspecified; compatibility with modern Python and SQLAlchemy versions is unknown given the package's abandoned status.

Verify before relying:

- Actual license terms—license_treatment is unclear and no SPDX identifier is present.
- Compatibility with current SQLAlchemy versions given the package has not been updated since 2021-04-01.
- Whether the runtime dependencies (six, sqlalchemy, packaging, pathlib) are pinned to specific versions or ranges.

## Package facts

- License: not declared (unclear)
- Python support: unspecified
- Install friction: low
- Maintenance: abandoned
- Downloads: 258.1K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy boilerplate utilities, database connection helpers, flask sqlalchemy setup, temporary test database, sql orm shortcuts, sqlalchemy-helpers, abandoned

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