types-PyMySQL

What it is and what it does

types-PyMySQL is a type stub package that provides type annotations for the PyMySQL database driver. It allows static type checkers like mypy, pyright, and ty to understand and validate code that uses PyMySQL, catching type errors before runtime. The package is maintained as part of the typeshed project and aims to cover PyMySQL version 1.2.*.

Type stubs are metadata-only packages with no runtime code—they exist purely to inform type checkers about the shape and types of an external library's API. Installing this package does not change how PyMySQL behaves; it only improves the development experience by enabling IDE autocomplete and static analysis of PyMySQL usage.

Use it for:

• Enable mypy or pyright to type-check code that imports and uses PyMySQL without false positives.
• Get IDE autocomplete and inline type hints when writing PyMySQL database queries and connection code.
• Validate function signatures and return types in a codebase that depends on PyMySQL before deployment.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides type stubs for PyMySQL to enable static type checking of code using the PyMySQL database driver.

Yes, if you use PyMySQL and want static type checking. It has no runtime cost, is actively maintained, carries no security vulnerabilities, and is licensed permissively. Install it alongside PyMySQL in your development environment or type-checking pipeline.

Install

types-pymysql on PyPI

pip install types-pymysql

uv add types-pymysql

poetry add types-pymysql

Installing types-PyMySQL

Before you install

Low friction install with no runtime dependencies. Actively maintained; latest release was 7 days ago and the package has been updated consistently since its 2021 inception.

License in practice

Licensed under Apache-2.0 (permissive), allowing free use, modification, and distribution with minimal restrictions.

Quickstart

pip install types-PyMySQL

import pymysql
conn = pymysql.connect(host='localhost', user='root', password='', database='test')

Requires Python 3.10 or later.

Verify before relying

• Whether type coverage is complete for all PyMySQL 1.2.* APIs or if gaps remain.
• Compatibility with type checkers beyond those tested: mypy 2.3.0, pyright 1.1.411, ty 0.0.59.

Package facts

Evidence: types_pymysql-1.2.0.20260807-py3-none-any.whl

Tags

More Database packages