db-dtypes

Pandas Data Types for SQL systems (BigQuery, Spanner)

db-dtypes Permissive license Active ★ 5,370 v1.7.1 released 2026-07-08

Install

db-dtypes on PyPI

pip

pip install db-dtypes

uv

uv add db-dtypes

poetry

poetry add db-dtypes

Package facts

License	not declared (permissive)
Python support	supports the current Python release (>=3.10)
Install friction	low — pure-Python wheel
Runtime dependencies	4 — numpy, packaging, pandas, pyarrow
Maintenance	actively maintained — 36 days since the last release
Last repo commit	2026-08-13
First released	2021-09-23
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: db_dtypes-1.7.1-py3-none-any.whl

Keywords: sql, pandas

Development Status :: 5 - Production/StableIntended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: Database :: Front-Ends

About db-dtypes

from the package's own PyPI description — quoted content, verbatim

Pandas Data Types for SQL systems (BigQuery, Spanner)

Pandas extension data types for data from SQL systems such as BigQuery.

Library Documentation_

.. |ga| image:: https://img.shields.io/badge/support-GA-gold.svg :target: https://github.com/googleapis/google-cloud-python/blob/main/README.rst#general-availability .. |pypi| image:: https://img.shields.io/pypi/v/db-dtypes.svg :target: https://pypi.org/project/db-dtypes/ .. |versions| image:: https://img.shields.io/pypi/pyversions/db-dtypes.svg :target: https://pypi.org/project/db-dtypes/ .. _Pandas extension data types: https://pandas.pydata.org/docs/development/extending.html#extension-types .. _BigQuery: https://cloud.google.com/bigquery/docs/ .. _Library Documentation: https://googleapis.dev/python/db-dtypes/latest

Installation

Install this library in a virtualenv using pip. virtualenv is a tool to create isolated Python environments. The basic problem it addresses is one of dependencies and versions, and indirectly permissions.

With virtualenv_, it's possible to install this library without needing...

Read as markdown · JSON record · Source repository · Homepage

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

Provides pandas extension data types optimized for SQL systems like BigQuery and Spanner, enabling native representation of database-native types within pandas DataFrames.

Low friction: pure Python wheel with four stable runtime dependencies (numpy, packaging, pandas, pyarrow). Actively maintained with recent release and no archived status.

Permissive license allows commercial and private use with minimal restrictions, typical for Google Cloud libraries.

Usage

pip install db-dtypes
import db_dtypes
import pandas as pd
# Use db_dtypes extension types with pandas DataFrames from BigQuery or Spanner queries

Requires Python >= 3.10; numpy, packaging, pandas, and pyarrow must be installed.

Verdict: Production-ready library (GA status, Production/Stable classifier) with no known vulnerabilities, low install friction, and active maintenance. Well-suited for teams integrating BigQuery or Spanner data into pandas workflows where native SQL type preservation matters.

Needs verification

Whether db_dtypes types are automatically inferred from BigQuery or Spanner schemas or require manual specification
Performance characteristics compared to standard pandas types for large datasets
Compatibility matrix with specific BigQuery or Spanner client library versions

pandas extension types sqlbigquery pandas data typessql database pandas integrationpandas custom dtypes databasespanner pandas typesdatabase native types pandas