Top 8 Python Mssql Projects

airbyte

140 14,296 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: How to Build a Chat App with Your Postgres Data using Agent Cloud | dev.to | 2024-05-13

AgentCloud uses Airbyte to build data pipelines, which allow us to split, chunk, and embed data from over 300 data sources, including Postgres.

ibis

23 4,304 10.0 Python

the portable Python dataframe library

Project mention: Show HN: Hashquery, a Python library for defining reusable analysis | news.ycombinator.com | 2024-04-23

I really don't understand the appeal of dbt vs a proper programming language. The templating approach leads to massive spaghetti. I look forward to trying out something like Ibis [0]
0: https://ibis-project.org/

InfluxDB

www.influxdata.com featured

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,341 9.0 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

5 1,497 0.0 Python

Fake Protocol Server
django-pyodbc-azure

2 323 0.0 Python

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

6 270 9.5 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 78 7.2 Python

Automated exploitation of MSSQL servers at scale
SaaSHub

www.saashub.com featured

SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Traffic-Data-Analysis-with-Apache-Spark-Based-on-Mobile-Robot-Data

1 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).

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