---
id: types-pymysql
version: "1.2.0.20260807"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# types-PyMySQL — Typing stubs for PyMySQL

License: permissive · Maintenance: active · Downloads: 13.4M/mo

## 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 above — 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

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

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 13.4M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

type stubs pymysql, pymysql type hints, static type checking mysql, pymysql mypy support, type annotations database driver, type-stubs, static-analysis

[View on SkillFed](https://skillfed.io/packages/types-pymysql) · [View on PyPI](https://pypi.org/project/types-pymysql/)