SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python MySQL Projects
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Project mention: The 50 best open-source alternatives to popular SaaS software | dev.to | 2024-07-10GitHub: Redash GitHub Repository
-
InfluxDB
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.
-
airbyte
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.
Website: https://airbyte.com/
-
Project mention: SQLiteStudio: Create, edit, browse SQLite databases | news.ycombinator.com | 2024-11-24
One day I set out to resolve this, though I can not find in my notes' files what the solution was (for MySQL). It might have been to simply use MyCLI instead of the standard MySQL CLI. Have you tried it?
https://github.com/dbcli/mycli
-
Project mention: Show HN: SQL-tString a t-string SQL builder in Python | news.ycombinator.com | 2025-05-16
https://github.com/tobymao/sqlglot :
> SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine [written in Python] . It can be used to format SQL or translate between 24 different dialects like DuckDB, Presto / Trino, Spark / Databricks, Snowflake, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects.
-
-
dev-setup
macOS development environment setup: Easy-to-understand instructions with automated setup scripts for developer tools like Vim, Sublime Text, Bash, iTerm, Python data analysis, Spark, Hadoop MapReduce, AWS, Heroku, JavaScript web development, Android development, common data stores, and dev-based OS X defaults.
-
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
-
Stream
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.
-
Project mention: Why Developers Are Choosing Tortoise ORM as Python’s Modern ORM | dev.to | 2025-05-11
For more detailed usage, please refer to the Tortoise ORM Official Documentation.
-
AWS Data Wrangler
pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).
-
AwaitableModel is a model base class in UtilMeta to provide fully async query in Django using encode/databases, which will unleash the async performance for Django ORM
-
Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24
Alternative ORMs: there are many such as peewee, PonyORM, etc.
-
-
-
python-mysql-replication
Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL
-
-
Project mention: Syncthing – A decentralized continuous file synchronization program | news.ycombinator.com | 2024-08-18
You could use Syncthing just to empty the incoming files from your phone (ingest) and then move the photos via cron to a second folder (also Syncthing) which is just shared with the replicas.
Another approach would be to push the files from Syncthing to borg (borgmatic can do replicas) https://torsion.org/borgmatic/
-
-
-
-
nagios-plugins
450+ AWS, Hadoop, Cloud, Kafka, Docker, Elasticsearch, RabbitMQ, Redis, HBase, Solr, Cassandra, ZooKeeper, HDFS, Yarn, Hive, Presto, Drill, Impala, Consul, Spark, Jenkins, Travis CI, Git, MySQL, Linux, DNS, Whois, SSL Certs, Yum Security Updates, Kubernetes, Cloudera etc...
-
django-dbbackup
Management commands to help backup and restore your project database and media files
-
-
Project mention: Real-time analytics into MySQL/MariaDB and ProxySQL in the terminal | news.ycombinator.com | 2024-10-12
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Python MySQL discussion
Python MySQL related posts
-
Show HN: SQL-tString a t-string SQL builder in Python
-
Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy
-
7 Best Change Data Capture (CDC) Tools in 2025
-
Show HN: DbCls is a versatile terminal client that supports various databases
-
Millions are visiting the European Alternatives site––what trends are we seeing?
-
I created my own search engine
-
Building a Realworld blog backend in 600 lines of Python
-
A note from our sponsor - SaaSHub
www.saashub.com | 9 Jul 2025
Index
What are some of the best open-source MySQL projects in Python? This list will help you:
# | Project | Stars |
---|---|---|
1 | Redash | 27,497 |
2 | airbyte | 18,623 |
3 | mycli | 11,671 |
4 | sqlglot | 7,947 |
5 | PyMySQL | 7,794 |
6 | dev-setup | 6,191 |
7 | ibis | 5,893 |
8 | tortoise-orm | 5,173 |
9 | AWS Data Wrangler | 4,035 |
10 | databases | 3,914 |
11 | PonyORM | 3,743 |
12 | Gopherus | 3,033 |
13 | mysqlclient | 2,507 |
14 | python-mysql-replication | 2,387 |
15 | learning | 2,019 |
16 | borgmatic | 2,007 |
17 | aiomysql | 1,819 |
18 | fapro | 1,585 |
19 | eralchemy | 1,244 |
20 | nagios-plugins | 1,145 |
21 | django-dbbackup | 1,052 |
22 | aerich | 940 |
23 | dolphie | 839 |