nsj-sql-utils-lib
Biblioteca de utilitários Python para facilitar a implementação de sistemas com acesso a banco de dados.
Decision gist · record as of 2026-08-14
Yes, if you need DAO utilities and a lightweight database updater for PostgreSQL or MySQL. The low install friction and absence of known vulnerabilities are positives. However, the aging maintenance status (382 days since last release) and unclear license mean you should verify the license terms and accept slower updates. Not suitable for projects requiring active support or strict license compliance.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires one of the runtime database drivers (psycopg2_binary for PostgreSQL, mysql-connector-python for MySQL) to be installed separately.
- Low install friction with a pure-Python wheel.
- Maintenance status is aging—last release was 382 days ago—so expect slower response to issues, though the package remains functional for its stated purpose.
License · maintenance · safety
(unclear) — License status is unclear; no SPDX identifier or raw license text is available. Review the repository before adopting in a commercial or restricted-license context.
last release 2025-07-28 (382 days)
0 known vulnerabilities (OSV.dev, 2026-08-14) · 134,094 downloads/mo, #11,487 on PyPI
Alternatives
Verify before relying
pip install nsj-sql-utils-lib
from nsj_sql_utils_lib.dao_util import dbadapter3
adapter = dbadapter3.DbAdapter(connection)
# Use adapter to build DAO queries- Whether the package is actively maintained or in maintenance-only mode given the 382-day gap since last release.
- Specific Python version compatibility beyond the stated >=3.4 requirement.
- Whether the db-updater CLI is production-ready or still in alpha (classifier shows Development Status :: 3 - Alpha).
What it is and what it does
nsj-sql-utils-lib is a collection of Python utilities for database operations, centered on simplifying DAO (Data Access Object) implementation and database connection management. It provides adapter classes for PostgreSQL (via psycopg2) and MySQL (via mysql-connector-python), a standalone PostgreSQL connection handler, and a command-line database updater for applying versioned schema migrations from a structured file hierarchy.
The package is designed for teams building systems with direct database access, offering helpers to reduce boilerplate when constructing SELECT, INSERT, and UPDATE statements. The db-updater subcommand allows you to manage database schema changes from a directory structure (functions, scripts, views) and can be invoked via pip or Docker. It depends on SQLAlchemy, sqlparams, and python-logging-loki alongside the database drivers.
Use it for
- Build DAO classes for PostgreSQL or MySQL without writing repetitive SQL construction code.
- Manage database schema migrations and function deployments using the db-updater CLI with version tracking.
- Wrap existing psycopg2 or MySQL connections in a standardized adapter interface for consistent query building.
- Automate database updates in Docker environments using the provided updater image.
- Centralize database utility logic across multiple projects in a single installed library.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need DAO utilities and a lightweight database updater for PostgreSQL or MySQL.
The low install friction and absence of known vulnerabilities are positives. However, the aging maintenance status (382 days since last release) and unclear license mean you should verify the license terms and accept slower updates. Not suitable for projects requiring active support or strict license compliance.
Install
nsj-sql-utils-lib on PyPI
Before you install
Low install friction with a pure-Python wheel. Maintenance status is aging—last release was 382 days ago—so expect slower response to issues, though the package remains functional for its stated purpose.
Requires one of the runtime database drivers (psycopg2_binary for PostgreSQL, mysql-connector-python for MySQL) to be installed separately.
License in practice
License status is unclear; no SPDX identifier or raw license text is available. Review the repository before adopting in a commercial or restricted-license context.
Quickstart
pip install nsj-sql-utils-lib
from nsj_sql_utils_lib.dao_util import dbadapter3
adapter = dbadapter3.DbAdapter(connection)
# Use adapter to build DAO queriesVerify before relying
- Whether the package is actively maintained or in maintenance-only mode given the 382-day gap since last release.
- Specific Python version compatibility beyond the stated >=3.4 requirement.
- Whether the db-updater CLI is production-ready or still in alpha (classifier shows Development Status :: 3 - Alpha).
Package facts
| License | Not declared unclear |
| Python support | Supports the current Python release >=3.4 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 5 packagespsycopg2_binarySQLAlchemysqlparamsmysql-connector-pythonpython-logging-loki |
| Maintenance | Aging 382 days since the last release |
| First released | |
| Downloads | 134,094 / month, #11,487 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 3 - AlphaIntended Audience :: DevelopersProgramming Language :: Python :: 3Topic :: Software Development :: Libraries |
Evidence: nsj_sql_utils_lib-2.1.3-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “database access utilities python”
- nsj-sql-utils-libProvides Python utilities for database access, including DAO helpers,…
- cwe2cwe2 provides programmatic access to the Common Weakness Enumeration…
- shadowcopyCopy files locked by other processes on Windows by leveraging the…
Give your agent the search over MCP, or paste the wish link into any chat.
More Libraries packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Provides parsing, arithmetic, and recurrence rule computation for dates and times, with timezone support and iCalendar RFC compliance.
Install it if you need to parse flexible date strings, compute relative dates, handle timezones, or work with recurrence rules—it's the de facto choice for these tasks.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
See also nsj-gcf-utils · nsj-queue-lib · nsj-rest-lib · postgres · nsj-rest-lib2 · psycopg2 · psycopg · pgdb · dbt-postgres · mssql