mssql
python sqlalchemy MsSQL utility
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- 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.
- 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 · maintenance · safety
MIT (permissive) — MIT license permits commercial and private use with minimal restrictions, though you retain full responsibility for any issues that arise from the unmaintained codebase.
last release 2020-01-07 (2411 days) · last repo commit 2020-02-09 · 4 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 106,827 downloads/mo, #12,636 on PyPI
Alternatives
Verify before relying
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()- 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
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 on it.
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
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.
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.
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()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 the current Python release >=3.6 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagessqlalchemypyodbc |
| Maintenance | Abandoned 2,411 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 106,827 / month, #12,636 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: MIT LicenseProgramming Language :: Python :: 3Programming Language :: Python :: 3.6 |
Evidence: mssql-1.0.1-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 › “mssql sqlalchemy wrapper”
- mssqlWraps SQLAlchemy and pyodbc to simplify connection and session…
- sqlalchemy-pytdsProvides a SQLAlchemy dialect for connecting to Microsoft SQL Server…
- pymssqlpymssql provides a Python DB-API interface to Microsoft SQL Server,…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also bcpandas · mssql-python · mssql-django · dataset · pypyodbc · sqlalchemy-pytds · pyodbc · python-tds · records · ipython-sql