sqlalchemy-pytds

What it is and what it does

sqlalchemy-pytds is a SQLAlchemy dialect that bridges SQLAlchemy's ORM and query layer to Microsoft SQL Server databases using the TDS protocol. It depends on python-tds for the low-level protocol implementation and SQLAlchemy for the database abstraction layer. The package allows developers to write database code using SQLAlchemy's standard API while connecting to SQL Server instances.

The package is in Beta status and has been dormant for extended periods, though the repository remains unarchived. It sits in the top 5000 PyPI packages by download volume, suggesting some production use, but the infrequent maintenance and outdated Python version classifiers warrant caution when evaluating it for new projects.

Use it for:

• Building SQLAlchemy applications that need to connect to SQL Server without using ODBC-dependent drivers
• Using SQLAlchemy's ORM to query and manipulate SQL Server data in a database-agnostic way
• Environments where pure-Python TDS connectivity is preferred over compiled driver libraries

Worth the install?

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

Provides a SQLAlchemy dialect for connecting to Microsoft SQL Server via the TDS protocol using python-tds as the underlying driver.

Yes, with conditions. The package is permissively licensed and has low install friction, but its dormant maintenance status and outdated Python version classifiers mean you should verify that python-tds meets your SQL Server compatibility and performance needs before committing to production use.

Install

sqlalchemy-pytds on PyPI

pip install sqlalchemy-pytds

uv add sqlalchemy-pytds

poetry add sqlalchemy-pytds

Installing sqlalchemy-pytds

Before you install

Low install friction with a pure-Python wheel distribution. Maintenance is dormant—last commit was 2024-09-14 but no activity for 699 days prior; the repository remains unarchived but receives infrequent updates.

License in practice

MIT license permits commercial and private use with minimal restrictions, making it safe for most projects.

Quickstart

pip install sqlalchemy-pytds

from sqlalchemy import create_engine
engine = create_engine('mssql+pytds://user:password@server/database')

Requires python-tds and SQLAlchemy to be installed; python-tds handles the underlying TDS protocol implementation.

Verify before relying

• Whether python-tds itself is actively maintained and suitable for production SQL Server workloads
• Compatibility with modern Python versions beyond those listed in classifiers (3.5 is the latest declared)
• Whether this dialect supports the full range of SQL Server features or has known limitations

Package facts

Evidence: sqlalchemy_pytds-1.0.2-py2.py3-none-any.whl

Keywords: SQLAlchemy, Microsoft, SQL, Server

Tags

More Front-Ends packages