awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
PyMySQL avatar

PyMySQL/PyMySQL

0
View on GitHub↗
7,842 stars·1,440 forks·Python·MIT·21 viewspymysql.readthedocs.io↗

PyMySQL

PyMySQL is a MySQL database connector and SQL database driver for Python environments. It serves as a client library that enables Python applications to establish network connections and interact with MySQL database servers.

The library is a pure Python implementation of the MySQL client-server wire protocol. This design allows for MySQL integration and data management without requiring native C extensions.

The project provides capabilities for database connectivity, query execution, and secure access control. It follows the DB-API 2.0 specification to provide a consistent interface for managing connections and data transactions.

Features

  • MySQL Connectors - Serves as a specialized driver for establishing secure network connections to MySQL databases.
  • SQL Query Execution - Provides a standardized interface for executing SQL operations and managing data retrieval from MySQL.
  • MySQL Integrations - Integrates Python applications with MySQL databases to perform data operations without requiring C extensions.
  • SQL Database Connectors - Acts as a low-level interface for executing SQL queries and managing data transactions.
  • Python Native Implementations - Provides a pure-Python implementation of the MySQL wire protocol to eliminate dependencies on native C extensions.
  • Relational Storage Backends - Provides the capability to implement a persistent storage layer for Python applications using a MySQL database.
  • Authentication Plugins - Uses a modular system of authentication plugins to resolve various MySQL server password hashing methods.
  • Secure Database Access - Ensures secure database access by authenticating users through a variety of secure password plugins.
  • Database API Specifications - Follows the DB-API 2.0 specification to ensure a consistent interface for connection and cursor management.
  • Database Clients - MySQL client library.
  • Database Drivers - Pure Python MySQL driver.
  • Database Tools - Pure-Python MySQL client library.

Star history

Star history chart for pymysql/pymysqlStar history chart for pymysql/pymysql

How this analysis was created: This summary and feature list were written by an AI model that read the project's README and public documentation pages. Each feature links to the documentation it came from; stars, license and language come straight from the GitHub API. The model does not read the source code, and the analysis is refreshed when the project is re-analysed. Learn more on our About page.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

Frequently asked questions

What does pymysql/pymysql do?

PyMySQL is a MySQL database connector and SQL database driver for Python environments. It serves as a client library that enables Python applications to establish network connections and interact with MySQL database servers.

What are the main features of pymysql/pymysql?

The main features of pymysql/pymysql are: MySQL Connectors, SQL Query Execution, MySQL Integrations, SQL Database Connectors, Python Native Implementations, Relational Storage Backends, Authentication Plugins, Secure Database Access.

What are some open-source alternatives to pymysql/pymysql?

Open-source alternatives to pymysql/pymysql include: go-sql-driver/mysql — This project is a native Go driver for the MySQL protocol, providing a communication layer that enables applications… sidorares/node-mysql2 — This project is a MySQL database driver for Node.js that establishes network connections and executes SQL queries… mysqljs/mysql — This project is a MySQL database driver and client for Node.js. It provides a JavaScript implementation of the MySQL… datlechin/tablepro — TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL… sosedoff/pgweb — pgweb is a web-based database client and graphical administration tool for PostgreSQL. It provides a browser-based… lib/pq — pq is a PostgreSQL driver for Go that implements the standard database/sql interface. It serves as a connection…

Open-source alternatives to PyMySQL

Similar open-source projects, ranked by how many features they share with PyMySQL.
  • go-sql-driver/mysqlgo-sql-driver avatar

    go-sql-driver/mysql

    15,424View on GitHub↗

    This project is a native Go driver for the MySQL protocol, providing a communication layer that enables applications to interact with relational database management systems. It implements the standard database interface, allowing developers to manage persistent connections, execute queries, and handle transactions within their applications. The driver functions by translating high-level database commands into the specific binary packet format required for communication with MySQL servers. It manages network sessions through a connection pooling mechanism and supports context-aware query cance

    Godatabasegomariadb
    View on GitHub↗15,424
  • sidorares/node-mysql2sidorares avatar

    sidorares/node-mysql2

    4,369View on GitHub↗

    This project is a MySQL database driver for Node.js that establishes network connections and executes SQL queries using a native communication protocol. It functions as an asynchronous SQL client, providing a promise-based query interface and support for async/await patterns to manage non-blocking database operations. The library includes a full MySQL protocol implementation, serving as a toolkit for building custom database servers, proxies, or clients. It also operates as a connection pool manager and an injection prevention tool, utilizing prepared statements and parameterized queries to s

    TypeScript
    View on GitHub↗4,369
  • mysqljs/mysqlmysqljs avatar

    mysqljs/mysql

    18,623View on GitHub↗

    This project is a MySQL database driver and client for Node.js. It provides a JavaScript implementation of the MySQL protocol to facilitate connecting to, querying, and managing data within MySQL databases. The driver includes a connection pool manager to maintain a cache of reusable database connections, reducing the overhead of frequent network handshakes. It also supports row-by-row result streaming to process large datasets without loading entire result sets into memory. Core capabilities cover SQL query execution, the management of database transactions, and the coordination of multiple

    JavaScriptjavascriptmysqlnodejs
    View on GitHub↗18,623
  • datlechin/tableprodatlechin avatar

    datlechin/TablePro

    4,471View on GitHub↗

    TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL and NoSQL databases. It functions as a unified workspace that integrates a code-centric SQL editor with schema visualization tools, allowing developers to manage complex data models and execute queries across diverse database engines. The application distinguishes itself through an agentic AI integration layer that connects language models directly to database tools, enabling automated query generation, optimization, and error fixing with configurable approval gates. It features

    Swift
    View on GitHub↗4,471
  • See all 30 alternatives to PyMySQL→