Top 8 Python Mssql Projects

airbyte

16 13,821 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: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres | news.ycombinator.com | 2023-12-12

I'l also give a shout-out to Airbyte (https://airbyte.com/), with which I've had some limited success with integrating Salesforce to a local database. The particular pull for Airbyte is that we can self-host the open source version, rather than pay Fivetran a significant sum to do this for us.
It's an immature tool, so I don't yet know that I can claim we've spent _less_ than Fivetran on the additional engineering and ops time, but it feels like it has potential to do so once stabilized.
ibis

16 4,041 10.0 Python

the portable Python dataframe library

Project mention: This Week In Python | dev.to | 2024-03-17

ibis – portable Python dataframe library
InfluxDB

www.influxdata.com
sponsored

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
ingestr

4 2,270 8.9 Python

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

Project mention: FLaNK 04 March 2024 | dev.to | 2024-03-04
fapro

0 1,497 0.0 Python

Fake Protocol Server
django-pyodbc-azure

0 323 0.0 Python

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

3 267 9.6 Python

Project mention: Launch HN: Grai (YC S22) – Open-Source Data Observability Platform | news.ycombinator.com | 2023-07-17

Elastic v2 if one is interested in such things: https://github.com/grai-io/grai-core/blob/v0.1.33/LICENSE
mssql-spider

1 79 7.3 Python

Automated exploitation of MSSQL servers at scale

Project mention: mssql-spider: Automated exploitation of MSSQL user impersonation and linked instances | /r/redteamsec | 2023-04-22
WorkOS

workos.com
sponsored

The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
Traffic-Data-Analysis-with-Apache-Spark-Based-on-Mobile-Robot-Data

0 10 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). The latest post mention was on 2024-03-17.

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	13,821
2	ibis	4,041
3	ingestr	2,270
4	fapro	1,497
5	django-pyodbc-azure	323
6	grai-core	267
7	mssql-spider	79
8	Traffic-Data-Analysis-with-Apache-Spark-Based-on-Mobile-Robot-Data	10