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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
airbyte
Open-source data movement for ELT pipelines and AI agents — from APIs, databases & files to warehouses, lakes, and AI applications. Both self-hosted and Cloud.
Project mention: Show HN: Airbyte Agents – context for agents across multiple data sources | news.ycombinator.com | 2026-05-05 -
Project mention: CLI to manage your SQL database schemas and migrations | news.ycombinator.com | 2025-11-01
Tangential, but anyone can suggest their favorite SQL client? Many years ago on Windows I enjoyed HeidiSQL, and while you can kind of use it with wine, it doesn't make a stable impression to me.
Recently I found mycli[1], which seems slightly better than the official mariadb cli client, but still a bit cumbersome.
[1] https://github.com/dbcli/mycli
-
I'm curious because I have a similar use case for a querying frontend. Did you consider using https://github.com/tobymao/sqlglot? If so, what was missing to justify writing your own parser?
-
-
At my company, we use Archery for SQL audit and read-only queries against our databases.
-
-
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.
-
-
sqlit
A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL, SQLite, Turso and more.
- Themes (Rose Pine, Tokyo Night, Nord, Gruvbox).
Install: `pipx install sqlit-tui` (also works with `uv tool install` and `pip`).
Built with Python and Textual. First shared here in December (https://news.ycombinator.com/item?id=46276002) - a lot has shipped since.
Repo: https://github.com/Maxteabag/sqlit
Feedback welcome, especially on what's still missing for daily-driver use.
My goal is to make an aesthetic tool that makes it easy and enjoyable to connect and query data, and do that one thing only, really well.
-
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).
-
-
-
-
python-mysql-replication
Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL
-
Project mention: Borgmatic: The Simple, Configuration-Driven Guardian for Your Server Backups | dev.to | 2025-10-29
View the Project on GitHub
-
-
-
-
-
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...
-
-
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
-
A thread-safe disk based persistent queue in Python
-
Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip
-
Sqlit – A lazygit-style TUI for SQL databases
-
We Built an Agent That Analyzes Itself — Here’s What We Learned
-
Show HN: DbCls, terminal client for various databases
-
Real-Time Data Monitoring Using InfluxDB and Grafana
-
Show HN: I made a TIDAL client that runs in the terminal
-
A note from our sponsor - SaaSHub
www.saashub.com | 12 Jun 2026
Index
What are some of the best open-source MySQL projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | Redash | 28,621 |
| 2 | airbyte | 21,430 |
| 3 | mycli | 11,923 |
| 4 | sqlglot | 9,318 |
| 5 | PyMySQL | 7,838 |
| 6 | Archery | 6,871 |
| 7 | ibis | 6,570 |
| 8 | dev-setup | 6,264 |
| 9 | tortoise-orm | 5,574 |
| 10 | sqlit | 4,317 |
| 11 | AWS Data Wrangler | 4,109 |
| 12 | PonyORM | 3,823 |
| 13 | Gopherus | 3,340 |
| 14 | mysqlclient | 2,532 |
| 15 | python-mysql-replication | 2,415 |
| 16 | borgmatic | 2,273 |
| 17 | aiomysql | 1,888 |
| 18 | fapro | 1,608 |
| 19 | eralchemy | 1,414 |
| 20 | dolphie | 1,162 |
| 21 | nagios-plugins | 1,149 |
| 22 | django-dbbackup | 1,111 |
| 23 | aerich | 1,090 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com