---
id: queries
version: "2.1.1"
license: BSD
license_treatment: permissive
maintenance: abandoned
---

# queries — Simplified PostgreSQL client built upon Psycopg2

License: permissive · Maintenance: abandoned · Downloads: 283.9K/mo

## What it is and what it does

Queries wraps psycopg2 to reduce boilerplate when building PostgreSQL client applications. It provides a session-based API that handles connection pooling internally, URI-based connection configuration, and automatic type support for UUIDs and Unicode. The package also includes a Tornado integration for asynchronous query execution in web applications.

The package was last released on 2021-11-16 and is no longer maintained. While it remains in production/stable status according to its classifiers, the lack of updates means it has not been tested against recent Python or PostgreSQL versions and will not receive bug fixes or security updates.

Use it for:

- Building synchronous PostgreSQL client scripts or applications where connection pooling and URI-based configuration reduce setup code.
- Integrating PostgreSQL queries into Tornado web applications using the TornadoSession class for asynchronous database access.
- Maintaining legacy applications that already depend on queries and do not require modern Python version support.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Queries is a simplified wrapper around psycopg2 that provides a session-based API for connecting to and querying PostgreSQL databases, with built-in connection pooling and support for both synchronous and asynchronous (Tornado) operations.

No, not for new projects. The package is abandoned (last release 2021-11-16) and will not receive maintenance, security updates, or compatibility fixes. For new PostgreSQL work, use actively maintained alternatives. Only consider it if you are maintaining existing code that already depends on it and cannot migrate.

## Install

pip install queries
uv add queries
poetry add queries

## Installing queries

Before you install: Installation friction is high with no runtime dependencies listed. The package has not been maintained since 2021-11-16 and is marked as abandoned, meaning it will not receive updates for modern Python or PostgreSQL versions.

License in practice: Queries is BSD licensed under a permissive license, meaning you can use, modify, and distribute it freely with minimal restrictions, though you must include the license notice.

Quickstart:

import queries

with queries.Session('postgresql://user@localhost/dbname') as session:
    for row in session.query('SELECT * FROM table_name'):
        print(row)

Requires a running PostgreSQL server and psycopg2 (or psycopg2cffi for PyPy) to be installed; the package itself declares no explicit runtime dependencies in its metadata.

Verify before relying:

- Whether psycopg2 is an implicit runtime dependency not declared in package metadata
- Current compatibility with Python versions beyond 3.8 given the maintenance gap since 2021-11-16
- Whether connection pooling behavior remains stable under modern PostgreSQL versions

## Package facts

- License: BSD (permissive)
- Python support: unspecified
- Install friction: high
- Maintenance: abandoned
- Downloads: 283.9K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

postgresql client wrapper, psycopg2 simplified api, postgres connection pooling, tornado async postgresql, python postgresql session, postgres query builder, database connection management, abandoned, legacy-maintenance-only

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