mssql

What it is and what it does

mssql is a thin wrapper around sqlalchemy and pyodbc that abstracts away boilerplate connection setup for Microsoft SQL Server databases. It provides a simple class-based interface to initialize a connection and retrieve a sqlalchemy session, reducing the amount of configuration code needed for basic MSSQL workflows.

The package has been unmaintained since 2020-01-07 and has received no updates since its initial release. While it carries a permissive MIT license and has low install friction, its age and lack of maintenance mean it may not work reliably with current versions of its dependencies or modern SQL Server deployments. It is suitable only for legacy projects or environments where dependency versions are pinned to 2020-era releases.

Use it for:

• Quick prototyping of MSSQL database access in Python scripts without writing boilerplate connection code.
• Legacy projects that were built against this package and have pinned dependencies to 2020 versions.
• Educational or demonstration code where simplifying sqlalchemy setup is the primary goal.
• Migrating from raw pyodbc to sqlalchemy ORM with minimal refactoring.

Worth the install?

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

Wraps SQLAlchemy and pyodbc to simplify connection and session management for Microsoft SQL Server databases.

No, not for new projects. The package is abandoned and has not been updated since 2020-01-07, creating a significant maintenance and compatibility risk. Use sqlalchemy directly with pyodbc instead. Only consider it if you are maintaining legacy code that already depends on it.

Install

mssql on PyPI

pip install mssql

uv add mssql

poetry add mssql

Installing mssql

Before you install

Low install friction, but the package is abandoned as of 2020-02-09 with no updates since its initial release. Maintenance status is a significant concern for production use.

License in practice

MIT license permits commercial and private use with minimal restrictions, though you retain full responsibility for any issues that arise from the unmaintained codebase.

Quickstart

pip install mssql

from mssql import MsSql

ms = MsSql(host='localhost', db_name='mydb', user='sa', pw='password', driver='ODBC Driver for SQL Server')
session = ms.session_conn()

Requires ODBC drivers to be installed on the system and pyodbc to be able to locate them; SQL Server connectivity depends on network access and valid credentials.

Verify before relying

• Whether pyodbc system dependencies (ODBC drivers) are available in your target environment
• Compatibility with current versions of SQLAlchemy beyond what the fact sheet indicates
• Whether the package works with modern SQL Server versions and authentication methods

Package facts

Evidence: mssql-1.0.1-py3-none-any.whl

Tags

More Database packages