---
id: mssql
version: "1.0.1"
license: MIT
license_treatment: permissive
maintenance: abandoned
---

# mssql — python sqlalchemy MsSQL utility

License: permissive · Maintenance: abandoned · Downloads: 106.8K/mo

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

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

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: abandoned
- Downloads: 106.8K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

mssql sqlalchemy wrapper, sql server python connection, mssql session management, sqlalchemy mssql utility, pyodbc mssql helper, abandoned, mssql-wrapper

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