Top 10 Python Mssql Projects

airbyte

1 156 18,623 10.0 Python

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.

Project mention: 7 Best Data Integration Platforms: Reviews & Top Picks | dev.to | 2025-05-26

Website: https://airbyte.com/
InfluxDB

www.influxdata.com featured

InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
ibis

2 34 5,893 9.9 Python

the portable Python dataframe library

Project mention: Why Pandas feels clunky when coming from R (2024) | news.ycombinator.com | 2025-06-07

pandas* per the style guide (nobody follows it)
also I recommend trying Ibis. created by the creator of pandas originally and solves so many of the issues
https://ibis-project.org
ingestr

3 8 3,006 9.9 Python

ingestr is a CLI tool to copy data between any databases with a single command seamlessly.

Project mention: Ingestr: Your New Best Friend for Effortless Data Migration | dev.to | 2025-06-28

View the Project on GitHub
fapro

4 5 1,585 0.0 Python

Fake Protocol Server
advanced-alchemy

5 2 585 9.4 Python

A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy

Project mention: Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy | news.ycombinator.com | 2025-04-23

For some else who's looking, they're folded in the readme under "click for more details": https://github.com/litestar-org/advanced-alchemy/blob/v1.3.1...
django-pyodbc-azure

6 2 319 0.0 Python

Django backend for Microsoft SQL Server and Azure SQL Database using pyodbc
grai-core

7 6 306 7.4 Python
Stream

getstream.io featured

Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.
data-observability-installer

8 1 120 8.4 Python

Installer for DataKitchen's Open Source Data Observability Products. Data breaks. Servers break. Your toolchain breaks. Ensure your team is the first to know and the first to solve with visibility across and down your data estate. Save time with simple, fast data quality test generation and execution. Trust your data, tools, and systems end to end.
mssql-spider

9 1 109 6.8 Python

Automated exploitation of MSSQL servers at scale
Traffic-Data-Analysis-with-Apache-Spark-Based-on-Mobile-Robot-Data

10 1 13 0.0 Python

Mobile robot data were analyzed with Apache-Spark to extract five different statistical result such as travel time, waiting time, average speed, occupancy and density were produced.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Python Mssql discussion

Python Mssql related posts

PostgreSQL alternative for Large amounts of data

8 projects | /r/PostgreSQL | 24 Aug 2022
Is there a Django v3 package for connecting to the azure database?

3 projects | /r/django | 29 Nov 2021
Connect vue app to Azure SQL and query data

1 project | /r/vuejs | 3 Feb 2021

Index

What are some of the best open-source Mssql projects in Python? This list will help you:

#	Project	Stars
1	airbyte	18,623
2	ibis	5,893
3	ingestr	3,006
4	fapro	1,585
5	advanced-alchemy	585
6	django-pyodbc-azure	319
7	grai-core	306
8	data-observability-installer	120
9	mssql-spider	109
10	Traffic-Data-Analysis-with-Apache-Spark-Based-on-Mobile-Robot-Data	13