Search Results for "mysql for python"
Sort By:
Showing 648 open source projects for "mysql for python"
View related business solutions-
Keep company data safe with Chrome EnterpriseMake AI work your way with Chrome Enterprise. Block unapproved sites and set custom data controls that align with your company's policies.
-
QuickBooks-integrated B2B eCommerce toolsThe platform offers two-way QuickBooks integration, easy setup at no additional charge, 24/7 selling for merchants, and powerful business insight and remote management tools. The platform comes with three modules that can be purchased individually or bundled together. These are Customer Portal, Rep Portal, and Fulfillment modules.
-
1
Prisma Client Python
Prisma Client Python is an auto-generated and fully type-safe database
prisma-client-py is an auto-generated Python ORM for Prisma schema files, bringing Prisma's developer experience to Python projects. It provides a type-safe, intuitive interface for interacting with databases like PostgreSQL and MySQL. prisma-client-py is ideal for Python developers who want static typing, code completion, and seamless integration with modern backend stacks. -
2
PyMySQL
MySQL client library for Python
PyMySQL is a 100% Python implementation of the MySQL client protocol, allowing Python applications to connect to MySQL and MariaDB databases without requiring binary extensions. It supports standard DB‑API 2.0 features, such as cursors, transactions, and parameterized queries. PyMySQL is versatile for web applications, scripts, and tools, offering compatibility with ORMs like SQLAlchemy and frameworks like Django. -
3
mysqlclient
MySQL/MariaDB connector for Python
Summary: mysqlclient is a MySQL/MariaDB connector for Python, providing a convenient interface for database interactions. -
4
mycli
CLI for MySQL with auto-completion and syntax highlighting
mycli is an enhanced command-line client for MySQL and MariaDB that features syntax highlighting and intelligent auto-completion for database queries. Built for developers and DBAs, it improves productivity with features like query history, table suggestions, and colored output. The tool is designed to be both powerful and user-friendly, making interactive database work more efficient and visually intuitive. -
The Best MRP Software for Small BusinessesKatana is the #1 modern manufacturing & inventory software for scaling businesses. Automate your workflows with Katana’s visual interface and smart auto-booking engine, which allow you to prioritize orders and see the availability of raw materials & finished goods in real-time.
-
5
Pony ORM
Pony Object Relational Mapper
Pony ORM is a Python ORM that enables developers to write database queries using generator expressions and Pythonic syntax, making code more readable and intuitive. It automatically translates Python expressions into SQL and supports multiple databases including SQLite, MySQL, PostgreSQL, and Oracle. With an emphasis on simplicity and maintainability, Pony ORM is suitable for both small projects and complex applications. -
6
peepDB
CLI tool and python library to inspect databases fast
peepDB is an open-source command-line tool and Python library designed for developers and database administrators who need a fast and efficient way to inspect their database tables without writing SQL queries. With support for MySQL, PostgreSQL, and MariaDB, peepDB is lightweight, secure, and incredibly easy to use. -
7
Aerich
A database migrations tool for TortoiseORM, ready to production
Aerich is a lightweight database migration tool built for Tortoise ORM, an async ORM for Python. It handles schema evolution through versioned migrations, enabling developers to update and rollback database changes with ease. Designed for asyncio-based applications, Aerich is ideal for fast-moving Python projects that need simple migration control without heavy dependencies. -
8
Django Cachalot
No effort, no worry, maximum performance
Caches your Django ORM queries and automatically invalidates them. Cachalot officially supports Python 3.7-3.10 and Django 2.2, 3.2, and 4.0-4.1 with the databases PostgreSQL, SQLite, and MySQL. Note: an upper limit on Django version is set for your safety. Please do not ignore it. To start developing, install the requirements and run the tests via tox. Currently, benchmarks are supported on Linux and Mac/Darwin. You will need a database called "cachalot" on MySQL and PostgreSQL. ... -
9
MDServer Web
Simple Linux Panel
MDServer-Web is an open-source, web-based control panel for managing web servers and hosting environments. It supports popular web servers like Nginx and Apache, along with databases such as MySQL and Redis. The panel provides a user-friendly interface to manage websites, databases, SSL certificates, and more, making server administration accessible even to those with limited technical knowledge. -
Manage your ClassesDreamClass helps you efficiently manage all of your processes. Enjoy professional school management for any educational institution, in minutes!
-
10
apache-logs-to-mysql
Apache Log Parser and Data Normalization Application
Apache Log Parser and Data Normalization Application Python handles File Processing & MySQL handles Data Processing ApacheLogs2MySQL consists of two Python Modules & one MySQL Schema to automate importing Access & Error files and normalizing data into database designed for reports & data analysis. Runs on Windows, Linux and MacOS & tested with MySQL versions 8.0.39, 8.4.3, 9.0.0 & 9.1.0. 4 LogFormats & 2 ErrorLogFormats can be loaded and 5 MySQL Stored Procedures can be processed in a single Python `ProcessLogs function` execution. ... -
11
peewee
A small, expressive orm, which supports postgresql, mysql and sqlite
Peewee is a simple and small ORM. It has few (but expressive) concepts, making it easy to learn and intuitive to use. Peewee will automatically infer the database table name from the name of the class. You can override the default name by specifying a table_name attribute in the inner “Meta” class (alongside the database attribute). To learn more about how Peewee generates table names, refer to the Table Names section. There are lots of field types suitable for storing various types of data.... -
12
django-helpdesk
A Django application to manage tickets for an internal helpdesk
A Django application to manage tickets for an internal helpdesk. Formerly known as Jutda Helpdesk. django-helpdesk was formerly known as Jutda Helpdesk, named after the company which originally created it. As of January 2011 the name has been changed to reflect what it really is: a Django-powered ticket tracker with contributors reaching far beyond Jutda. django-helpdesk includes a basic demo Django project so that you may easily get started with testing or developing django-helpdesk. The... -
13
Tortoise ORM
Familiar asyncio ORM for python, built with relations in mind
Tortoise ORM is an easy-to-use asyncio ORM (Object Relational Mapper) for Python, inspired by Django's ORM. It is designed to work with asynchronous frameworks, providing a simple and familiar API for interacting with databases. Tortoise ORM supports various relational databases and is suitable for building high-performance web applications. -
14
Grafana
Leading open-source visualization and observability platform
Grafana Open Source is a leading open-source visualization and observability platform that lets you query, visualize, alert on, and explore your data—regardless of where it’s stored. With support for 100+ data source plugins (such as Prometheus, Loki, Elasticsearch, InfluxDB, SQL/NoSQL databases, OpenTelemetry, and more), you can unify metrics, logs, traces, and other observability signals in one place. Grafana OSS empowers you to build dynamic, reusable dashboards with rich... -
15
sqlmap
Automatic SQL injection and database takeover tool
sqlmap is a powerful, feature-filled, open source penetration testing tool. It makes detecting and exploiting SQL injection flaws and taking over the database servers an automated process. sqlmap comes with a great range of features that along with its powerful detection engine make it the ultimate penetration tester. It offers full support for MySQL, Oracle, PostgreSQL, Microsoft SQL Server, Microsoft Access, IBM DB2, SQLite, Firebird, and many other database management systems. It also... -
16
Peewee-async
Asynchronous interface for peewee ORM powered by asyncio
peewee-async is an async extension for the Peewee ORM, enabling non-blocking database access in asyncio-powered Python applications. It allows you to use familiar Peewee models while benefiting from asynchronous I/O, making it ideal for web applications or services that require concurrency. -
17
ERAlchemy
Entity Relation Diagrams generation tool
ERAlchemy is a tool that generates Entity-Relationship (ER) diagrams from databases or SQLAlchemy models and vice versa. It’s useful for database documentation, reverse engineering, and understanding complex schemas. ERAlchemy can export diagrams in formats like Graphviz and Mermaid, making it easy to include in reports or markdown files. -
18
Hello SQL
Spanish-language course repository that teaches fundamentals of SQL
hello-sql is a beginner-friendly, Spanish-language course repository that teaches the fundamentals of SQL and relational databases through practical examples. It focuses mainly on MySQL for lessons due to its ubiquity in education and professional environments, while also introducing PostgreSQL to broaden learners’ exposure to modern database tooling. The materials emphasize real-world query writing, schema design basics, and the mental model behind SELECT, JOIN, GROUP BY, and subqueries.... -
19
django-dbbackup
Management commands to help backup and restore your project database
django-dbbackup is a Django management command extension for backing up and restoring databases and media files. It supports multiple storage backends including local file systems, Amazon S3, and Dropbox. Ideal for automated backup strategies, it simplifies the integration of backup logic into Django projects. -
20
WordOps
Install and manage a high performance WordPress stack
An essential toolset that eases WordPress site and server administration. -
21
Modoboa
Mail hosting made simple
Modoboa is a mail hosting and management platform including a modern and simplified Web User Interface. It provides useful components such as an administration panel and webmail. Modoboa integrates with well known software such as Postfix or Dovecot. A SQL database (MySQL, PostgreSQL or SQLite) is used as a central point of communication between all components. Modoboa is developed with modularity in mind, expanding it is really easy. Actually, all current features are extensions. It is written in Python 3 and uses the Django, jQuery and Bootstrap frameworks. Follow the evolution of your server traffic thanks to a few builtin graphics: messages distribution per type and average size. ... -
22
SSRFmap
Automatic SSRF fuzzer and exploitation tool
SSRFmap is a specialized security tool designed to automate the detection and exploitation of Server Side Request Forgery (SSRF) vulnerabilities. It takes as input a Burp request file and a user-specified parameter to fuzz, enabling you to fast-track the identification of SSRF attack surfaces. It includes multiple exploitation “modules” for common SSRF-based attacks or pivoting techniques, such as DNS zone transfers, MySQL/Postgres command execution, Docker API info leaks, and network scans.... -
23
Dbmate
A lightweight, framework-agnostic database migration tool
Dbmate is a database migration tool, to keep your database schema in sync across multiple developers and your production servers. It is a standalone command line tool, which can be used with Go, Node.js, Python, Ruby, PHP, or any other language or framework you are using to write database-backed applications. This is especially helpful if you are writing many services in different languages, and want to maintain some sanity with consistent development tools. Supports MySQL, PostgreSQL, SQLite, and ClickHouse. Uses plain SQL for writing schema migrations. ... -
24
django-prometheus
Export Django monitoring metrics for Prometheus.io
Export Django monitoring metrics for Prometheus.io. This library provides Prometheus metrics for Django-related operations. Prometheus uses Histogram based grouping for monitoring latencies. You can define custom buckets for latency, adding more buckets decreases performance but increases accuracy. SQLite, MySQL, and PostgreSQL databases can be monitored. Just replace the ENGINE property of your database, replacing django.db.backends with django_prometheus.db.backends. You may want to... -
25
AWS Data Wrangler
Pandas on AWS, easy integration with Athena, Glue, Redshift, etc.
An AWS Professional Service open-source python initiative that extends the power of Pandas library to AWS connecting DataFrames and AWS data-related services. Easy integration with Athena, Glue, Redshift, Timestream, OpenSearch, Neptune, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON, and EXCEL). Built on top of other open-source projects like Pandas, Apache Arrow and Boto3, it offers abstracted functions to execute usual ETL tasks like load/unload data from Data Lakes, Data Warehouses, and Databases. ...
