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. 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.
-
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.
Project mention: Migrate connectors from MIT to ELv2 – Pull Request #63723 – airbytehq/airbyte | news.ycombinator.com | 2025-08-15 -
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
-
Sevalla
Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
-
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
-
-
-
-
-
-
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
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 MySQL discussion
Python MySQL related posts
-
How I’d scale a side project to 1 million users (without melting my server)
-
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
-
A note from our sponsor - InfluxDB
www.influxdata.com | 1 Sep 2025
Index
What are some of the best open-source MySQL projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | Redash | 27,704 |
| 2 | airbyte | 19,349 |
| 3 | mycli | 11,686 |
| 4 | sqlglot | 8,218 |
| 5 | PyMySQL | 7,812 |
| 6 | dev-setup | 6,213 |
| 7 | ibis | 6,065 |
| 8 | tortoise-orm | 5,262 |
| 9 | AWS Data Wrangler | 4,054 |
| 10 | databases | 3,935 |
| 11 | PonyORM | 3,771 |
| 12 | Gopherus | 3,133 |
| 13 | mysqlclient | 2,508 |
| 14 | python-mysql-replication | 2,396 |
| 15 | borgmatic | 2,040 |
| 16 | learning | 2,019 |
| 17 | aiomysql | 1,832 |
| 18 | fapro | 1,593 |
| 19 | eralchemy | 1,250 |
| 20 | nagios-plugins | 1,144 |
| 21 | django-dbbackup | 1,056 |
| 22 | aerich | 960 |
| 23 | dolphie | 891 |
Sponsored
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.
www.influxdata.com