Python MySQL

Open-source Python projects categorized as MySQL

Top 23 Python MySQL Projects

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

    GitHub: Redash GitHub Repository

  2. 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.

    InfluxDB logo
  3. 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: 7 Best Data Integration Platforms: Reviews & Top Picks | dev.to | 2025-05-26

    Website: https://airbyte.com/

  4. mycli

    A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

    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

  5. sqlglot

    Python SQL Parser and Transpiler

    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.

  6. PyMySQL

    MySQL client library for Python

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

  8. ibis

    the portable Python dataframe library

    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

  9. 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.

    Stream logo
  10. tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    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.

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

  12. databases

    Async database support for Python. 🗄

    Project mention: Building a Realworld blog backend in 600 lines of Python | dev.to | 2025-02-12

    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

  13. PonyORM

    Pony Object Relational Mapper

    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.

  14. Gopherus

    This tool generates gopher link for exploiting SSRF and gaining RCE in various servers

  15. mysqlclient

    MySQL/MariaDB connector for Python

  16. python-mysql-replication

    Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL

  17. learning

    Learning Shell,Python,Golang,System,Network (by anzhihe)

  18. borgmatic

    Simple, configuration-driven backup software for servers and workstations

    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/

  19. aiomysql

    aiomysql is a library for accessing a MySQL database from the asyncio

  20. fapro

    Fake Protocol Server

  21. eralchemy

    Entity Relation Diagrams generation tool

  22. 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...

  23. django-dbbackup

    Management commands to help backup and restore your project database and media files

  24. aerich

    A database migrations tool for TortoiseORM, ready to production.

  25. dolphie

    Your single pane of glass for real-time analytics into MySQL/MariaDB & ProxySQL

    Project mention: Real-time analytics into MySQL/MariaDB and ProxySQL in the terminal | news.ycombinator.com | 2024-10-12
  26. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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

Log in or Post with

Python MySQL related posts

  • Show HN: SQL-tString a t-string SQL builder in Python

    6 projects | news.ycombinator.com | 16 May 2025
  • Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy

    3 projects | news.ycombinator.com | 23 Apr 2025
  • 7 Best Change Data Capture (CDC) Tools in 2025

    2 projects | dev.to | 11 Apr 2025
  • Show HN: DbCls is a versatile terminal client that supports various databases

    1 project | news.ycombinator.com | 9 Apr 2025
  • Millions are visiting the European Alternatives site––what trends are we seeing?

    2 projects | news.ycombinator.com | 24 Mar 2025
  • I created my own search engine

    1 project | dev.to | 19 Feb 2025
  • Building a Realworld blog backend in 600 lines of Python

    4 projects | dev.to | 12 Feb 2025
  • A note from our sponsor - SaaSHub
    www.saashub.com | 9 Jul 2025
    SaaSHub helps you find the best software and product alternatives Learn more →

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

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

Did you know that Python is
the 2nd most popular programming language
based on number of references?